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
BEGIN.


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



More information about the gnucash-devel mailing list