Databases

[Master of Reality]

What database should i use in Linux?
I dont use databases that often (and i learned just how to use the ones in windows and on Mac (at least now just windows)). I actually am using Filemaker Pro on Mac (ugh!).

Is there an easy to use database program that has a GUI and is for Linux?

Is there any database program that is compatible with filemaker Pro for Linux?

Where can i find documents on Databases in Linux (probly easily found on google]

[voidmain]

There are several database solutions for Linux, in fact above and beyond just databases there are SQL servers, both free and open source, and proprietary and expensive.  I am very fond of two free and open source SQL server database systems.  They is PostgreSQL and MySQL. There are plenty of web based graphical front ends for both and there are some X based graphical front ends (although like most things I prefer not to use graphical front ends for any of my database work).  

For PostgreSQL and MySQL you can use webmin for a nice web based graphical database administration tool.  For PostgreSQL I there is an Xwindows (tk based if I recall) utility called "pgaccess" that gives you an MS Access like graphical environment.  Then of course you can run the expensive SQL servers like Sybase and Oracle and IBM DB2 on Linux and there are plenty of graphical administration tools for them for administration, even from a Windows client (much like MS SQL Server Enterprise Manager).

[Master of Reality]

I gotta ask whats with the databases that are already made when i first started MySQL server? Are they there for a reason? What do they do?

[Master of Reality]

so those are the users/hosts and stuff that can access the MySQL server.

[voidmain]

I would suggest the first thing you should do is go to http://www.postgresql.org/ and http://www.mysql.org/ and read over the descriptions and FAQs.

I use both PostgreSQL and MySQL.  PostgreSQL is probably closer to a Sybase or MS SQL Server as it is transaction based.  However, MySQL is probably more popular for small web databases and it is very fast.  There is great PHP support for both databases and the programming for both are very very similar.

[Master of Reality]

http://www.devshed.com/Server_Side/MySQL/Intro/page2.html
http://www.devshed.com/Server_Side/Administration/Database/page6.html
are two good pages i was looking at.

[dbl221]

MySQL does not support foreign keys and therefor it does not enforce referential integrity...use postgresql...On the plus side MySQL is soooo fast.

[Master of Reality]

I wonder if the Webmaster still uses MySQL for this forum.

[badkarma]

Since about version 7.0 the speed of PostgreSQL has greatly improved. Also it can handle a lot more concurrent connections then MySQL. If you need simple web backend low query intensitive DB support use MySQL. If you plan on doing any serious DB work, use Postgres.....

[voidmain]

Very true Karma.  I generally use PostgreSQL wherever possible because it is more robust. But there is one application in particular that I use MySQL for and that is for my "snort" IDS database. For some reason MySQL greatly outperforms PostgreSQL with when it comes to using "acid" to use/view the database when the database starts getting large (hundreds of thousands of records). But PostgreSQL is much more like the big boys...