From owner-freebsd-chat Wed Sep 17 09:57:30 1997 Return-Path: Received: (from root@localhost) by hub.freebsd.org (8.8.7/8.8.7) id JAA24821 for chat-outgoing; Wed, 17 Sep 1997 09:57:30 -0700 (PDT) Received: (from jmb@localhost) by hub.freebsd.org (8.8.7/8.8.7) id JAA24643; Wed, 17 Sep 1997 09:55:48 -0700 (PDT) From: "Jonathan M. Bresler" Message-Id: <199709171655.JAA24643@hub.freebsd.org> Subject: Re: Good Database was: Re: uptime on hub.freebsd.org To: freebsd@atipa.com (Atipa) Date: Wed, 17 Sep 1997 09:55:48 -0700 (PDT) Cc: scrappy@hub.org, wosch@cs.tu-berlin.de, chat@FreeBSD.ORG In-Reply-To: from "Atipa" at Sep 17, 97 08:36:13 am X-Mailer: ELM [version 2.4 PL24] Content-Type: text Sender: owner-freebsd-chat@FreeBSD.ORG X-Loop: FreeBSD.org Precedence: bulk Atipa wrote: > > > > 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... Take a look at www.infoflex.com. they have a replacement for Informix ESQL/C and Informix-SE. even though they do not mention FreeBSD, it is available for FreeBSD. they hope to have an html entry for the gallery ready on monday. jmb > > 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 > >