> 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 #Postgres?
@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.
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.
Fosstodon is an English speaking Mastodon instance that is open to anyone who is interested in technology; particularly free & open source software.