Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!ames!ucsd!orion.cf.uci.edu!uci-ics!zardoz!dhw68k!felix!tgate!ka3ovk!ki4pv!cdin-1!dsinc!wells!mdi386!bruce From: bruce@mdi386.UUCP (Bruce A. McIntyre) Newsgroups: comp.unix.i386 Subject: Re: Databases under UNIX-386 Summary: Progress, Oracle, Informix, Foxbase under Unix/Xenix Keywords: database Message-ID: <132@mdi386.UUCP> Date: 2 Sep 89 19:32:31 GMT References: <1652@lamont.ldgo.columbia.edu> Organization: Wells Computer Systems Corp., Levittown, Pa. 19058 Lines: 61 In article <1652@lamont.ldgo.columbia.edu>, fritzz@lamont.ldgo.columbia.edu (fritz zaucker) writes: > Is there anybody who has expierence with different databases for > UNIX? I am looking for something to run on a 386 based PC under > ix/386. > Thanks, Fritz I have used the following: name: Progress from Progress Software, rate: Tops in most catagories type: 4GL / Integrated rdbms, next version(6.0) will access Oracle/Sybase O/Ss: Unix, Xenix, PC-Lan, PC-DOS, VMS, CTos, Aux, Aix, others coming name: Oracle from Oracle rate: Tops in breadth of market type: RDBMS with Forms, Reports, C interface, other 3GL interfaces O/Ss: Unix, Xenix, PC-DOS, VMS, Mcintosh, Aix, others name: Informix from Informix rate: Tops in report writer, good screen painter type: RDBMS with Forms, Reports. Add on 4GL, C-interface O/Ss: Unix, Xenix, PC-DOS, VMS, Aix, others name: Foxbase+ from SCO rate: Tops in dBASE compatibles for most environments type: dBASE compatible DBMS, runtimes available O/Ss: PC-DOS, PC-Lans, Xenix, Some UNIX, McIntosh I feel that for most purposes and the widest variety of systems where I have to deliver and maintain working systems in the minimum time and with the maximum performance and effectiveness, I choose Progress. I can literally move code to any of the supported environments unchanged, and it will run correctly. It is fast, solid, and with full transaction processing, automatic roll-back, etc. It is one system where I know that I can yank the plug out of the wall of a running application, and have the database roll itself back to the last valid completed transaction without intervention, even in a Unix environment. I have built systems where I had 100 users under Unix, and am now building an application that will have a working database size of over 2 GigaBytes. There is a good user community, several add on tools, libraries, etc. It has a C interface to call C routines, but the language is so flexible that I have never had to use it. It offers both the ease of a non-procedural language, and yet has the control of a 3GL where you need it. You can mix Progress 4GL language and standard SQL in the same procedures, as SQL is implemented in native mode, not an interface or embedded interpreter. There is a full development test system available for $95 for most of the standard environments, and the only limitation is the number of times you can start the server against the database. However, you could develop the complete application from the TestDrive. These opinions are mine, based on my experience, and while I do act as a reseller of Progress, there is no other connection. bruce -- ========================================================================= Bruce A. McIntyre, McIntyre Designs, Inc. VOICE(215)322-1895 143 Bridgetown Pike, Langhorne, Pa. 19047 DATA (215)357-2915 {wells|lgnp1}!mdi386!bruce bruce@mdi386 tbit+