durusmail: quixote-users: sqlite and persistent sessions
sqlite and persistent sessions
2005-05-31
sqlite and persistent sessions
mso@oz.net
2005-05-31
sqlite is incompatible with Titus' session code and my update in two ways
at least:

- Replaceable parameters use the "?" or ":name" syntax rather than
"%(name)s".

- cursor.rowcount is not usable.  Sqlite does not know in advance how many
result rows exist.  You have to actually fetch the data and see how many
rows you fetched.

PySQLite usage guide (long):
http://initd.org/pub/software/pysqlite/doc/usage-guide.html

PySQLite also returns text objects as unicode.  I don't know whether that
causes problems for pickle.

I suggest mentioning this in the docstring, and asking anyone who
implements a SqliteSessionStore to contribute it.

--
-- Mike Orr 

reply