On Thu, Mar 14, 2013 at 9:40 AM, Vitor Rosa <v.r...@campus.fct.unl.pt>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 <d...@sqlite.org> > > > On Wed, Mar 13, 2013 at 12:45 PM, Vitor Rosa <v.r...@campus.fct.unl.pt > > >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 > > d...@sqlite.org > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users