[sqlite] problem with journal_mode memory to wal
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/mailman/listinfo/sqlite-users
Re: [sqlite] problem with journal_mode memory to wal
On Wed, Mar 13, 2013 at 12:45 PM, Vitor Rosa v.r...@campus.fct.unl.ptwrote: 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
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 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
Re: [sqlite] problem with journal_mode memory to wal
On Thu, Mar 14, 2013 at 9:40 AM, Vitor Rosa v.r...@campus.fct.unl.ptwrote: 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