Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 15 Dec 1995 02:44:54 -0500 (EST)
From:      Marc Ramirez <mrami@mramirez.sy.yale.edu>
To:        questions@freebsd.org
Subject:   database advice
Message-ID:  <Pine.BSF.3.91.951215024127.21388D-100000@mramirez.sy.yale.edu>

next in thread | raw e-mail | index | archive | help
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 <mrami@mramirez.sy.yale.edu>
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.








Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.91.951215024127.21388D-100000>