in-memory db? gadfly?

[chris]

I'm looking for a completely in-memory sql db. I have seen gadfly, but
its startup method seems to require a directory for the on-disk file
storage. I have a script and I want to create a database/tables in the
script, insert some data (not much), and execute some queries, all
in-memory. Don't need to persist anything. Possible, or am I just
talking crazy here?

Thanks,
Chris

 

[Peter Hansen]

I'm looking for a completely in-memory sql db. I have seen gadfly, but
its startup method seems to require a directory for the on-disk file
storage. I have a script and I want to create a database/tables in the
script, insert some data (not much), and execute some queries, all
in-memory. Don't need to persist anything. Possible, or am I just
talking crazy here?

I believe SQLite will do this easily, if you use a connection name of
":memory:" instead of a file name.

Wrapped with either of:

- Gerhard Häring's pysqlite (http://initd.org/tracker/pysqlite)

- Roger Binns' APSW (http://www.rogerbinns.com/apsw.html)

I believe the primary distinction is that pysqlite is DB-API 2.0
compliant, while APSW is a "thin" wrapper that may or may not feel more
comfortable for you, and which provides access to more of SQLite's
features.

(Both appear to have been around roughly the same length of time, though
pysqlite seems better known.)

-Peter

 

[chris]

sqlite worked perfectly, thanks.

 

[chris]

sqlite worked perfectly, thanks.