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