Wil — Sat, 08 Feb 2003 12:56:56 +0000

I'm not sure Mark, I do hope so. Postgresql does indeed have the one up on MySQL over a number of features in 3.x MySQL. I think version 4 will be a huge step forward for MySQL and a welcomed one at that.

Same story with Apache 2/mod_perl 2 though. It's a waiting game. But until the wait is over, I'll continue to use postgresql, especially on high traffic sites where there's a lot of interaction with the database in terms of adding/updting records.

MySQL is super fast for *retrieving* records from the database. Anything more than that and it falls down big time from my own experience.

Mark Hensler — Fri, 07 Feb 2003 23:08:45 +0000

But will 4.0 have stored procs & triggers?

mairving — Fri, 07 Feb 2003 20:48:08 +0000

Quote: Originally posted by Mark Hensler
I've not worked with postgre at all, but I've been told it does support stored proceedures and triggers. Something that you'll have to wait for in mySQL version 4 (it is in there, right?).

4.0 has been in Alpha forever. It has finally made it to Gamma. Beta can't be far behind.

Mark Hensler — Fri, 07 Feb 2003 18:36:50 +0000

I've not worked with postgre at all, but I've been told it does support stored proceedures and triggers. Something that you'll have to wait for in mySQL version 4 (it is in there, right?).

listless — Fri, 07 Feb 2003 17:43:08 +0000

MySQL trounces Postgresql in all the benchmark tests I've seen, tho I'll admit having only seen a few.

mairving — Fri, 07 Feb 2003 17:34:42 +0000

Quote: Originally posted by Wil
Why not go for postgresql? It's a much better database than MySQL in terms of stability and it's SQL dialect.

I would disagree with that. I have never had nor seen a stability issue with MySQL. Plus it is much easier to find scripts, hosts, etc for MySQL.

Wil — Fri, 07 Feb 2003 17:07:22 +0000

Why not go for postgresql? It's a much better database than MySQL in terms of stability and it's SQL dialect.

listless — Thu, 06 Feb 2003 17:56:52 +0000

Similar Q on DevShed

Seven reasons why PHP is better

Benchmark results from MySQL.com (well, de in this case)

For a project as small in scope as what you mention, I see no real advantage to using Microsoft stuff, unless you have a pre-existing investment in their gear. Too much dough, insufficient support. My dos pennies.

zollet — Wed, 05 Feb 2003 22:23:22 +0000

I HIGHLY recommend you going with PHP/MySQL mainly for the reasons given in the link provided above.

mairving — Wed, 05 Feb 2003 20:16:47 +0000

Scalability shouldn't be any problem at all at that level. I am not a big fan of ASP/M$SQL since I feel like PHP/MySQL runs much faster on similar machines. Certainly PHP/MySQL would save you some money also. Here are some reasons to go with PHP. I will let Peter give you the reasons to go with ASP.