[horde] SQL backend for session storage

[Jon Parise]

On Wed, Aug 21, 2002 at 12:10:39PM -0400, Chuck Hagenbuch wrote:

> > I should check CVS from time to time :) There already is a sql driver
> > for session storage in horde/lib/SessionHandler... works pretty good
> > except the fact that the scripts/db/sessionhandler.sql script that
> > creates the horde_sessionhandler table doesn't fit for my PostgreSQL
> > (7.1.2). The field session_data is declared as LONGBLOB there. This data
> > type (or its equivalent) is called BYTEA in pgsql. However, I don't know
> > why serialized session data should be stored as binary string, so I just
> > changed the type to TEXT and it works now (BYTEA values have to be
> > escaped before any WRITE operations, but since the stuff is passed
> > without any escaping directly to the DB, pgsql module raises an error).
> 
> If you want to submit a pgsql-specific .sql file, we'll include it in CVS.

An SQL-generic file would be preferable, of course.  Is there a reason
why the existing schema can't use a TEXT field type?

-- 
Jon Parise (jon at horde.org) :: The Horde Project (http://horde.org/)