Operating Systems > Linux and UNIX

Databases

(1/2) > >>

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.

Navigation

[0] Message Index

[#] Next page