From owner-freebsd-database Fri Dec 24 9:27:46 1999 Delivered-To: freebsd-database@freebsd.org Received: from mail.rdc1.nj.home.com (ha1.rdc1.nj.home.com [24.3.128.66]) by hub.freebsd.org (Postfix) with ESMTP id 3579914F15 for ; Fri, 24 Dec 1999 09:27:44 -0800 (PST) (envelope-from damascus@eden.rutgers.edu) Received: from damascus ([24.3.219.36]) by mail.rdc1.nj.home.com (InterMail v4.01.01.00 201-229-111) with ESMTP id <19991224172740.ILCM18367.mail.rdc1.nj.home.com@damascus>; Fri, 24 Dec 1999 09:27:40 -0800 Message-Id: <4.2.2.19991224122344.0200db60@email.eden.rutgers.edu> X-Sender: damascus@email.eden.rutgers.edu X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.2 Date: Fri, 24 Dec 1999 12:26:07 -0500 To: Gabor Esperon , freebsd-database@FreeBSD.ORG From: Carroll Kong Subject: Re: What database i can use? In-Reply-To: <19991224165155.27619.qmail@web1302.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk At 08:51 AM 12/24/99 -0800, Gabor Esperon wrote: >I need a good database server in my network, Under >FreeBSD 3.3 > >What is recommended: Oracle, MySQL, PostgreSQL or >another? Oracle for linux under freebsd is really tough to setup. I have not finished setting it up yet and the compatibility mode does not take advantage of the linux threads either. Mysql is fast and nice but I think the lack of transactions and sub selects a bit tacky. Lots of people tell me it is easy to get around it. I think it is inherently a problem for a more reliable database, however, their web site mentions ways to get around recovery without transactions. Postgresql is my personal 'favorite' since they seem more compliant to the SQL standards. It is a touch slower than mysql on some operations though. -Carroll Kong To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message