Re: [sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Richard Hipp
On Thu, Mar 14, 2013 at 9:40 AM, Vitor Rosa wrote: > Hello, > > After reading more carefully the documentation I found that, but I want to > create a db where I'm having just one writer and multiple readers, but I > need that the readers never get "db locked" when they are reading so I > thought u

Re: [sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Vitor Rosa
Hello, After reading more carefully the documentation I found that, but I want to create a db where I'm having just one writer and multiple readers, but I need that the readers never get "db locked" when they are reading so I thought using WAL journal_mode. But how can I create a WAL db? Many th

Re: [sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Richard Hipp
On Wed, Mar 13, 2013 at 12:45 PM, Vitor Rosa wrote: > Hello, > > I'm using windows 7 (64 bits) with sqlite 3.7.15.2 and I can't change > journal_mode to WAL, it always return memory mode. > what I can do? > For an in-memory database, the only allowed journal modes are OFF and MEMORY. Are you try

[sqlite] problem with journal_mode memory to wal

2013-03-14 Thread Vitor Rosa
Hello, I'm using windows 7 (64 bits) with sqlite 3.7.15.2 and I can't change journal_mode to WAL, it always return memory mode. what I can do? Many thanks, Vitor. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailm