On Sun, May 31, 2009 at 06:38:45PM +0100, Simon Slavin scratched on the wall: > > On 31 May 2009, at 5:53pm, Jim Wilcoxson wrote: > > > the real point here is that Python and SQLite aren't doing real > > transactions > > But they /are/ real transactions.
They are not ACID transactions. They lack what most people consider to be the proper degree of Durability. > The fact that instead of being written as magnetic domains on a disk > surface your data is floating around several layers of caching may be > a problem if your computer crashes, but only then. "Only then" counts. The whole point of a transaction is that once it returns "success" on a commit, it is committed to permanent storage, no matter what -- including crashes, power failures, and other major problems. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Our opponent is an alien starship packed with atomic bombs. We have a protractor." "I'll go home and see if I can scrounge up a ruler and a piece of string." --from Anathem by Neal Stephenson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users