2011/11/11 Lluís Batlle i Rossell <[email protected]>

> Hello,
>
> how much you trust sqlite wal? I've seen reports of it corrupting some
> databases one year ago or so, *without* any computer crash involved.
>

SQLite+WAL is used in Firefox, Android, iPhone, and billions of other
deployments.  It is very, very stable.  The
http://www.fossil-scm.org/website runs off of SQLite in WAL mode.  See
http://www.sqlite.org/testing.html for an overview of the testing
procedures we subject SQLite to prior to each release.

There are lots of ways to corrupt a database file - see
http://www.sqlite.org/howtocorrupt.html for a summary.  You'll notice that
all of them are obscure and extreme, but they don't all involve system
crashes.


-- 
D. Richard Hipp
[email protected]
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

Reply via email to