View on
MetaCPAN
Sherzod Ruzmetov > CGI-Session-3.95 > CGI::Session::PostgreSQL

Download:
CGI-Session-3.95.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  10
Open  10
Stalled  1
View/Report Bugs
Module Version: 1.2   Source  

NAME ^

CGI::Session::PostgreSQL - PostgreSQL driver for CGI::Session

SYNOPSIS ^

    use CGI::Session;
    $session = new CGI::Session("driver:PostgreSQL", undef, {Handle=>$dbh});

For more examples, consult CGI::Session manual

DESCRIPTION ^

CGI::Session::PostgreSQL is a CGI::Session driver to store session data in a PostgreSQL table. To write your own drivers for CGI::Session refere CGI::Session manual.

STORAGE ^

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

    CREATE TABLE sessions (
        id CHAR(32) NOT NULL,
        a_session TEXT NOT NULL
    );

You can also add any number of additional columns to the table, but the above "id" and "a_session" are required. 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 = new CGI::Session("driver:PostgreSQL", 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.

COPYRIGHT ^

Copyright (C) 2002 Cosimo Streppone. All rights reserved.

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

AUTHOR ^

Cosimo Streppone <cosimo@cpan.org>, heavily based on the CGI::Session::MySQL driver by Sherzod Ruzmetov, original author of CGI::Session.

SEE ALSO ^

syntax highlighting: