Relational Database on Linux
 

As a new users to Linux and running mandrake 9.1 I ahve need of a database similar to Paradox as used in Windows. I want a stand alone Database that does not need a server component. I just want a good relational database. I like working with QBE instead of having to make a SQL querry.
Any sugegstions what to use

not familure with paradox but I do know there is a SQL type db that is standalone and nto a server. It can also be used with php. http://www.hwaci.com/sw/sqlite/

No, what I want is a complete relational database program similar to Access, Dbase or Paradox. All these products have the database engine and the front end client program in one program. I do not want to have to run a server engine and then a front end cleint to do simple database work. Surely somone in Linux world has a standalone database program.

First of all, never call MS Access or DBase real databases ... having to work with them at work I'd never even mention them in the same sentence. Install MySQL and go for phpMyAdmin

That is a currious answer of course dBase is a real relational database and as one of the first xbase systems available is the heart of many stand alone programs. I do not see the point in running up a full install of MYSQL and having to deal with all the client server problems when all I want to do is write some reasonably simple database applications.
I might have to go down the Wine road but that also seems overkill

I also use Paradox, and don't want to go the Wine route.

I am currently using Mysql in conjunction with mySQL Manager from http://www.ems-hitech.com/index.phtml.

Of course this is a paid for tool, but it is totally what I needed to transfer from Paradox to mySQL......

Hope this helps you too.

I also have one machine dual booted still running Paradox, I like Paradox very much, shame there is not an equivalent in Linux.

Ronw

You can also investigate knoda V0.5.6 that is a very handy piece of software, allowing easy connection to mySQL databases, updates, queries and so forth.

Thanks for replies. I have looked at MYSQL manager but was put off by the cost. Also I cannot see how one does reporting with MYSQL. Does one have to extract their data and then use a 3rd party product to format and print?

Don't know what you want to do, but Open Office connects to mysql and postgresql. Here's some info;
http://dba.openoffice.org/FAQ/specif...ets=9visivoza2

Someone wrote a document with step-by-step, forms and such, but can't find it now.

Little more info:
http://www.yo-linux.com/TUTORIALS/LinuxDatabases.html

I finally got around to running Paradox 3.5 in a Dos EMU window with the net share on the proper drive letter. Now I need to figure out how to get some of the debug keystrokes to function. (been using OS/2 dosbox for years and that one is going to be hard to match)

If you need something to read Paradox files, try
paradox file reader in java

http://leipper.org/tcl/software/paradoxfile.java
is the source.
Should be easy to modify to dump data to an SQL server, maybe, if you know about accessing database services with Java.

One of these days I am going to have to upgrade that software to something a bit less 'legacy' - but Paradox for DOS was. and still is, such a nice solution for that particular problem.

It will probably be a LAMP solution, next, I guess.