[sqlite] In-memory SQLite and fork()

Hi All, I've been using sqlite to run my applications tests; it's small and light and all is well. Lately I have been trying to improve the concurrency of these tests. The most obvious approach is to setup my in-memory database (using the ':memory:' location), then call fork() for each test. The

[sqlite] In-memory SQLite multithreaded access

Hello, I want to use the in-memory storage for the following scenario : - The content is added in the beginning (multiple insert statements) - Afterwards, all the accesses will consist only of select queries. The problem is that I want the read accesses to be executed, in parallel, from multiple

Re: [sqlite] In memory SQLite

On Jan 22, 2009, at 4:20 AM, Ionut Subasu wrote: > The problem for me is at compile time. > Since we have a new OS we do not have implemented the posix and the > file > access librays(like fstat...). > Therefore everything should work in memory. > So I have set the >

Re: [sqlite] In memory SQLite

The problem for me is at compile time. Since we have a new OS we do not have implemented the posix and the file access librays(like fstat...). Therefore everything should work in memory. So I have set the SQLITE_OMIT_DISKIOflag and also

Re: [sqlite] In memory SQLite

On Jan 21, 2009, at 12:15 PM, Ionut Subasu wrote: > Hi, > > I am trying to use SQLite in a new operating system. > Right now we don't support a large functionality > Is there a way to make SQLite to work entirely into memory? > (meaning that everything should be on main memory, from journals, >

[sqlite] In memory SQLite

Hi, I am trying to use SQLite in a new operating system. Right now we don't support a large functionality Is there a way to make SQLite to work entirely into memory? (meaning that everything should be on main memory, from journals, logs...) Regards, Ionut

Re: [sqlite] In memory SQLite

use ":memory:" as the path of sqlite file when invoke sqlite3_open. 2009/1/22 Ionut > Hi, > > I am trying to use SQLite in a new operating system. > Right now we don't support a large functionality > Is there a way to make SQLite to work entirely into memory? > (meaning

[sqlite] In memory SQLite

Hi, I am trying to use SQLite in a new operating system. Right now we don't support a large functionality Is there a way to make SQLite to work entirely into memory? (meaning that everything should be on main memory, from journals, logs...) Regards, Ionut