LinuxQuestions.org
Review your favorite Linux distribution.
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 12-14-2003, 12:47 PM   #1
linuxlover1
Member
 
Registered: Jun 2003
Location: UK
Posts: 54

Rep: Reputation: 15
Question A Database for Linux


Hi to all !

I am new to Linux ,and i was wandering : Is there any Database program in Linux Like Microsoft Access ? I mean i want to make a database but i dont know any database programming so a GUI database program is my only choise. Any suggestions ??

Thx in advance !
 
Old 12-14-2003, 04:41 PM   #2
scottpioso
Member
 
Registered: Jan 2003
Location: United States of America and damn proud of it!
Distribution: Ubuntu
Posts: 466

Rep: Reputation: 30
Umm, personally, I would use Oracle. It's harder to learn but a lot more reliable than Access.
 
Old 12-14-2003, 06:43 PM   #3
wapcaplet
Guru
 
Registered: Feb 2003
Location: Colorado Springs, CO
Distribution: Gentoo
Posts: 2,018

Rep: Reputation: 48
I would definitely not use Oracle, especially if you are not interested in learning programming.

Unfortunately, I haven't run across anything in Linux that's quite as nice as Access. There are several powerful database systems, including Oracle, as well as free alternatives such as MySQL and PostGreSQL, but as far as a nice GUI database, they can be hard to find.

I'd say it partly depends on how many of Access's features you actually used, though. If you want something that has the full potential to create a graphical front-end for your databases, along with the VB-style event handling, functions, and so on, you may be better served by learning how to set up and configure one of the powerful SQL databases mentioned above. You'll probably need to learn SQL, at the very least, to do anything very useful with a database.

If you're more interested in just having a simple row/column database for keeping track of your CD collection or whatnot, you could probably find a specialized database with a GUI for your particular purpose.

Check out this article on Freshmeat, which may address some of your questions.

Last edited by wapcaplet; 12-14-2003 at 06:46 PM.
 
Old 12-14-2003, 06:47 PM   #4
scottpioso
Member
 
Registered: Jan 2003
Location: United States of America and damn proud of it!
Distribution: Ubuntu
Posts: 466

Rep: Reputation: 30
Well Wap,

Yeah, he could use Access if he wants to go with M$ crap. I have begun to hate M$ with a vengeance. Almost as bad as Daryl McBride but not quite as much. And another thing you're not even considering is how would access run on a LInux box in the first place?? I only suggested Oracle because as I understand it, most large companies that have databases use Oracle. I could be wrong but that's what I have been told to understand.
 
Old 12-14-2003, 08:52 PM   #5
Steve Cronje
Member
 
Registered: Jan 2003
Location: Canada
Distribution: Ubuntu, Mepis, Debian
Posts: 158

Rep: Reputation: 30
Re: A Database for Linux

Quote:
Originally posted by linuxlover1
Hi to all !

I am new to Linux ,and i was wandering : Is there any Database program in Linux Like Microsoft Access ? I mean i want to make a database but i dont know any database programming so a GUI database program is my only choise. Any suggestions ??

Thx in advance !
I have not tried or personally used this, but it seems to a GPL version of an Access-like DB frontend

http://www.rekallrevealed.org/

HTH
Steve
 
Old 12-14-2003, 09:30 PM   #6
budhusa
LQ Newbie
 
Registered: Dec 2003
Location: Austin, TX and Budapest, Hungary
Distribution: Mandrake 9.2
Posts: 27

Rep: Reputation: 15
OpenOffice plans to have one in their 2.0 release, although thats not coming around until 2005...so i guess my comment is not of much use...
 
Old 12-14-2003, 09:32 PM   #7
PDR60
Member
 
Registered: Aug 2003
Location: Oakland, TN
Distribution: Debian, Kubuntu
Posts: 257

Rep: Reputation: 30
If you install MySQL which is a pretty good data base, It will get done what you want. If you want a gui interface ( I use it all the time) Go to MySQL's site and download the control center. It looks allot like the MS SQL enterprise manager. Its a great way to create your data bases and tables without knowing the command line options. Give it a try it will work for you.
 
Old 12-14-2003, 09:41 PM   #8
budhusa
LQ Newbie
 
Registered: Dec 2003
Location: Austin, TX and Budapest, Hungary
Distribution: Mandrake 9.2
Posts: 27

