From owner-freebsd-chat Wed Sep 17 07:32:24 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id HAA16080 for chat-outgoing; Wed, 17 Sep 1997 07:32:24 -0700 (PDT) Received: from onyx.atipa.com (user5243@ns.atipa.com [208.128.22.10]) by hub.freebsd.org (8.8.7/8.8.7) with SMTP id HAA16075 for ; Wed, 17 Sep 1997 07:32:21 -0700 (PDT) Received: (qmail-queue invoked by uid 1018); 17 Sep 1997 14:36:13 -0000 Date: Wed, 17 Sep 1997 08:36:13 -0600 (MDT) From: Atipa X-Sender: freebsd@dot.ishiboo.com To: The Hermit Hacker cc: Wolfram Schneider , chat@FreeBSD.ORG Subject: Good Database was: Re: uptime on hub.freebsd.org In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-chat@FreeBSD.ORG X-Loop: FreeBSD.org Precedence: bulk On Wed, 17 Sep 1997, The Hermit Hacker wrote: > scrappy@zeus.trends.ca> uname -a > FreeBSD zeus.trends.ca 2.2-CURRENT FreeBSD 2.2-CURRENT #0: Wed Jul 17 02:24:10 EDT 1996 scrappy@zeus.trends.ca:/usr/src/sys/compile/zeus i386 > scrappy@zeus.trends.ca> uptime > 10:01AM up 279 days, 19:56, 2 users, load averages: 0.00, 0.00, 0.00 > > No users, as its being used as a PostgreSQL database server for > the accounting system on an ISP... IS there a decent SQL-based database for FreeBSD? (I do NOT want to hear anyone say mSQL... because it is slow as hell and featureless). We just dropped a bunch of cash on Informix's Online Workgroup Server for Sparc becauses I could not find any professional quality database for FreeBSD. What is PostgreSQL? Sounds interesting... Speed is definitely a must, along with some nice features, like variable-length strings, BLOB support, nice CLI interface, professional support, and most importantly reliability. It will be used as a primary database for inventory tracking (about 400-2000 parts / day, each individually trackable w/ serial number), invoicing, warranty, etc., so it MUST work reliably. I would much rather have this system on FreeBSD, not only for the obvious price advantage, but also for ease of administration. I don't want to have to switch gears all the time to find files, don't want to deal w/ NIS, and don't want to support Sun. FreeBSD is MUCH MUCH easier to maintain (thanks to you guys!). Any recommendations? TIA, Kevin