DBMS for linux

[puccio]

Hi,
I'm a student who needs a good(obviously not commercial) DBMS for my linux box that adheres to great part of th SQL standard. I tried mySQL but it doesn't. I have in mind to try postgres or something else, the things that i need are:
-quite easy to install and use
-possibility of using a graphical client to make schemes, table,query,.. (just to save time.)
Thanks for all the help you could provide on choosing the right DBMS. Bye
Puccio.

[furrycat]

postgres is easy to install if you read the documentation. It has a graphical tool called pg_access that behaves much like MICROS~1 Access (boo, hiss!) and will indeed allow you to make schemas.

It's a nice piece of software, postgres. If only it supported replication like MySQL...

[puccio]

Yes I installed postgres in fact, I had only to read some documentation to do it properly. I think it is better then mySQL for what I've seen(more adherence to the SQL standard and for what I need (what is "replication"? :/ ). bye

[furrycat]

Replication is the process of having a master database and a group of slaves which mirror the tables in the master.

Update the master and you magically have a group of backups.

This is a feature I literally cannot live without (our site is designed based on the assumption it is available) so while I like postgres and use it in personal projects and for testing, it won't be replacing MySQL on production for me.

[furrycat]

Replication is the process of having a master database and a group of slaves which mirror the tables in the master.

Update the master and you magically have a group of backups.

This is a feature I literally cannot live without (our site is designed based on the assumption it is available) so while I like postgres and use it in personal projects and for testing, it won't be replacing MySQL on production for me.

[furrycat]

And my post seems to have replicated too.

Always get this on UBB boards when posting with Mozilla. Dunno who's at fault.