Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 days agoStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comexternal-linkmessage-square102fedilinkarrow-up1335arrow-down110cross-posted to: technology@lemmy.world
arrow-up1325arrow-down1external-linkStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comOtto@programming.dev to Selfhosted@lemmy.worldEnglish · 2 days agomessage-square102fedilinkcross-posted to: technology@lemmy.world
minus-squaresobchak@programming.devlinkfedilinkEnglisharrow-up28·2 days 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-up12·1 day 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.