I think MySQL has the same attiude that MS has on software

Whip something up.
Seems to work.
Get it out there.
Hype the speed.
Get users to try stuff.
Get users who don't know any better to be wowed.
Get complaints from knowledgeable users who are familier with other systems.
Try to steal features from other systems.
Realize that the new features are incompatible with the old features, and decide to partially implement the new features in an attempt not to break the old features.
Fuck it up.
Break the old while not providing the new.
Scramble.
Pull out the new, attempt to put the old back in.
Declare the old baseline as the standard, and ignore the rest as long as possible.

Repeat the cycle.

Remember, MySQL is a commercial entity 1st, and is market driven.

Postgres is more of a well designed academic exercise that has spawned several commercial spin-offs. Things get put in because they are good to have, not because that satisfy a marketing need. So it is developed in a steady non-rushed fashion. Features "feel" right. It always has very high-end capabilities (log based hot-backup, moment in time queries satisfied against the log, not the changing data, etc) that blew away MySQL, and the SQL dialect done not end up surprising Oracle users, since they seems to have developed almost in tandem.

And now there is a vendor that took that Oracle aspect a bit further, and is attempting an almost complete emulation, ie: [link|http://www.enterprisedb.com/|http://www.enterprisedb.com/].

I'd suggest taking a look at it if you are an Oracle/Postgres fan.

Post #231,169 by broomberg 10/27/05 11:59:07 AM Reply	I think MySQL has the same attiude that MS has on software Whip something up. Seems to work. Get it out there. Hype the speed. Get users to try stuff. Get users who don't know any better to be wowed. Get complaints from knowledgeable users who are familier with other systems. Try to steal features from other systems. Realize that the new features are incompatible with the old features, and decide to partially implement the new features in an attempt not to break the old features. Fuck it up. Break the old while not providing the new. Scramble. Pull out the new, attempt to put the old back in. Declare the old baseline as the standard, and ignore the rest as long as possible. Repeat the cycle. Remember, MySQL is a commercial entity 1st, and is market driven. Postgres is more of a well designed academic exercise that has spawned several commercial spin-offs. Things get put in because they are good to have, not because that satisfy a marketing need. So it is developed in a steady non-rushed fashion. Features "feel" right. It always has very high-end capabilities (log based hot-backup, moment in time queries satisfied against the log, not the changing data, etc) that blew away MySQL, and the SQL dialect done not end up surprising Oracle users, since they seems to have developed almost in tandem. And now there is a vendor that took that Oracle aspect a bit further, and is attempting an almost complete emulation, ie: [link\|http://www.enterprisedb.com/\|http://www.enterprisedb.com/]. I'd suggest taking a look at it if you are an Oracle/Postgres fan.
Post #231,170 by drewk 10/27/05 12:10:35 PM Reply	Biggest thing I wanted from Postrgres that it didn't have Replication. MySQL has had master/slave replication working for several years at least. People kept posting white papers and proof-of-concept demos of multi-master replication for Postgres, but I've never seen anyone say it works for real. === Purveyor of Doc Hope's [link\|http://DocHope.com\|fresh-baked dog biscuits and pet treats]. [link\|http://DocHope.com\|http://DocHope.com]
Post #231,171 by broomberg 10/27/05 12:28:10 PM Reply	We have something working here Might be very specific to the users / tables involved. Not my project though, so I'm clueless.
Post #231,172 by broomberg 10/27/05 12:31:16 PM Reply	They claim it is in there, but no idea if it is correct for your usage. [link\|http://www.enterprisedb.com/edb-db.do\|http://www.enterprisedb.com/edb-db.do]

Welcome to IWETHEY!