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 memory rather than a physical file. See

Re: [sqlite] SQLite and Memory Databases

2011-02-09 Thread Bastian Clarenbach
Yes, I expect the database to be small enough. It is the loading a :memory: database from and storing to memory blocks that still eludes me. I will take a look at the backup link. Thanks! On 9 February 2011 13:48, Simon Slavin wrote: > > On 9 Feb 2011, at 10:14am, Bastian Clarenbach wrote: > >

Re: [sqlite] SQLite and Memory Databases

2011-02-09 Thread Simon Slavin
On 9 Feb 2011, at 10:14am, 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. I am trying > to figure out how to do one, preferably both, of the following scenarios. > > 1. I w

[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 tha