in reply to SQLite database (or any) file 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?
      ???
      open file
      open memory
      copy from file to memory
      close file
      1+1=2
        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...