[Fwd: Re: SQLite and transactional security]

Derek Atkins warlord at MIT.EDU
Thu Sep 11 11:55:35 CDT 2003


Does SQLite support multiple applications accessing the same database
(file) at the same time, or does the application need to provide some
sort of lock around the database file?  For example, if there were two
(separate) gnucash processes trying to access the same database, or a
cron job to pull down price data and stuff it into the database -- do
we need to assure only one process has the database open(2)'ed?


Benjamin <benjamincarlyle at optusnet.com.au> writes:

> Sqlite does not support nested transactions. Note also that beginning
> a transaction write-locks the entire database until the transaction is
> committed or rolled back, just as executing a SELECT read-locks the
> entire database.
> It's interesting to see drh showing an interesting in gnucash :) He's
> a good bloke and very efficient at resolving bugs or deficiencies in
> the sqlite code-base.
> Benjamin.
> ----------
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at lists.gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel

       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