From owner-freebsd-hackers@FreeBSD.ORG Fri May 11 15:23:32 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 9288B16A403 for ; Fri, 11 May 2007 15:23:32 +0000 (UTC) (envelope-from mwm-keyword-freebsdhackers2.e313df@mired.org) Received: from mired.org (vpn.mired.org [66.92.153.74]) by mx1.freebsd.org (Postfix) with SMTP id 368AD13C45B for ; Fri, 11 May 2007 15:23:32 +0000 (UTC) (envelope-from mwm-keyword-freebsdhackers2.e313df@mired.org) Received: (qmail 39613 invoked by uid 1001); 11 May 2007 15:23:00 -0000 Received: by bhuda.mired.org (tmda-sendmail, from uid 1001); Fri, 11 May 2007 11:23:00 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <17988.35412.231093.411177@bhuda.mired.org> Date: Fri, 11 May 2007 11:23:00 -0400 To: Ivan Voras In-Reply-To: References: <200705102105.27271.blackdragon@highveldmail.co.za> <4643C7DB.6000408@elischer.org> X-Mailer: VM 7.19 under Emacs 21.3.1 X-Primary-Address: mwm@mired.org X-face: "5Mnwy%?j>IIV\)A=):rjWL~NB2aH[}Yq8Z=u~vJ`"(,&SiLvbbz2W`; h9L,Yg`+vb1>RG% *h+%X^n0EZd>TM8_IB;a8F?(Fb"lw'IgCoyM.[Lg#r\ X-Delivery-Agent: TMDA/1.1.11 (Ladyburn) From: Mike Meyer Cc: freebsd-hackers@freebsd.org Subject: 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: Fri, 11 May 2007 15:23:32 -0000 > Perhaps this is a good time I should mention that I think sqlite would > also be good for the password and login databases? :) Someone has already pointed out the horror that is the Windows registry. IIUC, even MS has figured out this is a bad idea, and gotten away from it with Vista. But it's been tried on Unix systems before as well. People who've dealt with AIX tend to feel the same way about it's config system as they do about the Windows Registry. Having a magic tool to edit these files is a pain - it means you now have two sets of things to learn: the magic tool, and the specific details of the file you're dealing with. On a Unix system, knowing how to tweak text files is pretty much a given. So all you need is the details for that file. Using a binary format brings it's own problems. How hard is it to fix a corrupt database? How hard is it to figure out that the database is so corrupt you aren't going to get anything out of it, so you might as well give up? How robust is it - can a corrupt block fry the entire database? How about portability - can I move the file to a completely different architecture and still get the data from it? If any of these are noticably worse than they are for text files, changing is probably not a good idea. Someone else mentioned XML. Well, it's easy to parse - assuming you read that as "someone else wrote the parser for us". That's true for lots of things. I also question the sanity of using it. But I wind up doing a lot of it, because my clients like the buzzword compliance. I regularly beat on them to take advantage of what XML can do that other formats can't. Meaning I make them install validation software, and pay me to write schemas for them, and get them to add hooks to the repository so you can't check in xml files that don't validate. But if you're not going to do that kind of thing, the major feature XML brings is the buzzword compliance. http://www.mired.org/consulting.html Independent Network/Unix/Perforce consultant, email for more information.