From owner-freebsd-questions Thu Dec 14 23:45:00 1995 Return-Path: owner-questions Received: (from root@localhost) by freefall.freebsd.org (8.7.3/8.7.3) id XAA01747 for questions-outgoing; Thu, 14 Dec 1995 23:45:00 -0800 (PST) Received: from mramirez.sy.yale.edu (mramirez.sy.yale.edu [130.132.57.207]) by freefall.freebsd.org (8.7.3/8.7.3) with SMTP id XAA01737 for ; Thu, 14 Dec 1995 23:44:54 -0800 (PST) Received: (from mrami@localhost) by mramirez.sy.yale.edu (8.6.12/8.6.9) id CAA23011; Fri, 15 Dec 1995 02:44:55 -0500 Date: Fri, 15 Dec 1995 02:44:54 -0500 (EST) From: Marc Ramirez Reply-To: mrami@minerva.cis.yale.edu To: questions@freebsd.org Subject: database advice Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-questions@freebsd.org Precedence: bulk I fear I sent this to the wrong list. Apologies to those who have seen it twice. One additional question: has anyone tried or gotten to run the SCO version of any Windows emulation packages (WABI, maybe)? Marc. ---------- Forwarded message ---------- Date: Wed, 13 Dec 1995 01:19:52 -0500 (EST) From: Marc Ramirez To: chat@freebsd.org Subject: database advice I got propositioned today. I work for what is basically a sinking ship, and the president has finally realised that. He says, Well, we've seen the work you do and it's really good, you're a great designer, [gratuitous ego-inflating salesmanship deleted], and we're too weighted down with our current language, and we're stuck on VMS platforms, so we'd like you to translate our system to C and make it run on VMS, OSF, and SCO by August. "Can I develop it with FreeBSD?" "Sure. And if it works, we'll even try to sell it." So, "our system" is an accounting/inventory tracking/order processing system for food distributors. This means that I am looking for a good database or ISAM package (shudder) for FreeBSD. :) Most of our customers are fairly small, but there are a few that can move, oh, $1.3 mil worth of food per day. Pretty I/O intensive, mind you, but it can be squeezed onto one disk (yes, we underspec our systems :), so it's nothing that isn't intrinsically infeasible. I'd be happy to take Mr. Grimes' striping patches and beat them to death for a scenario like this. I looked a bit at the doc for Exodus, and it seems to be close to what I would want, but I have no idea what the throughput is like (I know, I know, install it and see). I'm more concerned with pushing records than having a nifty interface to the database. Any advice? I have heard (I think) of other people doing DBMS stuff on FreeBSD. Any nuggets of wisdom? What are you using? Should I just roll my own Record Shoving Library? Also, if this gets off the ground, I'd really like to add versions, and variable symlinks or whatever you call them (logicals, dammit!). Yes, it can be argued that they're icky, but they have saved my big behind more than a couple of times and I'm not sure I'd really sleep well at night running a production system without them. Would this be more than a couple of hundred hours worth of hacking to namei() and friends, O gurus? Marc.