Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 months agoStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comexternal-linkmessage-square103fedilinkarrow-up1355arrow-down19
arrow-up1346arrow-down1external-linkStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comOtto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 months agomessage-square103fedilink
minus-squaresobchak@programming.devlinkfedilinkEnglisharrow-up31·2 months agoPostgres is basically an open source version of Oracle DB. Much more featureful than MySQL. I believe Oracle bought MySQL just to kill it.
minus-squaremsage@programming.devlinkfedilinkEnglisharrow-up14·2 months agoMySQL always sucked ass. PostgreSQL went in a different direction, started with best support of the SQL standard, then optimized everything to make it fast. Postgres has/had the best SQL standard support out of every server, open-source or not. MySQL was at the other end, only started catching up after Oracle bought it.
Postgres is basically an open source version of Oracle DB. Much more featureful than MySQL. I believe Oracle bought MySQL just to kill it.
MySQL always sucked ass.
PostgreSQL went in a different direction, started with best support of the SQL standard, then optimized everything to make it fast.
Postgres has/had the best SQL standard support out of every server, open-source or not.
MySQL was at the other end, only started catching up after Oracle bought it.