The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

OpenInteract::Session::SQLite - Create sessions within a SQLite data source

SYNOPSIS

# In your configuration file

[session_info]
class       = Apache::Session::SQLite
...

[session_info.params]
dbname = /home/httpd/oi/conf/sqlite_sessions
...

[system_alias]
session       = OpenInteract::Session::SQLite

DESCRIPTION

Provide a '_create_session' method for OpenInteract::Session so we can use a SQLite data source as a backend for Apache::Session::SQLite.

Note that failure to create the session throws a '310' error, which clears out the session cookie so it does not keep happening. (See OpenInteract::Error::System for the code.)

This code is fairly untested under normal server loads. I do not know what the behavior of SQLite is with many concurrent reads and writes -- you might want to read the SQLite documentation about modifying the attributes of the data file so that every write is not synchronized with the filesystem.

METHODS

_create_session( $session_id )

Overrides the method from parent OpenInteract::Session, serializing sessions to and from a file named in the configuration, as specified below. This file should have the following table defined:

CREATE TABLE sessions (
  id char(32) not null,
  a_session text,
  primary key( id )
)
  • session_info.params.dbname ($)

    Specify the file used for serializing sessions. It should already have the 'sessions' table defined.

BUGS

None known.

TO DO

Nothing.

SEE ALSO

Apache::Session::SQLite

OpenInteract::Session

COPYRIGHT

Copyright (c) 2001-2002 intes.net, inc.. All rights reserved.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHORS

Chris Winters <chris@cwinters.com>