Discussion: DBMS's.....
Posted: Fri Dec 09, 2005 10:40 am
Before I start, I'm looking for a discussion, not a flame-war, although I'm not sure this lends itself to flaming in any case 
After spending the past 2 years working with just MySQL I've decided it's time to play around with some other SQL-based DBMS's and perhaps change what I'm using by default, but at the very least gain the experience.
I'm learning PgSQL (Postgres) at the moment which seems nice and easy enough to switch too if you're used to MySQL (I find the way you add users and create databases/set privileges a bit odd though) and then I'm going to have a play with Oracle 8 (Free Developer License).
I think it'd be interesting to read what your opinions on the pros and cons of various DBMS's are in the real world.
One thing I'm particularly interested in is the server load. Postgres is drastically lower on memory usage from what I've seen so far in comparison to MySQL which guzzles at my RAM. That's a big plus when I'm running a VDS server where costs go up if I require more RAM allocation.
Without further ado.... discuss!
After spending the past 2 years working with just MySQL I've decided it's time to play around with some other SQL-based DBMS's and perhaps change what I'm using by default, but at the very least gain the experience.
I'm learning PgSQL (Postgres) at the moment which seems nice and easy enough to switch too if you're used to MySQL (I find the way you add users and create databases/set privileges a bit odd though) and then I'm going to have a play with Oracle 8 (Free Developer License).
I think it'd be interesting to read what your opinions on the pros and cons of various DBMS's are in the real world.
One thing I'm particularly interested in is the server load. Postgres is drastically lower on memory usage from what I've seen so far in comparison to MySQL which guzzles at my RAM. That's a big plus when I'm running a VDS server where costs go up if I require more RAM allocation.
Without further ado.... discuss!