Otto@programming.dev to Selfhosted@lemmy.worldEnglish · 6 days agoStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comexternal-linkmessage-square102fedilinkarrow-up1314arrow-down17cross-posted to: technology@lemmy.worldlobsters@lemmy.bestiver.se
arrow-up1307arrow-down1external-linkStop using MySQL in 2026, it is not true open sourceoptimizedbyotto.comOtto@programming.dev to Selfhosted@lemmy.worldEnglish · 6 days agomessage-square102fedilinkcross-posted to: technology@lemmy.worldlobsters@lemmy.bestiver.se
minus-squareBrilliantantTurd4361@sh.itjust.workslinkfedilinkEnglisharrow-up29·6 days agoWhy would anyone ever choose mysql over postgres?
minus-squareScrollone@feddit.itlinkfedilinkEnglisharrow-up8·6 days agoMySQL has been the “default” choice for a long time for PHP programmers. I don’t know why.
minus-squarewhoisearth@lemmy.calinkfedilinkEnglisharrow-up7·6 days agoIt used to be free with less of a barrier to entry than poatgrea.
minus-squareAndres@social.ridetrans.itlinkfedilinkarrow-up0·6 days ago@Scrollone @BrilliantantTurd4361 Because it used to be a lot faster than postgresql for smaller sites. MyISAM (https://en.wikipedia.org/wiki/MyISAM) was super lightweight, at the expense of the occasional corrupt database (oops). I don’t know how many new people are coming to PHP these days (as opposed to javascript/python/rust/etc), but certainly the older PHP coders grew up using mysql.
Why would anyone ever choose mysql over postgres?
MySQL has been the “default” choice for a long time for PHP programmers. I don’t know why.
LAMP indeed
We need LAPP . Stat!
It used to be free with less of a barrier to entry than poatgrea.
Tutorials mostly.
@Scrollone @BrilliantantTurd4361 Because it used to be a lot faster than postgresql for smaller sites. MyISAM (https://en.wikipedia.org/wiki/MyISAM) was super lightweight, at the expense of the occasional corrupt database (oops).
I don’t know how many new people are coming to PHP these days (as opposed to javascript/python/rust/etc), but certainly the older PHP coders grew up using mysql.