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