Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

Possible Duplicate:
Do you recommend PostgreSQL over MySQL?

A client would like to use a free database for an upcoming project.

My question is I wanted to give him the option of either MySQL or PostgreSQL. I'm familiar with both on usage from a code stand point but what benefits (if any) would one have over the other.

The project is a internal webservice (PHP/Python and maybe Java) but could be external if things go well enough.

I know this might be a subjective question but I'm looking for performance related answers or pitfalls that could arise by choosing one over the other. Or could this type of question be migrated to another site?

Thanks in advance for any advice

share|improve this question

marked as duplicate by RedFilter, Adrian Carneiro, amosrivera, leonbloy, Johan Sep 27 '11 at 20:45

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1  
see stackoverflow.com/questions/110927/… –  amosrivera Sep 27 '11 at 20:40
    
That question has been asked many, many times. It is subjective and shouldn't really be here in this unspecific form. My very subjective answer is: Postgres, all the way. More advanced, more secure, more free. –  Erwin Brandstetter Sep 27 '11 at 20:49

2 Answers 2

up vote 12 down vote accepted

This one is rather complete: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL

Performance depends on how you use the database, bad queries on a bad datamodel can cripple any database, smart queries on a smart datamodel let that same database fly like a rocket. It depends for at least 80% on you, not the brand.

I use PostgreSQL, it's easier to handle and has much more functionality. And the best licence, BSD style.

share|improve this answer
    
Great read, thanks –  Phill Pafford Sep 27 '11 at 20:42

You can find a lot of information if you just google mysql vs postgresql.

Plus, there was a good link in today's CodeProject newsletter: http://www.databasejournal.com/features/mysql/buying-guide-open-source-databases.html

share|improve this answer
    
Thanks for the link –  Phill Pafford Sep 27 '11 at 20:47

Not the answer you're looking for? Browse other questions tagged or ask your own question.