Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 months agoStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comexternal-linkmessage-square102fedilinkarrow-up1352arrow-down19cross-posted to: technology@lemmy.world
arrow-up1343arrow-down1external-linkStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comOtto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 months agomessage-square102fedilinkcross-posted to: technology@lemmy.world
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-up13·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.