Re: [sqlite] SQLite and Memory Databases

2011-02-09 Thread Igor Tandetnik
Bastian Clarenbach wrote: > My environment does not have direct file access, instead I can only request > files and get a memblock returned that contains the entire file. You should be able to write a virtual file system that reads and writes to a block of

Re: [sqlite] SQLite and Memory Databases

2011-02-09 Thread Bastian Clarenbach
e in 1 > > The biggest question with this is whether you expect your entire database > file to be small enough that you would want to hold it in memory all that > the same time. SQLite handles databases in memory just fine: address the > filename as ':memory:'. See > > http://w

Re: [sqlite] SQLite and Memory Databases

2011-02-09 Thread Simon Slavin
whether you expect your entire database file to be small enough that you would want to hold it in memory all that the same time. SQLite handles databases in memory just fine: address the filename as ':memory:'. See http://www.sqlite.org/inmemorydb.html You can delve into the depths of SQLit

[sqlite] SQLite and Memory Databases

2011-02-09 Thread Bastian Clarenbach
Hi, My environment does not have direct file access, instead I can only request files and get a memblock returned that contains the entire file. I am trying to figure out how to do one, preferably both, of the following scenarios. 1. I want to create a database 'offline' and then load and use