When to use MySQL vs PgSQL?
apinstein: I've been using postgres in production situations since 1998, at 4-5 different companies. I've never had a problem with it.OTOH, the many times I've tried to use mysql I've run into gotchas even in development that were unexpected and obnoxious. Also, I don't really like the dual gpl/commercial license thing.My faves about Postgres:- Very mature OSS development community with amazing devs/community support- Ridiculously stable- BSD license- I practically never run into a postgres bug.- GIS support- ltree data type (native trees with powerful query syntax)- Clustered indexes- Very fast under load- Simple to manage- Lots of tuning optionsTo sum up, I've used it forever and it's never caused me a problem. I am a postgres fanboy.