On Thu, Mar 14, 2013 at 9:40 AM, Vitor Rosa <[email protected]>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 using WAL journal_mode. > > But how can I create a WAL db? > You cannot have an in-memory WAL database (or at least not without writing your own custom in-memory VFS). If you want WAL, put the database on disk. Then everything should work just fine for you. If you do not care about persistence, set "PRAGMA synchronous=OFF". > > Many thanks, > > Vitor. > > Vitor Rosa > Corporate Relations > Local BEST Group Almada > Faculdade de Ciências e Tecnologia da Universidade Nova de Lisboa > +351 965 707 240 > > > 2013/3/14 Richard Hipp <[email protected]> > > > On Wed, Mar 13, 2013 at 12:45 PM, Vitor Rosa <[email protected] > > >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 trying to change the journal mode to WAL on an in-memory > > database? > > > > -- > > D. Richard Hipp > > [email protected] > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
