My understanding of it is:
BEGIN;
.. a bunch of statements, that should all fail if one doesn't go through ..
COMMIT;
After reading:
http://sqlite.org/lang_transaction.html
It leads me to believe if u pass a formatted SQL query that contains 10 SQL statements it will automatically BEGIN and COMMIT for you. However if you do something like..
PHP Code:
sql("BEGIN");
sql("UPDATE stuff");
sql("UPDATE stuff");
sql("COMMIT");
You
might have to use it, really depends how it's implemented behind-the-scenes.