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