5 ms·
> I am not surprised at all that PostgreSQL now seems to be taking over everywhere To a large extent, Postgres didn't out-compete Mysql in mind-share by being
by gopalv 5y ago
> I am not surprised at all that PostgreSQL now seems to be taking over everywhere
To a large extent, Postgres didn't out-compete Mysql in mind-share by being a better database. Arguably it was a better DB in the Web 1.x LAMP days and everyone knew it - it just was SO hard to setup replication, which is where it still hurts (not for RDS though, which is another part of the story).
Mysql went out of its way to lose free users which was compounded when it was bought out by Oracle.
The death-blow of sorts for Mysql+Java was the GPL licensing of the jdbc binaries. This made Mysql a very sticky backend to use with a Spring or similar JVM based framework in general, because you had to convince someone that GPL is okay for a product that never leaves your building.
The postgres community on the other hand reaps the rewards of being very very friendly towards people who want to embrace its client protocols or even outright cut-pasting their code into a proprietary system which offers postgres compat but nothing else under the hood.