Re: [sqlite] problem with journal_mode memory to wal
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 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 > > > 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 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
Re: [sqlite] problem with journal_mode memory to wal
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 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 > 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 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
Re: [sqlite] problem with journal_mode memory to wal
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 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