From owner-freebsd-hackers@FreeBSD.ORG  Fri May 11 17:22:32 2007
Return-Path: <owner-freebsd-hackers@FreeBSD.ORG>
X-Original-To: freebsd-hackers@freebsd.org
Delivered-To: freebsd-hackers@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id BA82716A402
	for <freebsd-hackers@freebsd.org>; Fri, 11 May 2007 17:22:32 +0000 (UTC)
	(envelope-from jos@catnook.com)
Received: from lizzy.dyndns.org (209-204-188-132.dsl.static.sonic.net
	[209.204.188.132])
	by mx1.freebsd.org (Postfix) with SMTP id 5D77513C44B
	for <freebsd-hackers@freebsd.org>; Fri, 11 May 2007 17:22:32 +0000 (UTC)
	(envelope-from jos@catnook.com)
Received: (qmail 48635 invoked by uid 1000); 11 May 2007 16:56:12 -0000
Date: Fri, 11 May 2007 09:56:12 -0700
From: Jos Backus <jos@catnook.com>
To: freebsd-hackers@freebsd.org
Message-ID: <20070511165612.GA48097@lizzy.catnook.local>
Mail-Followup-To: freebsd-hackers@freebsd.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>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <17988.35412.231093.411177@bhuda.mired.org>
User-Agent: Mutt/1.5.15 (2007-04-06)
Subject: Re: SQL in the base system (Was: New FreeBSD package system
	(a.k.a. Daemon Package System (dps)))
X-BeenThere: freebsd-hackers@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: jos@catnook.com
List-Id: Technical Discussions relating to FreeBSD
	<freebsd-hackers.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>, 
	<mailto:freebsd-hackers-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-hackers>
List-Post: <mailto:freebsd-hackers@freebsd.org>
List-Help: <mailto:freebsd-hackers-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-hackers>,
	<mailto:freebsd-hackers-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 11 May 2007 17:22:32 -0000

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