On 20 Sep 2011, at 3:52pm, Berthier, Emmanuel wrote: > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin >> Sorry to say that this subject is one where the longer you spend looking at >> it the more annoying it gets. > > You are not annoying me at all! ;-) > >> You either have storage devices which support ACID and transactions, or you >> don't. > > Could you give more info about these capabilities?
Only that they don't exist in the hardware you routinely buy. Try reading <http://en.wikipedia.org/wiki/ACID> and pretend you were designing a hard disk drive to support it, instead of writing database software to support it. Basically, many of the wonderful tricks modern DBMSes (including SQLite) do to support data integrity are made more complicated, or defeated entirely, because the underlying hardware lies to the operating system in an attempt to appear faster. When you expensively buy server-type hardware at server prices, for example external RAID array cases with disks with Server-type firmware, you get stuff designed for data integrity. When you buy cheap hard disks intended for cheap desktops, or Flash chips intended for mobile phones, you get stuff designed for speed and cheapness. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users