People who prefer MySQL to PostgreSQL, why? I'm usually on the Postgres side myself, but I'd like to see the other side.

Follow

@alexbuzzbee

> People who prefer MySQL to PostgreSQL, why? I'm usually on the Postgres side myself, but I'd like to see the other side.

I don't have a particularly strong preference, though I've used Postgres more often just based on the projects I've worked on.

How about turning the question around--why do you prefer ?

@codesections @alexbuzzbee better query optimization, particularly for complex queries; not owned by Oracle; historically much better data integrity, though MyISAM is ancient history at this point

@codesections Schema inheritance is nice, as are some of the extensibility features, and it’s a bit safer than MySQL (as in, it prefers to error rather than risk trashing your data).

It also has some datatypes MySQL is lacking, such as a Boolean type, and it supports some SQL features MySQL doesn’t, such as FULL OUTER JOIN.

@alexbuzzbee @codesections
On top of these, the PostgreSQL development cycle and feature releases are very organized and predictable. You can plan ahead with confidence.

Plus, the pgsql-general mailing list is the best I've ever encountered. I've learned a lot about SQL and databases in general just by following it. Sometimes the simplest questions are answered by the top developers. I don't know where else that happens on a project on this level.

Sign in to participate in the conversation
Fosstodon

Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.