LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 10-26-2001, 09:25 AM   #1
j-charles
Member
 
Registered: Sep 2001
Location: dunkerque, france
Distribution: mandrake 9.0 -> debian woody
Posts: 39

Rep: Reputation: 15
Which database application ?


Hi,
I'd like to know which database application to use. I'm coming from Windows, and I'm looking for a free equivalent of MS Access, or MS Works running under linux. I couldn't find any package about this on my Mandrake Distribution.
 
Old 10-26-2001, 09:39 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976Reputation: 1976
thing abuot Access, is that, well.. it's a toy. I think it actually is the least industry standard database used in business, and has very poor support for cool things.

on your cd's in MySQL, that's Structured Query Language, which i the foundation of database standards. MySQL isn't terrifically standard either, but a damn sight closer than access. As it's intended for real use, it's server-client based, as a database should be, rather than a highly restrictive flat application like access. So install all erm.. 3(?) MySQL rpms and go from there. I think there aer some front ends for it, but i only ever used the standard command line for it.
 
Old 10-26-2001, 02:46 PM   #3
isajera
Senior Member
 
Registered: Jun 2001
Posts: 1,635

Rep: Reputation: 45
there's not really a linux equivalent of Access. it's too gui for most linux apps. freshmeat had a few articles on linux databases recently. here's the links

http://freshmeat.net/articles/view/307/

http://freshmeat.net/articles/view/305/
 
Old 10-26-2001, 06:47 PM   #4
Ge0ph
LQ Newbie
 
Registered: Oct 2001
Posts: 24

Rep: Reputation: 15
Access is very good for a lot of things. The pure SQL databases that linux has is over kill for a lot of things (like cutting butter with a chain saw or using a freight train to deliver home mail). Again, "Use the right tool for the job". Unfortunately Linux does not have any small database programs that are suited for the smaller jobs. The closest I have found is Paradox in the WordperfectOffice Suite, and it's still a little heavy for some things.

You would be best to learn SQL and write a back end and then find a good front end and then write a front end for your back end. You can split your Access database and then move the back end into SQL. Then find a front end for the SQL. This is What I had to do but I still haven't found a decent front end. What this amounts to is; you will be able to save all of your tables and data but the rest will be a complete re-write.
 
Old 10-29-2001, 10:04 AM   #5
javanek
LQ Newbie
 
Registered: Oct 2001
Location: Midwest City, OK
Distribution: Red Hat 7.0
Posts: 4

Rep: Reputation: 0
Being new myself, I understand your quandry. I just obtained a copy of StarOffice 5.2 and it does have a database program included, I think the name is Adabas. While I have been pretty busy with school and not had a whole lot of time to play, I think this might be a good solution for you.

Now (climbing up on my soap box), please do not bash MS Access. While I would not call this the ultimate DB solution on any platform, and I certainly would not say that it is ideal for an enterprise level application, it does work, well, everytime. In the last three years that I have been developing custom DB apps with Access, I have yet to encounter a problem with the program. Most of the problems have been user logic, not program logic. When I was asked to develop a custom app for a national convention registration and tracking system, Access was my choice. Betweeen cost and usefulness, there was no other DB that gave me what I needed that could be done without making it my full time job. Oh, yeah, not to mention, just about anyone can use my data.

So, as I said, it's not the perfect solution for everything. But, for just getting a workable RDB, Access is better than taking college level courses in SQL just to keep track of your video collection or club membership.
 
  


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
Could not add app to the application database... iammike Ubuntu 3 05-19-2005 06:05 AM
Which is the best language to develop a database using application tuxfood Linux - Newbie 2 12-18-2004 03:05 PM
Database + Application Servers !!!! ptreves Linux - Networking 2 07-19-2004 09:17 AM
Linux Startup Scripts for Oracle Application & Database research2004 Linux - Newbie 1 04-14-2004 06:22 AM
Connecting a Postgres Database from a Java application Paulo Ges Programming 4 08-23-2003 11:08 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

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

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration