SQLite and transactional security
Derek Atkins
warlord at MIT.EDU
Wed Sep 10 12:07:50 CDT 2003
Hi,
I've forwarded this message to gnucash-devel. Future messages
of this ilk should be directed there.
-derek
drh at hwaci.com writes:
> I reviewing some discussion on the GnuCash mailing list
> I noticed a misconception about SQLite that I wanted to
> correct.
>
> With SQLite, if your program crashes in the middle of an
> update or if you turn off power in the middle of an update
> or some other disaster happens in the middle of an update,
> the database will be automatically rolled back to a
> consistent state the next time it is opened. I'm not sure
> if this is what you mean by "transactional security" or
> not.
>
> To put it another way, updates to an SQLite database are
> atomic. Either the entire update occurs or none of it
> occurs. You never run into a situation where a program
> crash causes an update to occur half-way.
>
--
Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
Member, MIT Student Information Processing Board (SIPB)
URL: http://web.mit.edu/warlord/ PP-ASEL-IA N1NWH
warlord at MIT.EDU PGP key available
More information about the gnucash-devel
mailing list