postgres 7.1 or mysql?

Anon

What would you use?

and why?

just curious what everyone else thinks. Personally I'd go with postgres because it offers advanced functionality, and its acid compliance. Plus the reports I've read indicate it actually whoops mysql in speed ( whats up with that? ), and its more stable. MySql has its purpose as a database for websites, that don't handle a high / intense traffic load, or don't need to perform robust transactions on the database, but the number one reason why so many web developers like mysql is because its easier to work with, and use with your development. am i on point?

what does everyone else think?

P.S. Oracle is everything a database should be, but who can afford it?

Bobbo

rrijnders

As a consultant I work with DB2, Oracle, SQL Server, MySQL and PostgreSQL. Which DB to use is usually not my decision, governed mostly by the type of OS and platform.

That said, my personal stuff runs on Linux+Apache+PHP, and my choice of DB is...

PostgreSQL all the way!

I create web site infrastructures that let people maintain 99% of their web site's content through a web browser interface (ie "html forms"). As a result, 99% of the web site content comes from the DB. Every page request hits the db many times.

My old hosting company only had mySQL so I used that and it worked pretty good. When I switched to another hosting company, they offered postgreSQL so I converted. I have been sold on it ever since!

The server configurations of the two hosting companies are comparable, but it just seems to me that postgreSQL runs smoother, especially on the more sophisticated joins and on larger tables.

So far I have never lost any data (knock on wood) and have never even had to restart the postmaster.

You will no doubt get many that prefer mySQL, and I may get flamed for this post, but this is just my experience, preference, and 2cents worth.

-- Rich