From owner-freebsd-database Thu Jan 29 10:53:11 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA26419 for database-outgoing; Thu, 29 Jan 1998 10:53:11 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from carlton.innotts.co.uk (root@carlton.innotts.co.uk [194.176.128.2]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id KAA26404 for ; Thu, 29 Jan 1998 10:53:05 -0800 (PST) (envelope-from robmel@innotts.co.uk) Received: from muffin.highwire.local (serialA2b.innotts.co.uk [194.176.130.44]) by carlton.innotts.co.uk (8.8.5/8.8.5) with ESMTP id SAA01142; Thu, 29 Jan 1998 18:52:58 GMT Received: from [172.16.17.20] (robsmac.highwire.local [172.16.17.20]) by muffin.highwire.local (8.8.8/8.8.5) with ESMTP id SAA04527; Thu, 29 Jan 1998 18:52:50 GMT X-Sender: robmel@muffin.highwire.local Message-Id: In-Reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Thu, 29 Jan 1998 18:53:38 +0000 To: Tom , Patrick Kelly From: Robin Melville Subject: Re: Which SQL Database for Web Applications ? Cc: SRIDHAR KRISHNAN , freebsd-database@FreeBSD.ORG Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-To-Unsubscribe: mail to majordomo@FreeBSD.org "unsubscribe database" At 6:32 pm -0800 26/1/98, Tom wrote: >On Tue, 27 Jan 1998, Patrick Kelly wrote: > >> I was using (briefly) postgreSQL, but got frustrated with the limited SQL. >> Now I'm using Solid (not free). I've committed to it (ie paid license >> fees), but havn't used it enough to really give a qualified opinion. >> >> patrick > > Solid is nice. Of the free databases, PostgreSQL probably has the least >limited SQL support though. Both mSQL and MySQL lacked all kinds of >things that PostgreSQL does. > > I belive that Solid is the only SQL database for FreeBSD that offers >logging and automatic crash recovery. Only Solid and PostgreSQL provide >support for transactions. > >Tom I've been trying another (non-free) SQL server that runs native on FreeBSD called YARD. It seems a pretty complete & robust implementation (inc logging & transactions). I've not tried linking it to web pages since I'm working on unix & windoze apps, but it definitely has a JDBC interface as well as ODBC and embedded C SQL. They're at http://www.yard.de/ & you can d/l a trial version to see if it's any good for you. I'm a little disturbed about the problems with MySQL that Mark Mayo mentioned: >... I don't like the fact that MySQL 3.21 is the recommended version, >but is still in beta and new betas come out monthly, and the last beta (as >of today 3.21.21) has several known bugs invovling fairly simple queries, >but the only way to get fixes is cut and paste patches from the mailing >list... ugh ... since we've been thinking of using it for less "critical" stuff. Do these problems lose data? Robin.