CGI::Session::Driver::sqlite(3) User Contributed Perl Documentation CGI::Session::Driver::sqlite(3)NAME
CGI::Session::Driver::sqlite - CGI::Session driver for SQLite
SYNOPSIS
$s = new CGI::Session("driver:sqlite", $sid, {DataSource=>'/my/folder/sessions.sqlt'});
$s = new CGI::Session("driver:sqlite", $sid, {Handle=>$dbh});
or
$s = new CGI::Session('driver:sqlite', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
Handle=>$dbh,
});
DESCRIPTION
sqlite driver stores session data in SQLite files using DBD::SQLite DBI driver. More details see CGI::Session::Driver::DBI, its parent
class.
DRIVER ARGUMENTS
Supported driver arguments are DataSource and Handle. At most only one of these arguments can be set while creating session object.
DataSource should be in the form of "dbi:SQLite:dbname=/path/to/db.sqlt". If "dbi:SQLite:" is missing it will be prepended for you. If
Handle is present it should be database handle ($dbh) returned by DBI::connect().
As of version 1.7 of this driver, the third argument is NOT optional. Using a default database in the temporary directory is a security
risk since anyone on the machine can create and/or read your session data. If you understand these risks and still want the old behavior,
you can set the "DataSource" option to '/tmp/sessions.sqlt'.
BUGS AND LIMITATIONS
None known.
LICENSING
For support and licensing see CGI::Session
perl v5.16.3 2008-07-16 CGI::Session::Driver::sqlite(3)
Check Out this Related Man Page
CGI::Session::Driver::sqlite(3pm) User Contributed Perl Documentation CGI::Session::Driver::sqlite(3pm)NAME
CGI::Session::Driver::sqlite - CGI::Session driver for SQLite
SYNOPSIS
$s = CGI::Session->new("driver:sqlite", $sid, {DataSource=>'/my/folder/sessions.sqlt'});
$s = CGI::Session->new("driver:sqlite", $sid, {Handle=>$dbh});
or
$s = CGI::Session->new('driver:sqlite', undef,
{
TableName=>'session',
IdColName=>'my_id',
DataColName=>'my_data',
Handle=>$dbh,
});
DESCRIPTION
sqlite driver stores session data in SQLite files using DBD::SQLite DBI driver. More details see CGI::Session::Driver::DBI, its parent
class.
DRIVER ARGUMENTS
Supported driver arguments are DataSource and Handle. At most only one of these arguments can be set while creating session object.
DataSource should be in the form of "dbi:SQLite:dbname=/path/to/db.sqlt". If "dbi:SQLite:" is missing it will be prepended for you. If
Handle is present it should be database handle ($dbh) returned by DBI::connect().
As of version 1.7 of this driver, the third argument is NOT optional. Using a default database in the temporary directory is a security
risk since anyone on the machine can create and/or read your session data. If you understand these risks and still want the old behavior,
you can set the "DataSource" option to '/tmp/sessions.sqlt'.
BUGS AND LIMITATIONS
None known.
LICENSING
For support and licensing see CGI::Session
perl v5.12.4 2011-07-08 CGI::Session::Driver::sqlite(3pm)
Hi to everyone,
i need some help creating my own graphics driver for HP-UX. I am planning on buying a nvidia card for my HP Workstation.
What do i need to create a new driver?
I´m a UNIX beginner, so please explain it so that i can understand it.
hilbi (1 Reply)
Hello,
I am having a hard time trying to do the following:
I have a file that looks like this:
0 CacheMaxConn 4 64
0 RMThread 16 3423423
7 DataSource 0 /hello/sas/ses
0 {94545B4-E343-1410-81E4-08000000} 3 DDBE
3 ... (4 Replies)
i'm on freebsd 5.2.1, and from a fresh installation i've used pkg_add for the latest ported version of apache, as well as installing php 5. supposedly php5 comes with native support for sqlite (in the binary package), and this is what i added.
i am trying to install a site engine (the 'gyrator'... (0 Replies)
Hi everybody,
We have a cgi application which accesses sqlite database. It works fine in Linux environment but the same code doesn't enter data into the database when done in HP-UX environment. Should the codes vary depending on whether it is Linux or HP-UX.
Regards
Ruma (1 Reply)
I looking for someone who can help me port a Linux Driver to a OpenBSD( OS X ) Unix Driver. The driver is for a Logic Controls LD9000 USB Customer Display. The currently don't have a driver for the mac operating system, but they do however have one for the Linux OS.
So, I am just trying to... (8 Replies)
Hello All,
I am trying to write a Perl script that is using 'SQLite' as the application needs a very light weight Database. I wanted to know how to catch exceptions when I run queries in SQLite. Without this the Perl script comes to a halt everytime an exception occurs. Please help.
Regards,... (4 Replies)
Hi everyone,
I have a requirement that requires me to fill an sqlite database with 100,000 entries (no duplicates).
I will start out by giving the command that will insert the values necessary to populate the database:
# sqlite /var/local/database/dblist "insert into list... (2 Replies)
Ok,
so i've been having to write to flat files lately and then making my script read information from the flat file and then work off of that.
i dont want to keep doing that because i believe it creates a mess. i like to keep my work all to one script instead of having that one script... (7 Replies)
I have taken putty session of a server from two separate machines namely HOST1(3 sessions) and HOST2(1 Session) .
However w command says there are 5 users
Confused over the output any clue will be appreciated.
# w
09:29:36 up 34 days, 15:48, 5 users, load average: 0.62, 4.33, 8.16
USER ... (3 Replies)
dear colleagues,
please help,
i have a linux server (linux 5.3) running oracle 10g database for application.
there are 98 users who are using that oracle application over LAN. but during the working hours the user session is increased (min 150 users) bcos one user is working on different client... (7 Replies)
Hi guys.
Solaris has a way of logging sessions of any user connected to the server via ssh. Session logs are saved in /var/tmp/session_log on any Solaris machine.
How can we achieve the same on Linux Redhat ???
Regards (1 Reply)
Starting this new thread, because the older one has been shut,
Looking in my linux distro, firefox and about:config something like the following appears
storage.vacuum.last.places.sqlite: 1474885593 When using bleachbit, this very file named places.sqlite I am told it can't be deleted. In... (4 Replies)