Date: Thu, 15 May 2008 05:20:26 +1000 From: Peter Jeremy <peterjeremy@optushome.com.au> To: Garrett Cooper <yanefbsd@gmail.com>, freebsd-hackers@freebsd.org Subject: Re: BDB corrupt Message-ID: <20080514192026.GY64804@server.vk2pj.dyndns.org> In-Reply-To: <20080514135051.GA21370@pix.net> References: <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> <20080514135051.GA21370@pix.net>
next in thread | previous in thread | raw e-mail | index | archive | help
--76DTJ5CE0DCVQemd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On 2008-May-14 09:50:52 -0400, "Kurt J. Lidl" <lidl@pix.net> wrote: >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. This isn't true. SQLite does provide full ACID. One difference from (eg) Oracle is that you need to explicitly begin a transaction, rather than a transaction implicitly commencing with the first DML statement. (I don't know what the SQL standard requires). >Without a write-ahead log, It does have a log to record incomplete transactions. > it doesn't give you referential integrity. To quote http://www.sqlite.org/omitted.html: "FOREIGN KEY constraints are parsed but are not enforced. However, the equivalent constraint enforcement can be achieved using triggers." >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!) As noted, this is seen as a feature, not a bug. No-one is claiming SQLite is perfect. It does, however, provide a very usable SQL engine, that provides most of SQL92, with a very small footprint and a friendly license. If FreeBSD does need something with capabilities than BDB1.x, SQLite is an obvious contender. --=20 Peter Jeremy Please excuse any delays as the result of my ISP's inability to implement an MTA that is either RFC2821-compliant or matches their claimed behaviour. --76DTJ5CE0DCVQemd Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (FreeBSD) iEYEARECAAYFAkgrO3oACgkQ/opHv/APuIcGlACeMy6GjB9JXeti7gmkqFaHNc2W eLUAoKrE5thxmFJnGuejOHRipmk6QPxW =Ycw4 -----END PGP SIGNATURE----- --76DTJ5CE0DCVQemd--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20080514192026.GY64804>