From: cbbrown@io.org (Christopher B. Browne) Subject: Re: Q: RDBMS ( Oracle, Ingres ) on Linux Date: 1995/12/09 Message-ID: <4aclv7$ms6@ionews.io.org> X-Original-Message-ID: <4aclv7$ms6@ionews.io.org>#1/1 X-Deja-AN: 121362779 references: <4a60ot$17g@ixnews5.ix.netcom.com> organization: Internex Online (io.org) Data: 416-363-4151 Voice: 416-363-8676 followup-to: comp.os.linux.misc,comp.databases,comp.os.linux.development.apps newsgroups: comp.os.linux.misc,comp.databases,comp.os.linux.development.apps In article <4a60ot$17g@ixnews5.ix.netcom.com>, P. Ganesh 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:, WWW: SAP Basis Consultant/Systems Engineer -------- Certified SAP ABAP/4 Consultant PGP key available - check my .plan, Web Page Share and Enjoy