SQLite and transactional security

D. Richard Hipp drh at hwaci.com
Wed Sep 10 22:40:05 CDT 2003

Matthew Vanecek wrote:
 > A question....: does SQLite support transactional updates (e.g., multiple
 > updates rolled into one BEGIN/COMMIT block)?

Yes.  All changes between a BEGIN and COMMIT are atomic - either
they all occur or none of them occur.  This is true even if the
update is interrupted by a program crash, an OS crash, or a
power failure.

If you do a BEGIN then a bunch of updates/deletes/inserts then
change you mind, you can always do a ROLLBACK instead of a
COMMIT to restore the database to its state right before the

D. Richard Hipp -- drh at hwaci.com -- 704.948.4565

More information about the gnucash-devel mailing list