On Dec 17, 2005, at 7:10 PM, Gerhard Häring wrote:
SQLite certainly does support transactions. There might be limitations on how much concurrency you can get with SQLite, but it does properly support transactions.
You are absolutely correct. Very poor choice of words on my part. SQLite does support transactions (and actually does them implicitly on writes, IIRC) in the sense that you can wrap writes in a transaction and roll back if needed.
That "really" in my statement carries a lot of additional meaning about the obvious concurrency properties of a database that essentially locks the entire data store (thereby negating at least one of the major purposes of transactions) whenever you start a transaction :)
I suppose the more shocking thing is that SQLite has better support for transactions than MySQL does in its default storage format!
-- Jonathan LaCour http://cleverdevil.org
