Re: Standard Solutions with Perl DBI::Pg for results tables - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Standard Solutions with Perl DBI::Pg for results tables
Date
Msg-id 3EB80803.2060700@cvc.net
Whole thread Raw
In response to Standard Solutions with Perl DBI::Pg for results tables  (Mr Mat psql-mail <psql-mail@freeuk.com>)
List pgsql-general
1/ 10 each per page seems small, but maybe not if your retrieved row is large.

2/ cookies can be used to store AUTHENTICATION OF A USER, but since you are not doing that, cookies probably are not
whatyou want. 

3/ Form values originally used to search with can be used, and returned using:
    A/ Javascript filling in POST values and submitting, when a button is pressed
    B/ GET values on a URL on a button.
    C/ GET values on a URL on a text anchor

4/ to do 3 above, you will need either:
    A/ A cursor search in your original and second search.
    B/ A simulated cursor using the files system stored result set,
        in the manner of PHP library 'ADODB'. Perhaps
        Perl has such a library.


It comes down to two parts:

    A/ returning the same search criteria with a page begin and page size value
        in a form.
    B/ using native or simulated cursors to access the search

Mr Mat psql-mail wrote:
> I have users doing searches via a web front end.
>
> No authentication is required.
>
> I would like the result of the last search of each user to be stored in
> a temporary table to allow for re-ordering, searching within results,
> and stepping through results 10 (n) at a time using offset and limit.
>
> Currently I am preforming the search again for each of these - pretty
> annoying when it might take 10 minutes to return the results to begin
> with!
>
> Is there a standard way of doing this?
> I'd thought perhaps session id's and cookies?
>
> Can i specify a lifespan for a temporary table?
>
> Thanks!
>
> Matt
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>


pgsql-general by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Small bug in postgres' ./configure script and invalid bug-report-link on website
Next
From: Peter Childs
Date:
Subject: Re: What is the best practise for "autonumbering"..?