Postgres vs. MySQL
 

We're working on the back end to our up and coming new program and wondered what all you progammer/geeky types thought about the mysql vs. postgres debate?

It seems clear that good coding is necessary... but lets *assume* that we're using professionals ;-))

Any thoughts? Which is better? Why?


Conversion Cash - Weekly Payouts

mySQL.

Depends a lot on what you are doing. We use Mysql for data collection and Postgres for reporting. Mysql is faster but Postgres has more functionality. Mysql tables can be read replicated across several servers. Postgres doesn't do replication but supposedly will support read/write replication relatively soon. Postgres supports transactions, while Mysql doesn't really. Each database has its strengths and its weaknesses.

SQL2000 :2 cents:

Oracle if you can afford it.

Otherwise MySQL for free...

MySQL, Postgres isn't a real option right now