You can also make a SQLite database be in-memory, giving you the performance benefits of skipping the disk.
Yes, I love the in-memory database -- especially for my automated testing in Django. However, the OP said that memory footprint was a concern (granted, I don't know how much data they were talking about -- a couple dozen rows in 1-2 tables might make this an attractive option).
-tkc -- http://mail.python.org/mailman/listinfo/python-list