On 15 Sep 2010, at 1:01am, JT Olds wrote: > On this note, how does one figure out if your system does support > atomic writes (or other FS things, like safe appends)? > > Is there an easy way to have SQLite tell you what it finds out?
Unfortunately, SQLite cannot tell if its underlying operating system can do atomic writes: the operating system lies and the hard disk driver lies to the operating system. You can check to see whether that version of SQLite was compiled with AR support in, but that doesn't tell you whether it has any effect or not. Also it's difficult to test: even if there's no guarantee of atomic writes, writes are usually done in-order most of the time, so you can't test for it just by seeing if it fails a trial run. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
