SQL in the base system (Was: New FreeBSD package system
(a.k.a. Daemon Package System (dps)))
Jos Backus
jos at catnook.com
Fri May 11 17:22:32 UTC 2007
On Fri, May 11, 2007 at 11:23:00AM -0400, Mike Meyer wrote:
[snip]
> How robust is it - can a corrupt block fry the entire database?
Dunno, but "Transactions are atomic, consistent, isolated, and durable (ACID)
even after system crashes and power failures.". So it appears to try hard to
minimize the chance of corruption.
> How about portability - can I move the file to a completely
> different architecture and still get the data from it?
"Database files can be freely shared between machines with different byte
orders."
(Quotes taken from http://www.sqlite.org/)
Also, the code is in the public domain.
--
Jos Backus
jos at catnook.com
More information about the freebsd-hackers
mailing list