Simon Willison’s Weblog

I can see the 'In memory databases' being really great for apps which need session support. SQLite looks like it could be just the thing for lightweight db queries.

Danny Shepherd - 5th September 2003 10:15 - #

(Py)SQLite makes a nice database for basic applications as long as you are aware of its limititations - everything is a string, there is no referential integrity and, most critically, the _entire_ database is locked during writes. These and other limitations are documented on the website.

Matt Goodall - 5th September 2003 13:50 - #

Oh yeah, SQLite is not an in memory database. Besides, I would say SQLite is far too heavy for session support - a Python dict or a bsddb (in memory or on disk) should be more than adequate.

Matt Goodall - 5th September 2003 14:11 - #

2003-05-09: In-memory databases are now a feature of the standard SQLite library. To open an in-memory database, use filename ":memory:".

Adam - 5th September 2003 17:21 - #

I had no idea SQLite supported in-memory databases - that's a pretty cool feature. There's not much documentation about it though (I found a mention of it on the SQLite Wiki but that's about it).

Simon Willison - 5th September 2003 19:02 - #

For a slightly different view on the world take a look at Patrick O'Brien's PyPerSyst. Its a Python port of Prevayler and certainly looks very interesting.

Andy Todd - 5th September 2003 21:04 - #

Darned, i thought i found the solution here, now the above site is gone :(

Alain - 12th November 2004 19:29 - #