Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 11 May 2007 09:56:12 -0700
From:      Jos Backus <jos@catnook.com>
To:        freebsd-hackers@freebsd.org
Subject:   Re: SQL in the base system (Was: New FreeBSD package system (a.k.a. Daemon Package System (dps)))
Message-ID:  <20070511165612.GA48097@lizzy.catnook.local>
In-Reply-To: <17988.35412.231093.411177@bhuda.mired.org>
References:  <200705102105.27271.blackdragon@highveldmail.co.za> <f20c8u$htp$1@sea.gmane.org> <4643C7DB.6000408@elischer.org> <f219f6$3ls$1@sea.gmane.org> <17988.35412.231093.411177@bhuda.mired.org>

next in thread | previous in thread | raw e-mail | index | archive | help
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



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