MySQL 4.0.17 in production

[LordShryku]

http://www.eweek.com/article2/0,4149,1420487,00.asp

Nice little article about MySQL's newest release. I've read a couple others about companies switching from Oracle to MySQL. While I use both, and my company is all Oracle, it's nice to see open source winning some battles :)

[planetsim]

It wont be long for Open Source to win the OS battle either a day i think most cannot wait for.

[Weedpacket]

PostgreSQL is also getting some notable names under its belt; Fujitsu and the .org TLD registry spring to mind.

[LordShryku]

I've thought about that a bit Weed. You'd think some of these big companies switching to MySQL might have needed a bit more power than MySQL could offer. Postgres is a great alternative if it's power you need. For what I've noticed, on large transactions, MySQL is a bit faster, but Postgres definately has more to offer.

Not to start a MySQL vs PostgreSQL battle. Just something I was pondering :)

[jebster]

Originally posted by LordShryku
Not to start a MySQL vs PostgreSQL battle.

Go right ahead, threads like that are fun to read :)

[LordShryku]

I'm not the person to start it. I'm too far in the middle. I like pgsql's robust capabilities, but I like mysql's speed and ease of use. I'm so torn! :D

[Merve]

Never tried Pgsql because I'm too lazy to learn it...do they have a PHPMyAdmin workalike for it? Maybe I'd learn it then...I'll google...

[Moonglobe]

http://phppgadmin.sourceforge.net/index.php

[Weedpacket]

Originally posted by LordShryku
Not to start a MySQL vs PostgreSQL battle. Just something I was pondering :) One thing that springs to mind is the lack of a native Windows implementation (it's been delayed again); but then, there are a number of commercial ports, and commerical software does have the advantage of making Mgt feel safer in that they have someone obvious to go to for support.

But ooh, ooh! plPHP is in beta! Write PostgreSQL stored procedures in PHP instead of in SQL, Perl, Tcl or Python! (stored procedures, incidentally, which can in certain situations drastically reduce the size of transactions). But then, if you're talking about large transactions you have to consider large databases, and PostgreSQL wins there (http://www.postgresql.org/users-lounge/limitations.html).

[LordShryku]

Hot on the heels of a new production release, we have a new alpha release(5.0.0). Changes include basic support for SQL-99 stored procedures....

http://www.mysql.com/downloads/mysql-5.0.html