LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 09-11-2003, 07:59 PM   #1
Ronw
Member
 
Registered: Sep 2003
Location: Auckland New Zealand
Distribution: SuSe 10.2 & SLED 10
Posts: 48

Rep: Reputation: 15
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
 
Old 09-11-2003, 11:51 PM   #2
c0rrupt0
LQ Newbie
 
Registered: Sep 2003
Posts: 10

Rep: Reputation: 0
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/
 
Old 09-14-2003, 12:36 AM   #3
Ronw
Member
 
Registered: Sep 2003
Location: Auckland New Zealand
Distribution: SuSe 10.2 & SLED 10
Posts: 48

Original Poster
Rep: Reputation: 15
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.
 
Old 09-14-2003, 02:05 AM   #4
markus1982
Senior Member
 
Registered: Aug 2002
Location: Stuttgart (Germany)
Distribution: Debian/GNU Linux
Posts: 1,467

Rep: Reputation: 46
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
 
Old 09-14-2003, 03:49 PM   #5
Ronw
Member
 
Registered: Sep 2003
Location: Auckland New Zealand
Distribution: SuSe 10.2 & SLED 10
Posts: 48

Original Poster
Rep: Reputation: 15
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
 
Old 11-11-2003, 09:35 AM   #6
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
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.
 
Old 11-11-2003, 09:46 AM   #7
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
I also have one machine dual booted still running Paradox, I like Paradox very much, shame there is not an equivalent in Linux.
 
Old 11-11-2003, 11:55 AM   #8
buttersoft
Member
 
Registered: Aug 2003
Distribution: Slackware
Posts: 178

Rep: Reputation: 30
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.
 
Old 11-11-2003, 01:30 PM   #9
Ronw
Member
 
Registered: Sep 2003
Location: Auckland New Zealand
Distribution: SuSe 10.2 & SLED 10
Posts: 48

Original Poster
Rep: Reputation: 15
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?
 
Old 11-11-2003, 02:03 PM   #10
-X-
Member
 
Registered: Oct 2003
Location: Tx,USA
Distribution: Slackware, Red Hat, CentOS
Posts: 495

Rep: Reputation: 30
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
 
Old 11-11-2003, 02:40 PM   #11
leipper
LQ Newbie
 
Registered: Sep 2003
Distribution: RH9
Posts: 18

Rep: Reputation: 0
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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
is there a database in linux? stickfun Slackware 8 07-13-2005 05:27 PM
a good book for relational database design? kpachopoulos General 3 11-20-2004 08:14 AM
Question: How to define an SQL HAVING clause in relational algebra? jdruin Linux - Software 1 11-08-2004 07:50 AM
Are there any gui relational databases available for linux? donlinux Linux - Software 3 03-18-2004 08:52 PM
A Database for Linux linuxlover1 Linux - Software 18 01-13-2004 03:41 PM


All times are GMT -5. The time now is 04:53 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration