Re: [sqlite] WAL mode is reliable?

> boun...@sqlite.org] On Behalf Of Richard Hipp > (2) WAL really does give better concurrency since it allows other processes > to continue reading while a single process is writing to the database. In > rollback mode you can have one writer *or* multiple readers. In WAL mode > you can have one

Re: [sqlite] WAL mode is reliable?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/11/11 11:32, Paxdo Presse wrote: > Roger, I meant: I feel that WAL is rarely used with its new > capabilities. Outside almost 100 million Android devices? > SQLite + WAL may, perhaps, now compete with Mysql / postgres to handle > web apps with

Re: [sqlite] WAL mode is reliable?

> >> I feel that WAL is rarely used now. > > It is used on my Android phone running 2.3. That is almost 100 million > devices with all sorts of programs and crash scenarios. Is that rare? Roger, I meant: I feel that WAL is rarely used with its new capabilities. SQLite + WAL may, perhaps,

Re: [sqlite] WAL mode is reliable?

On 3 Nov 2011, at 6:05pm, Paxdo Presse wrote: > You think SQLite can handle a website / web app that has 1000 readers per > day, including 200 to 300 who will write regularly? You should be able to handle 10,000 posts a day without problems. A single INSERT command keeps the database locked

Re: [sqlite] WAL mode is reliable?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/11/11 11:05, Paxdo Presse wrote: > I feel that WAL is rarely used now. It is used on my Android phone running 2.3. That is almost 100 million devices with all sorts of programs and crash scenarios. Is that rare? Roger -BEGIN PGP

Re: [sqlite] WAL mode is reliable?

On 3 Nov 2011, at 5:44pm, Richard Hipp wrote: > On Thu, Nov 3, 2011 at 12:13 PM, Simon Slavin wrote: > >> >> If I start getting contention issues (locks failing because of too many >> concurrent attempts at access) then I'll look into using some PRAGMAs, >> possibly

Re: [sqlite] WAL mode is reliable?

Thank you M. Hipp ! I feel that WAL is rarely used now. It is difficult to get opinions / feedback on this feature. And for users of database servers (MySQL, Postgres, etc.). It is impossible to have a reliable database without a server. You think SQLite can handle a website / web app that

Re: [sqlite] WAL mode is reliable?

On Thu, Nov 3, 2011 at 12:13 PM, Simon Slavin wrote: > > If I start getting contention issues (locks failing because of too many > concurrent attempts at access) then I'll look into using some PRAGMAs, > possibly switching to WAL. > > Several points: (1) You only have to

Re: [sqlite] WAL mode is reliable?

On 3 Nov 2011, at 3:57pm, Paxdo Presse wrote: > Even if the requests are very fast, it seems risky not to use WAL? As opposed to no journal ? Yes, using no journal at all is risky. But the older style rollback journal system was about as fast and as trustworthy as WAL journals. I see no

Re: [sqlite] WAL mode is reliable?

On 03 Nov 2011 at 14:02, Simon Slavin wrote: > On 3 Nov 2011, at 1:38pm, Paxdo Presse wrote: > >> How did you get concurrent connections? (about) > > This is related specifically to the web language I use (PHP) so it won't help > you if you're using something else. > >

Re: [sqlite] WAL mode is reliable?

> For concurrency it works fine. The amount of time a connection takes is very > small: just long enough to open, set timeout, do a single query/exec, and > close the connection. So even with lots of users there aren't that many > concurrent connections to the database file. > > Looking

Re: [sqlite] WAL mode is reliable?

On 3 Nov 2011, at 1:38pm, Paxdo Presse wrote: > How did you get concurrent connections? (about) This is related specifically to the web language I use (PHP) so it won't help you if you're using something else. Actually my system works like this: the web pages themselves are '.html' files do

Re: [sqlite] WAL mode is reliable?

Thank you Simon! How did you get concurrent connections? (about) Le 3 nov. 2011 à 14:32, Simon Slavin a écrit : > > On 3 Nov 2011, at 1:22pm, Paxdo Presse wrote: > >> What do you think of SQLite with WAL mode? >> >> Is it reliable? >> >> It is for a web application. >> >> The database

Re: [sqlite] WAL mode is reliable?

On 3 Nov 2011, at 1:22pm, Paxdo Presse wrote: > What do you think of SQLite with WAL mode? > > Is it reliable? > > It is for a web application. > > The database is hosted on a single computer, but there may be multiple > simultaneous connections via Internet (and LAN). > All users access

[sqlite] WAL mode is reliable?

Hi, What do you think of SQLite with WAL mode? Is it reliable? It is for a web application. The database is hosted on a single computer, but there may be multiple simultaneous connections via Internet (and LAN). All users access to database via a web browser. In your opinion, how about