Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 14 May 2008 09:50:52 -0400
From:      "Kurt J. Lidl" <lidl@pix.net>
To:        Garrett Cooper <yanefbsd@gmail.com>
Cc:        freebsd-hackers@freebsd.org, Jeremy Chadwick <koitsu@freebsd.org>, Anthony Pankov <ap00@mail.ru>, James Mansion <james@mansionfamily.plus.com>
Subject:   Re: BDB corrupt
Message-ID:  <20080514135051.GA21370@pix.net>
In-Reply-To: <D10ACB9D-8D1D-4696-BF7E-DBB0E9D74262@gmail.com>
References:  <9FC19AC2-DAD8-418C-8B9C-F129DEC58CEF@gmail.com> <15336578.20080512123806@mail.ru> <200805121153.00809.jonathan%2Bfreebsd-hackers@hst.org.za> <1663320218.20080512223531@mail.ru> <20080512152430.3720683e@mbook.local> <2117635718.20080513154406@mail.ru> <20080513121452.GA70860@eos.sc1.parodius.com> <20080513154137.GA28842@pix.net> <482A02CD.7040308@mansionfamily.plus.com> <D10ACB9D-8D1D-4696-BF7E-DBB0E9D74262@gmail.com>

next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, May 14, 2008 at 12:25:16AM -0700, Garrett Cooper wrote:
> Most of the complaints about other DBs is licensing related, but SQLite's 
> complaint was also the fact that the past stability record was a bit rocky.

One other thing to watch for in SQLite is the lack of atomicity
in updates.  It's not ACID, just like BDB 1.8x isn't ACID.

Without a write-ahead log, you cannot be sure that the data written
actually made it to stable storage, and as such, you cannot be sure
that your database didn't get corrupted when the process stops in a
non-optimal way.

I view SQLite as adding syntactic sugar to your data access language.

It doesn't give you real tranactions, it doesn't give you a write-ahead
log, it doesn't give you referential integrity.  Heck, the last time
I looked (admitted, a while ago), it didn't even enforce column type
checking on tables.  (Put this string in the INT column? No problem!)

-Kurt



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080514135051.GA21370>