From owner-freebsd-database Sun Dec 26 5:36: 3 1999 Delivered-To: freebsd-database@freebsd.org Received: from whizzo.transsys.com (whizzo.TransSys.COM [144.202.42.10]) by hub.freebsd.org (Postfix) with ESMTP id 9A7861508C for ; Sun, 26 Dec 1999 05:36:00 -0800 (PST) (envelope-from louie@whizzo.transsys.com) Received: from whizzo.transsys.com (localhost.transsys.com [127.0.0.1]) by whizzo.transsys.com (8.9.3/8.9.1) with ESMTP id IAA66179; Sun, 26 Dec 1999 08:36:25 -0500 (EST) (envelope-from louie@whizzo.transsys.com) Message-Id: <199912261336.IAA66179@whizzo.transsys.com> X-Mailer: exmh version 2.1.1 10/15/1999 To: Robin Melville Cc: Gabor Esperon , freebsd-database@FreeBSD.ORG From: "Louis A. Mamakos" Subject: Re: What database i can use? References: In-reply-to: Your message of "Sun, 26 Dec 1999 12:42:54 GMT." Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Sun, 26 Dec 1999 08:36:25 -0500 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > At 9:05 am -0800 24/12/99, Gabor Esperon wrote: > >I need a good database server in my network, under > >FreeBSD 3.3 > > > >What is recommended: Oracle, MySQL, PostgreSQL or > >another? > > Previous responses by others are reasonable, although MySQL is better > than Berend de Boer said for quick and effective apps using many > accesses - few (and not too complex) updates. If you don't need transactions and rollback capability (and triggers), then I would recommend that you seriously consider it. I'm using MySQL for a couple of applications on my FreeBSD home automation system. It collects caller-id (for inbound) and call detail records (for outbound) calls from my PBX into a table, as well as periodic temperature measurements every 4 minutes from 11 temperature probes in various locations. For my application, the transactions are generally pretty simple with lots of inserts (there are 719,000 records in the temperature measurement table, 5255 in the inbound call table and 4812 in the outbound call table). The database server simply seems to work. I can't remember the last time I manually restarted it; currently, it's been up for for a bit more than 48 days which corresponds to the last time that system booted. There are also client-side interfaces available in perl, tcl, php3 as well as a C API. louie To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message