view release on metacpan or  search on metacpan

README  view on Meta::CPAN

    To store session data in SQL database, you first need to create a
    suitable table for it with the following command:

        -- This syntax for for Postgres; flavor to taste
        CREATE TABLE sessions (
            session_id       CHAR(32) NOT NULL,
            remote_addr      inet,
            creation_time    timestamp,
            last_access_time timestamp,
            duration         interval
        );

    You can also add any number of additional columns to the table, but the
    above fields are required.

    For any additional columns you add, if you would like to expire that
    column individually, you need to an additional column to do that. For
    example, to add a column named "order_id" which you want to allow to be
    expired, you would add these two columns:

        order_id            int,
        order_id_exp_secs   int,

    If you want to store the session data in other table than "sessions",
    you will also need to specify TableName attribute as the first argument
    to new():

        use CGI::Session;

        $session = CGI::Session->new("driver:pure_sql;serializer:sql_abstract", undef,
                            {Handle=>$dbh, TableName=>'my_sessions'});

    Every write access to session records is done through PostgreSQL own row
    locking mechanism, enabled by `FOR UPDATE' clauses in SELECTs or
    implicitly enabled in UPDATEs and DELETEs.

    To write your own drivers for CGI::Session refere CGI::Session manual.

COPYRIGHT
    Copyright (C) 2003-2010 Mark Stosberg. All rights reserved.

    This library is free software and can be modified and distributed under
    the same terms as Perl itself.

CONTRIBUTING
    Patches, questions and feedback are welcome. Please use the bug tracker
    to submit bugs and patches, and e-mail directly with questions and
    feedback.

    https://rt.cpan.org/Public/Dist/Display.html?Name=CGI-Session-Driver-pur
    e_sql

AUTHOR
    Mark Stosberg <mark@summersault.com>

SEE ALSO
    *   CGI::Session - CGI::Session manual

    *   CGI::Session::Tutorial - extended CGI::Session manual

    *   CGI::Session::CookBook - practical solutions for real life problems

    *   RFC 2965 - "HTTP State Management Mechanism" found at
        ftp://ftp.isi.edu/in-notes/rfc2965.txt

    *   CGI - standard CGI library

    *   Apache::Session - another fine alternative to CGI::Session