Re: SQLite databasefile in main memory!

SQLite can live in memory alone, just connect to the database :memory:. The SQLite wiki has more information on SQLite Table in Memory.

Comment on Re: SQLite databasefile in main memory!

Replies are listed 'Best First'.
Re^2: SQLite databasefile in main memory! by Ace128 (Hermit) on Oct 06, 2005 at 10:18 UTC
Cool! But that is not using a database (file) that already exists (what I could find), but using memory from scratch! How to actually "move" the file there? How about any file?	[reply]
Re^3: SQLite databasefile in main memory! by Anonymous Monk on Oct 06, 2005 at 10:35 UTC
??? open file open memory copy from file to memory close file 1+1=2	[reply]
Re^4: SQLite databasefile in main memory! by Ace128 (Hermit) on Oct 06, 2005 at 13:50 UTC
Err, and exactly how do I do that? File is binary, and the sql memory is for queries... Dumping the binary database could be possible though... Extract and do "INSERT" queries in the memory one...	[reply]