Rep: Reputation: 15
on that note, phpmyadmin does the job very well too, if you just need the gui for creating, viewing, maintaining the databases, tables, and records...
 
Old 12-14-2003, 09:45 PM   #9
PapaNoHair
Member
 
Registered: May 2002
Location: Orlando
Distribution: Linspire 5.0
Posts: 82

Rep: Reputation: 15
Re: A Database for Linux

Quote:
Originally posted by linuxlover1
Hi to all !

I am new to Linux ,and i was wandering : Is there any Database program in Linux Like Microsoft Access ? I mean i want to make a database but i dont know any database programming so a GUI database program is my only choise. Any suggestions ??

Thx in advance !
I had the same problem.. Solved it by using StarOffice (currently using the older 5.2 version). I set up a simple db database and imported my Access files. Was a snap. If you decide to go this route and need help, let me know and will be glad to assist.
 
Old 12-15-2003, 12:04 AM   #10
wapcaplet
Guru
 
Registered: Feb 2003
Location: Colorado Springs, CO
Distribution: Gentoo
Posts: 2,018

Rep: Reputation: 48
Quote:
Originally posted by scottpioso
Yeah, he could use Access if he wants to go with M$ crap. I have begun to hate M$ with a vengeance. Almost as bad as Daryl McBride but not quite as much. And another thing you're not even considering is how would access run on a LInux box in the first place?? I only suggested Oracle because as I understand it, most large companies that have databases use Oracle. I could be wrong but that's what I have been told to understand.
I don't recall suggesting that using Access was a good idea, nor that it was a possibility, though apparently Crossover Office makes it fairly easy to run MS Office (including Access) under a modified version of Wine.

As for Oracle, to the best of my knowledge it is a rather pricey package. This place lists Oracle licenses for around $12,000 at discount; I have no idea what they actually cost, but it's certainly not cheap, and definitely not for the hobbyist. Sure, some large companies use Oracle, because they can afford it. A lot of other (in my opinion, smarter) companies use MySQL or PostgreSQL because they are free
 
Old 12-15-2003, 12:25 AM   #11
Crito
Senior Member
 
Registered: Nov 2003
Location: Knoxville, TN
Distribution: Kubuntu 9.04
Posts: 1,168

Rep: Reputation: 53
Sybase's Linux products are often overlooked. They have much more in common with MS SQL Server than Oracle does, which makes transitioning painless. SQL Anywhere Studio is ideal for smaller companies and developers.
http://www.sybase.com/linux
 
Old 12-15-2003, 12:08 PM   #12
linuxlover1
Member
 
Registered: Jun 2003
Location: UK
Posts: 54

Original Poster
Rep: Reputation: 15
Thx a lot men !!!!
You were very helpful to me !!
 
Old 12-15-2003, 03:15 PM   #13
Velvet Elvis
Member
 
Registered: Dec 2003
Distribution: debian (when I can) RHEL (when I must)
Posts: 98

Rep: Reputation: 15
If you check out rekall, could you report back and let us know how it compares to access? I've been meaning to check it out, but being on dialup I've not had the chance to download it.
 
Old 12-16-2003, 07:19 AM   #14
linuxlover1
Member
 
Registered: Jun 2003
Location: UK
Posts: 54

Original Poster
Rep: Reputation: 15
I have tryied to install rekall but i faced some critical problems during the installation so i gave up.
I think , i am going to learn MySQL.
 
Old 01-12-2004, 06:58 PM   #15
nonamenobody
Member
 
Registered: Oct 2002
Posts: 138

Rep: Reputation: 22
>> I have tryied to install rekall but i faced some critical problems during the installation so i gave up.
>> I think , i am going to learn MySQL.

There is a slightly updated version of Rekall (released late December) which should be easier to compile (I found it much easier). There is also a precompiled trial version too if you want to try it. I am sure there will be freely available binaries appearing soon too (the source code makes it very easy to generate RPMs for various distros).
 
  


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
ACT! Database to Linux - Can it be done? sugar05 Linux - General 0 08-29-2004 06:21 AM
database for linux and microsoft yamakid Linux - General 1 01-29-2004 12:40 AM
Relational Database on Linux Ronw Linux - Software 10 11-11-2003 02:40 PM
database servers in linux spyghost Programming 8 09-29-2003 04:06 PM


All times are GMT -5. The time now is 03:18 AM.

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