Database question

puppy · 09-30-2003, 04:38 PM

Can anyone advise on a good relational database that I can use in Linux? OpenOffice doesn't have one and I am looking for something that is quite [GULP!] access-like.....

Any suggestions for one with a good WYSWIG interface?

pld · 09-30-2003, 04:50 PM

It isnt really wysiwyg, but you should probably look up MySQL. Fantastic db. i recently learned to use it as a back-end to a dynamic website, and it really suited my needs fine. Check it out!

http://www.mysql.com

trickykid · 09-30-2003, 04:51 PM

I'm not sure about great GUI features but the most popular are mysql or postsql...

I think mysql has several open source projects that create a gui frontend for it.. try taking a look at www.sourceforge.net or maybe www.freshmeat.net for open source projects... etc.

speter · 09-30-2003, 04:52 PM

For the backend, I use MySQL. For a frontend, you might want to consider MySQL Control Center. Having never used Access, I can't say how similar it is, but there are several good Linux frontends to MySQL.

Steve

warned · 10-01-2003, 01:36 AM

Well, you ask for a good relational database, but MySql do not implement referential integrity, so you need to control foreing keys by software. So I prefer PostgreSQL, that let you do this. I think it has a GUI too, but I cannot remember the name.