Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

cgi::session::driver::postgresql(3pm) [debian man page]

CGI::Session::Driver::postgresql(3pm)			User Contributed Perl Documentation		     CGI::Session::Driver::postgresql(3pm)

NAME

       CGI::Session::Driver::postgresql - PostgreSQL driver for CGI::Session

SYNOPSIS

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

DESCRIPTION

       CGI::Session::PostgreSQL is a CGI::Session driver to store session data in a PostgreSQL table.

STORAGE

       Before you can use any DBI-based session drivers you need to make sure compatible database table is created for CGI::Session to work with.
       Following command will produce minimal requirements in most SQL databases:

	   CREATE TABLE sessions (
	       id CHAR(32) NOT NULL PRIMARY KEY,
	       a_session BYTEA NOT NULL
	   );

       and within your code use:

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

       Please note the ColumnType argument. PostgreSQL's text type has problems when trying to hold a null character. (Known as "" in Perl, not
       to be confused with SQL NULL). If you know there is no chance of ever having a null character in the serialized data, you can leave off the
       ColumnType attribute. Using a BYTEA column type and "ColumnType => 'binary'" is recommended when using Storable as the serializer or if
       there's any possibility that a null value will appear in any of the serialized data.

       To use different column names, change the 'create table' statement, and then simply do this:

	   $s = CGI::Session->new('driver:pg', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       DataSource=>'dbi:pg:dbname=project',
	   });

       or

	   $s = CGI::Session->new('driver:pg', undef,
	   {
	       TableName=>'session',
	       IdColName=>'my_id',
	       DataColName=>'my_data',
	       Handle=>$dbh,
	   });

       For more details see CGI::Session::Driver::DBI, parent class.

       Also see sqlite driver, which exercises different method for dealing with binary data.

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.

AUTHORS

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

       Matt LeBlanc contributed significant updates for the 4.0 release.

LICENSING

       For additional support and licensing see CGI::Session

perl v5.12.4							    2011-07-08				     CGI::Session::Driver::postgresql(3pm)

Check Out this Related Man Page

CGI::Session::Driver::file(3)				User Contributed Perl Documentation			     CGI::Session::Driver::file(3)

NAME

       CGI::Session::Driver::file - Default CGI::Session driver

SYNOPSIS

	   $s = new CGI::Session();
	   $s = new CGI::Session("driver:file", $sid);
	   $s = new CGI::Session("driver:file", $sid, {Directory=>'/tmp'});

DESCRIPTION

       When CGI::Session object is created without explicitly setting driver, file will be assumed.  file - driver will store session data in
       plain files, where each session will be stored in a separate file.

       Naming conventions of session files are defined by $CGI::Session::Driver::file::FileName global variable.  Default value of this variable
       is cgisess_%s, where %s will be replaced with respective session ID. Should you wish to set your own FileName template, do so before
       requesting for session object:

	   use CGI::Session::Driver::file; # This line is mandatory.
	   # Time passes...
	   $CGI::Session::Driver::file::FileName = "%s.dat";
	   $s = new CGI::Session();

       For backwards compatibility with 3.x, you can also use the variable name $CGI::Session::File::FileName, which will override the one above.

   DRIVER ARGUMENTS
       If you wish to specify a session directory, use the Directory option, which denotes location of the directory where session ids are to be
       kept. If Directory is not set, defaults to whatever File::Spec->tmpdir() returns.  So all the three lines in the SYNOPSIS section of this
       manual produce the same result on a UNIX machine.

       If specified Directory does not exist, all necessary directory hierarchy will be created.

       By default, sessions are created with a umask of 0660. If you wish to change the umask for a session, pass a UMask option with an octal
       representation of the umask you would like for said session.

NOTES

       If your OS doesn't support flock, you should understand the risks of going without locking the session files. Since sessions tend to be
       used in environments where race conditions may occur due to concurrent access of files by different processes, locking tends to be seen as
       a good and very necessary thing. If you still want to use this driver but don't want flock, set $CGI::Session::Driver::file::NoFlock to 1
       or pass "NoFlock => 1" and this driver will operate without locks.

LICENSING

       For support and licensing see CGI::Session

perl v5.16.3							    2008-07-16					     CGI::Session::Driver::file(3)
Man Page