The Answer Guy 30: Dreaming about xBase tools for Linux

#### "Linux Gazette...making Linux just a little more fun!"

# The Answer Guy

#### By James T. Dennis, answerguy@ssc.com
Starshine Technical Services, http://www.starshine.org/

### Dreaming about xBase tools for Linux

From Michael "Mookie" Kepler on the L.U.S.T List on 04 Jun 1998
Is there a FoxPlus program for Linux ? When I use the SCO FoxPlus on Linux with `iBCS` module running, it can not read the data files.
Thanks,
Jyh-shing Chen
Michael "Mookie" Kepler
Ha! Dream on! I'm decloaking and posting just because I'm glad to meet another living dinosaur. I, too, have too much experience with and an irrational attachment to FoxPlus.

> I presume Fox-Plus is an xBase product related or similar to FoxPro. If so you might look at WorkGroup Solutions "Flagship" (http://www.wgs.com/fsad.html).
> This is a full dBase compatible system, and xBase compiler. (Actually I think it does a "compile to C" --- then you'd use `gcc` to actually produce your binaries. That makes it more portable I suppose).
> You could also look at Christopher B. Browne's incredible annotated link farm of Linux business and productivity applications:

> > `http://www.hex.net/~cbbrowne/`

> ... which has a page specifically one xBase dbms packages for Linux at: `http://www.ntlug.org/~cbbrowne/rdbms05.html`
> Oddly enough Christopher doesn't mention Versasoft's dbMan (dbMan IV or dbMan 5.x). Perhaps the product has been discontinued. I couldn't find any URL for it though there are a number of references. I just guessed at "versasoft.com" and glanced at their web site, which only mentions one product (VersaTOOLS; a FoxPro add-on?). I've blind-copied the one e-mail address listed thereon, so that he can respond with any info on the fate of dbMan, if he feels so inclined.
> So in answer to your question:
> Yes! Dream on! There are dbms apps for Linux, and you DON'T have to use SQL.
> (Also, if you ever want to work with a dbms package that's less like "DOS" and xBase, nothing like SQL and more like Unix shell script programming, look at Revolutionary Software's package: `/rdb` -- they have a Linux version. Apparently this `/rdb` is related to Rand/Hobbs RDB -- Christopher's pages talk about this a little bit.

I made my living pushing the limits of Sco FoxPlus for five years, starting in 1989, making it do things it was never meant to do. It is frustrating that so many people think that SQL and Relational are synonyms, and that Relational and XBase are mutually exclusive. Every database application I created with FoxPlus conformed to the Relational data model. There is nothing in FoxPlus to prevent this.
Please let me know if you find anything FoxPlus-esque that works under Linux. I've been looking myself and have found nothing comparable. If they would just release the source code, we could get somewhere. Whenever I encounter a trivial programming task, especially ones involving tabular data, I always think of how much quicker and easier it would be to turn it out in FoxPlus than 'C', or _shudder_ PlSql (yuck!).

From Thomas Good on the L.U.S.T List on 5 Jun 1998
Jim - I have the opposite problem. I want to lose foxpro in favour of SQL. I run an odd mix of dbs including Postgres, Progress and FoxPro. The foxpro is sitting on a dos box and is need of extinction. It is (obviously) single user and so the person who sits on the box has to do all of the data input and answer the phone - doing queries as requested.
I am moving her data onto a linux box and I want to shift the code from foxpro to SQL. Any converters out there? Front end is not too important as I will use `perl` (5 with DBI 0.91 and DBD-Pg 0.69). I just need to rework the existing queries...thanks!
Tom
----------- Sisters of Charity Medical Center ----------
Department of Psychiatry
Thomas Good, System Administrator
North Richmond CMHC/Residential Services

> Look at Christopher's web pages (I cited it in my longer message but it's at: http://www.hex.net/~cbbrowne/)
> Specifically he lists a some conversion utilities and .DBF libraries at: http://www.ntlug.org/~cbbrowne/rdbms05.html
> Also don't forget to check the LSM (Linux Software Map). Here's a couple of entries from there (not listed on CBB's pages):

>      .......

>      Title:          Light DBF client/server dbms (LDBF)
>      Version:        0.9.9 beta
>      Entered-date:   17NOV95
>      Description:    This is client/server dbms that operate with
>                      DBF files and compatible with Foxpro CDX indexes.
>                      Clients connecting with server via TCP/IP
>                      and works with databases as on local machine.
>                      Supports transactions,multi-user operation,
>                      stored procedures,triggers,
>                      password security,logging all operations,
>                      flexible configuration.Implemented main suite of
>                      xBase operators.
>                      Includes DLL of LDBF API for Windows.
>      Keywords:       LDBF,ldbf
>      Author:         vlad@torn.ktts.kharkov.ua (Vlad Seriakov)
>      Maintained-by:  vlad@torn.ktts.kharkov.ua
>      Primary-site:   sunsite.unc.edu (/pub/Linux/Incoming)
>                      707 Kb ldbf-0.9.9.tar.gz
>                      930 b ldbf.lsm
>      Alternate-site: ftp.kiae.su ( /linux/misc )
>      Original-site:
>      Platforms:      Linux 1.2.0 or later with IPC support
>      Copying-policy: Freeware

>      .......

>     Title:          dbview
>     Version:        1.0.0
>     Entered-date:   20APR96
>     Description:    dbview is a little tool that will display dBase III and
>                     IV files. You can also use it to convert your old .dbf
>                     files for further use with Unix.
>     Keywords:       database dbase view convert
>     Author:         joey@infodrom.north.de (Martin Schulze)
>     Maintained-by:  joey@infodrom.north.de (Martin Schulze)
>     Primary-site:   sunsite.unc.edu /pub/Linux/apps/databases
>                     10kB dbview-1.0.0.tar.gz
>     Original-site:  ftp.infodrom.north.de /pub/Linux/Devel/dbview
>                     10kB dbview-1.0.0.tar.gz
>     Copying-policy: GPL

>      .......
>     Title:          libdbf
>     Version:        1.4
>     Description:    Tools for manipulating dBase files
>     Keywords:       unix dbase
>     Author:         beacker@sgi.com
>     Maintained-by:  Nobody to my knowledge
>     Primary-site:   Wherever you put it.
>     Original-site:  news::comp.sources.misc
>     Platforms:      Unix (This copy linuxified)
>     Copying-policy: No commercial use, no charging for distribution (see README).
>     Entered-date:   01JAN96

> Those were all found just using the "dbf" search string on a local copy of the LSM (just a text file I keep around since I do so much Linux support work).
> There's are several Linux Software Map search engines and searchable Linux Software Database sites out on the web. I don't even have a "favorite" one any more.
> Try:
> Linux Search Database
>   `http://www.egypt.pca.net/LSDB/lynx.html`
> ... which found this one:

>       Title: AppGEN
>        Version: 0.2 alpha
>        Entered Date: 11JUL96
>        Description: Database application generator and 4GL for Postgres95 and
>     		HTTPD. DBase DBF file to SQL Convertor.
>        Key Words:	Application Generator 4GL SQL Web WWW Forms Postgres95 DBF
>        Author:	Andrew Whaley
>        Primary Site: sunsite.unc.edu /pub/Linux/apps/databases/postgres
>     		 appgen-0.2-alpha.tar.gz
>        Alternate Site: GPL'ish End

> ... or try:
> Linux Links (by Goob!) at:
>   `http://www.croftj.net/~goob/`
> (The search engine is not too hot, but the hierarchy of links is great). There is a reference there to a semi-free package called X2c (the portable xBase compiler). X2c seems to have some features for creating binary CGI interfaces to your DBF databases. Which might be an alternative to converting it to SQL, if you aren't worried about some of the concurrency and integrity and business rules enforcement that are associated with SQL --- or even if you just need a quick interim solution to use while you're doing the xBase to SQL port.
> Another place to check into is:
> The #LinuxOS Webpage: Linux Software Search Engines and Indices
>   `http://www.linuxos.org/Lsoftsearch.html`
> As the name suggests that site is maintained by principals of the #LinuxOS IRC channel on EFNet and it contains a list of Linux link farms, search engines and indices (what a surprise!).
> So, I'd say there's plenty of places to look.

From Michael Kepler on the L.U.S.T List on 5 Jun 1998
I'd just like to thank you (Jim Dennis) for your very comprehensive and helpful responses to the XBase question. I had no idea there were so many database options available for Linux. I joined this conversation out of idle personal interest, but now I think I see some possibilities for solutions for current needs we have at our company.
Thanks again,
Michael Kepler
VP Systems Development
Metro One Telecommunications

##### Copyright © 1998, James T. Dennis
Published in Linux Gazette Issue 30 July 1998

| SCOkeys | chroot | dosemu-db | NTauth | cdr | 3270 | comport
lilostop | emulate | ppadrivers | database | vacation | nullmodem | lockups
gzipC | newlook | c500 | solprint | vc1shell | memleak | tvcard