From owner-freebsd-hackers@FreeBSD.ORG Mon May 14 05:16:43 2007 Return-Path: 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 4356816A402 for ; Mon, 14 May 2007 05:16:43 +0000 (UTC) (envelope-from youshi10@u.washington.edu) Received: from mxout3.cac.washington.edu (mxout3.cac.washington.edu [140.142.32.166]) by mx1.freebsd.org (Postfix) with ESMTP id 1E6FC13C483 for ; Mon, 14 May 2007 05:16:43 +0000 (UTC) (envelope-from youshi10@u.washington.edu) Received: from smtp.washington.edu (smtp.washington.edu [140.142.33.7] (may be forged)) by mxout3.cac.washington.edu (8.13.7+UW06.06/8.13.7+UW07.03) with ESMTP id l4E5Gg8F024704 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Sun, 13 May 2007 22:16:42 -0700 X-Auth-Received: from [192.168.10.45] (c-67-174-148-212.hsd1.ca.comcast.net [67.174.148.212]) (authenticated authid=youshi10) by smtp.washington.edu (8.13.7+UW06.06/8.13.7+UW07.03) with ESMTP id l4E5GgNH001667 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Sun, 13 May 2007 22:16:42 -0700 Message-ID: <4647F0B9.2000509@u.washington.edu> Date: Sun, 13 May 2007 22:16:41 -0700 From: Garrett Cooper User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: freebsd-hackers@freebsd.org References: <200705102105.27271.blackdragon@highveldmail.co.za> <4643C7DB.6000408@elischer.org> <17988.35412.231093.411177@bhuda.mired.org> <20070511165612.GA48097@lizzy.catnook.local> In-Reply-To: <20070511165612.GA48097@lizzy.catnook.local> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-PMX-Version: 5.3.1.294258, Antispam-Engine: 2.5.1.298604, Antispam-Data: 2007.5.13.215934 X-Uwash-Spam: Gauge=IIIIIII, Probability=7%, Report='__CP_URI_IN_BODY 0, __CT 0, __CTE 0, __CT_TEXT_PLAIN 0, __HAS_MSGID 0, __MIME_TEXT_ONLY 0, __MIME_VERSION 0, __SANE_MSGID 0, __USER_AGENT 0' 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 List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 May 2007 05:16:43 -0000 Jos Backus wrote: > 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. Be wary of the possible fine print: "Portions of the documentation and some code used as part of the build process might fall under other licenses." From: . -Garrett