pg.ddx.io  University INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database  
help / color / mirror / Atom feed
From: cbbrown@io.org
Subject: Re: Q: RDBMS ( Oracle, Ingres ) on Linux
Date: 1995/12/09
Message-ID: <4aclv7$ms6@ionews.io.org> (raw)
References: <4a60ot$17g@ixnews5.ix.netcom.com>

In article <4a60ot$17g@ixnews5.ix.netcom.com>,
P. Ganesh  <pganesh@ix.netcom.com> wrote:
>
>Hi,
>
>Are there any public domain or commercial RDBMS systems available on
>Linux. Would appreciate details.

There's several ways of looking at this:
a) Commercial vs "public domain" (using the term "public domain" in a loose 
way);
b) SQL-like vs. X-Base-like
(Pretty much all of the X-Base-like systems are commercial, I'll note.)

In the "PD" SQL Realm:
 - Ingres
   - This is where today's SQL databases came from.
   - The University Ingres package is somewhat fiddly to configure, uses
     QUEL rather than SQL, and may be considered somewhat "obsolete."
 - Postgres95
   - Postgres was an experimental RDBMS system that has seen work this
     year that has added SQL capabilities to it.
     Quite powerful; somewhat fiddly to configure; a good choice if
     you're into "advanced databases."  Pretty full-featured.
 - MSQL (Minerva SQL)
   - This is a fairly popular "mini" SQL system.  It doesn't implement
     all of SQL, or even substantially most.  It implements some of the
     easier pieces of SQL.
     If MSQL provides enough for your purposes, it may well be a good
     choice.

The commercial SQL realm includes:
- JustLogic SQL; oriented towards server development.  It doesn't
  appear that there's much in the way of front end (user interface)
  tools.
- Empress SQL; this includes a *lot* of stuff; comparable in overall
  functionality to Oracle with Forms 2 or 3; comes with UI tools and 
  the whole bit.
- Infoflex; this is explicitly an Informix clone.  Pretty expensive;
  I know little beyond the name.
- Faircom SQL Server runs under Linux, according to a recent mailing.
- Oracle 7 for SCO is apparently installable and can run; it is 
  certainly not supported by Oracle in a Linux configuration.

Another tool, available in both PD and commercial versions, is "/RDB."
(Revolutionary Software is the commercial supplier.)  It uses UNIX
shell scripts, and don't hold it against RDB.  It uses pipes a *lot*
and is very UNIX-like in style.  /RDB is distinct from RDB, which is
an Oracle product that used to be produced and sold by DEC.

In the X-Base world, there are three products I can think of:
(Note that I am professionally happy to be *avoiding* XBase work these 
days, and so may have a bad attitude towards these products.)

a) LDBF; presently "freeware;" this is a FoxBase clone that adds a
lot of server-level functionality traditionally associated with SQL
systems (such as triggers, stored procedures, stuff like that...).
Apparently the multi-user version will soon be available as a
commercial product.

b) Flagship.  This is a Clipper clone.  Demo edition available on
many Linux CD-ROMS.  Looks pretty good, for XBase.  

c) dBMan.  A dBase IV clone.  I haven't seen it in action; no idea
as to quality/performance.

Note: I have installed and gotten to function the following of these:
- Demo Flagship, PD RDB, Msql, Empress, Postgres, and Ingres.

I have had pieces of LDBF downloaded at different times; didn't figure 
it worth installing *for me.*  (Technically it looks like perhaps the
neatest of the XBase systems, at least in looking at the server side.)

I had chunks of Postgres95 installed at one point; I'm not sure if
I actually got it working this summer.  I picked up Empress this
fall, and that ought to be enough database for me for now.

Much of this stuff is documented in my Web Page on RDBMSes:
   http://www.io.org/~cbbrown/rdbms.html

-- 
Christopher Browne - Email:<cbbrown@io.org>, WWW:<http://www.io.org/~cbbrown/;
SAP Basis Consultant/Systems Engineer -------- Certified SAP ABAP/4 Consultant
PGP key available - check my .plan, Web Page                   Share and Enjoy






Message-ID: <4aclv7$ms6@ionews.io.org>
Permalink:  ../4aclv7$ms6@ionews.io.org/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox