Linux DBMS

[Paul G. Allen]

Rick Moen wrote:
> 
> Quoting Subba Rao (subb3 at attglobal.net):
> 
> > I am currently looking at using a DBMS server on a Linux system.
> > Are Linux systems used as DBMS servers? If yes, what HW configuration
> > would be recommended for a DBMS server for a e-Business application?
> >
> > Which DBMS systems perform well on Linux and are not resource hogs?
> 
> Informix and DB/2 seem to do particularly well.  For more-modest
> systems, Solid Server or even MySQL might suffice.  A lot of the places
> I've been, pointy-haired boss types have insisted on running Oracle for
> Linux, which is a pain in the derriere and a resource hog, so I've not
> had a chance to deploy Informix and DB/2 as much as I'd like.
> 
> As far as an adequate hardware platform, read and carefully heed the
> hardware recommendations for whatever you want to try.
> 
> Linux is a very decent DBMS platform in theory, but I keep seeing such
> systems sabotaged by dumb administrative decisions -- like making all
> data access go through ODBC, or using JServ.  (Ugh!)  Then, of course,
> the peabrained managers cite "problems" with the Linux solution six
> months later, and convert everything to NT/IIS/SQL Server.
> 

Personally I would go with a DB2 solution. It's fast, full featured, has
great support, and is free for development and personal use on Linux. There
is also a Perl DBI module for DB2 so that you can set up your web site
using Perl scripts to access the database easily.

As a matter of fact, I will be doing this with a web interface I am
currently developing. I have had DB2 running on this system since the beta
release was announced from IBM. I hardly notice the resources it's using
and the download as compared to Oracle 8i was MUCH more reasonable. Not to
mention that I can't even run Oracle without buying more memory!

PGA