[sqlite] In-memory SQLite and fork()

2010-07-27 Thread Daniel Heath
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

2009-03-10 Thread Andrei VANCEA
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

2009-01-22 Thread D. Richard Hipp
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 > SQLITE_OMIT_DISKIO

Re: [sqlite] In memory SQLite

2009-01-22 Thread Ionut Subasu
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 *SQLITE_TEMP_S

Re: [sqlite] In memory SQLite

2009-01-22 Thread D. Richard Hipp
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, > l

[sqlite] In memory SQLite

2009-01-22 Thread Ionut Subasu
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

2009-01-21 Thread 钱晓明
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 that everything should be

[sqlite] In memory SQLite

2009-01-21 Thread 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 that everything should be on main memory, from journals, logs...) Regards, Ionut

[sqlite] in memory SQLite in C/C++

2005-10-20 Thread Rajan, Vivek K
Hello- As I understand it is possible to us in-memory SQLite database. Does someone have example C/C++ code to demonstrate techniques for using in-memory SQLite database? Thanks in advance. Rajan