From owner-freebsd-database Mon Nov 2 06:46:09 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA22126 for freebsd-database-outgoing; Mon, 2 Nov 1998 06:46:09 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from sys4.cambridge.uk.psi.net (sys4.cambridge.uk.psi.net [154.32.106.14]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id GAA22041 for ; Mon, 2 Nov 1998 06:45:57 -0800 (PST) (envelope-from robmel@nadt.org.uk) Received: (from uucp@localhost) by sys4.cambridge.uk.psi.net (8.9.1/8.9.1) with UUCP id NAA22677; Mon, 2 Nov 1998 13:22:19 GMT Received: from robin.nadt.org.uk (robin.nadt.org.uk [172.16.99.199]) by charlie.nadt.org.uk (8.8.8/8.6.12) with SMTP id LAA24259; Mon, 2 Nov 1998 11:22:12 GMT Message-Id: <3.0.5.32.19981102112211.007b64d0@wrcmail> X-Sender: robmel@wrcmail X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Mon, 02 Nov 1998 11:22:11 +0000 To: James Butt , Tom From: Robin Melville Subject: RE: Database for FreeBSD 2.2.X: DB2 or Interbase possible? Cc: Berend de Boer , "'freebsd-database@freebsd.org'" In-Reply-To: References: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk At 12:42 31/10/98 -0600, James Butt wrote: >> > > Solid from www.solidtech.com A version for two users will be really >> > > cheap. Low maintenance. Supports online backup (mysql for example, >> > > blocks all updates during a backup), and is fully relational (mysql is >> > not >> > > relational because it does not support transactions). The ODBC client >> > for >> > > Windows 95 is really nice. Mysql ODBC for Windows can be iffy. >> > >> > I'll take a look at it, although I doubt I will use it. Most RDBMS take >> > quite some time to know them well. As I don't know this product I don't >> > know which queries work, how well the optimizer is, etc. >> >> You'd be surprised about Solid. Very quick to get going. SQL is very >> conforming. >> > >Yes.. Solid == Good!! Yes, it's horses for courses really for native FreeBSD SQL servers. MySQL is fast & reliable but cut-down (and free). Solid is full featured and angled towards ODBC access (the C API is effectively ODBC also). Another (reasonably cheap) commercial alternative is Yard SQL. Also full-featured it has a very nice C API, an embedded SQL interface and an OK ODBC. They're at www.yard.de. I'd like to see gdb/Interbase ported to FreeBSD too as it's a very nice engine. Robin. -------------------------------------------------------- Robin Melville, Addiction & Forensic Information Service Nottingham Alcohol & Drug Team (Extn. 49178) Vox: +44 (0)115 952 9478 Fax: +44 (0)115 952 9421 Email: robmel@nadt.org.uk WWW: http://www.innotts.co.uk/nadt/ --------------------------------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message