On Nov 30, 2005, at 4:18 PM, Cariotoglou Mike wrote:
The concept of in-memory database would be greatly enhanced if there was a mechanism to serialize the internal cache to/from a stream (not necessarily a disk stream). In-memory databases are extremely useful for a number of applications, but ar a PITA to initalize/persist.
With the very exciting virtual OsFile API that is being developed, I'm wondering if we couldn't serialize a SQLite database ourselves. I haven't looked at the entire API, so maybe this isn't possible, but if you can create multiple "subclasses" of OsFile in the same application, then you could have an on-disk subclass for your file system, and an in-memory one as well, and theoretically SQLite wouldn't know the difference. Then you could attach one to another and copy tables back and forth.
