From owner-freebsd-questions@FreeBSD.ORG  Thu Aug 19 08:01:27 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id CB4D916A4CE
	for <freebsd-questions@freebsd.org>;
	Thu, 19 Aug 2004 08:01:27 +0000 (GMT)
Received: from asmtp-a063f31.pas.sa.earthlink.net
	(asmtp-a063f31.pas.sa.earthlink.net [207.217.120.133])
	by mx1.FreeBSD.org (Postfix) with ESMTP id AE26943D5A
	for <freebsd-questions@freebsd.org>;
	Thu, 19 Aug 2004 08:01:27 +0000 (GMT)
	(envelope-from algould@datawok.com)
Received: from 22-243.lctv-b4.cablelynx.com ([24.204.22.243]
	helo=[192.168.63.10])
	by asmtp-a063f31.pas.sa.earthlink.net with asmtp (TLSv1:RC4-MD5:128)
	(Exim 4.34)	id 1BxhrR-0001Mh-Ci; Thu, 19 Aug 2004 01:01:25 -0700
From: "Andrew L. Gould" <algould@datawok.com>
To: freebsd-questions@freebsd.org, pryan@singnet.com.sg
Date: Thu, 19 Aug 2004 03:01:24 -0500
User-Agent: KMail/1.6.2
References: <1092894620.41243f9c557e8@arrowana.singnet.com.sg>
In-Reply-To: <1092894620.41243f9c557e8@arrowana.singnet.com.sg>
MIME-Version: 1.0
Content-Disposition: inline
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <200408190301.24206.algould@datawok.com>
X-ELNK-Trace: ee791d459e3d6817d780f4a490ca69564776905774d2ac4b04679d562b0c630f18209191697f7aa5350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c
X-Originating-IP: 24.204.22.243
Subject: Re: most commonly used database
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 19 Aug 2004 08:01:27 -0000

On Thursday 19 August 2004 12:50 am, Peter Ryan wrote:
> Has anyone got any idea what is the most
> commonly used database on freeBSD ?
>
> Is it mySql ?
>
> I was going to install it but the
> CPU utilitisation problems reported
> recently are a bit worrying.
>
> Thanks
> Peter

Hi Peter,

Caveat:  I am more familiar with postgresql.  It is currently my 
database of choice.  My opinions may show a certain bias.

Mysql is probably the most popular; but there are significant 
differences between database servers that are used on FreeBSD that 
should be considered.

The common, free, relational database servers include firebird, 
postgresql, mysql and sqlite.

Firebird is compatible with Borland's Interbase.

Mysql has the most documentation available in bookstores.  I don't think 
mysql is ACID compliant for all of its data table formats.  User 
administration is easier in mysql -- you can use wildcards when 
assigning database privileges to a user.

Postgresql is ACID compliant; and has features missing in mysql (boolean 
data type, stored procedures, nested queries, table inheritance, etc.). 
Postgresql is released under the BSD license.

I've heard that sqlite is really good as an embedded database.

If you need a crossplatform database:  firebird, mysql and sqlite have 
native versions available for Windows.  A Windows version of postgresql 
is in development.

There is much more information at each database's website.  Googling 
will take you far.

Please note that the version number for postgresql 7.5 has been changed 
to 8.0.0, which is currently in beta.

Best of luck,

Andrew Gould