Note: This applies only to SQLite databases being used with SQLObject.
Suppose you are working exclusively with SQLite databases for your particular project. If your databases happen to be small (or you happen to have a lot of RAM), you may want to load it into memory. However, this may not always be the most straightforward task to accomplish.
Additional Requirements: apsw
One solution (unfortunately, probably far from optimal for larger databases) is to dump the SQL from a file-db into a memory-db. Whenever you're done working in memory, you can re-dump the SQL back into the file DB.
If you want to do this, you'll probably want to use the following code: