"Wiggins" == Wiggins D'Anconia <[EMAIL PROTECTED]> writes:
Wiggins> But what are the reasons for choosing PostgreSQL over MySQL? What's a Wiggins> "real" database? Without providing reasons this is just FUD. I will Wiggins> agree that if you are looking for a package closer to a "real Wiggins> database" you will need to look past MySQL 3.x to the 4.x series.
But if you don't want to wait the next five years for MySQL to catch up to where PostgreSQL is now, you might as well install PostgreSQL.
Don't quote the old "MySQL is faster" FUD, because that's not valid. For example, SourceForge picked Pg over My based on *performance* as one of the key factors, and the choice is well documented (see <http://www.phpbuilder.com/columns/tim20000705.php3?page=1&print_mode=1>).
In every category, Pg is technically superior to My. The only way My now wins is inertia or bolt-on compatibility with legacy apps and legacy brains.
What categories are those though? That was my point, no one quoted performance, no one has quoted any reason, that is the problem with the discussion so far. There are at least two categories MySQL is better, it is shorter to type without abbreviation, and comes first in the alphabet. Worthy reasons? Doubtful, but to blindly say Pg is better hands down and then not to give any reason doesn't instill much faith in your opinion.
MySQL is open source, fast, easy to install, secure as far as I know, has a relatively full implementation of SQL standards with some nice extra language functions if cross-db SQL isn't needed, good documentation, commercial support if desired, a nice looking web page, internetworking ability, a DBI driver, transactions (now), multiple platform support, etc. Granted, all of which Pg has as well, but just having the same things doesn't make one product superior. So why?
Wiggins> Regardless the OP should analyze the DB chosen based on their own Wiggins> needs. Having a discussion about what makes a good DB is probably OT Wiggins> for this group, so suggesting that a choice already made is inadequate Wiggins> is as much OT.
I didn't see anything that insisted on MySQL. I was just trying to steer the OP toward a better choice to keep the knowledge entropy to a minimum, and remove the chance for "one more legacy brain that will need rewiring".
Tell us why this is a legacy brain? ...
Vim is better than emacs, PHP is better than Perl, Red Hat is better than Suse, Gentoo is better than Debian, Gnome is better than KDE, Linux is better than Windows, Java is better than C++, MySQL is better than PgSQL
I have heard these discussions before, no one ever seems to win....
http://danconia.org
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
