minus-squareexpr@programming.devtoSelfhosted@lemmy.world•mysql or postgresql? Which is better for an Internet-facing applicationlinkfedilinkEnglisharrow-up2·1 month agoIts query planner is also much, much more powerful. Like it’s not even close. There’s hardly any good reason to use MySQL today. Postgres is easier and nicer to work with, with a strong community backing it. SQLite is completely different from both and has entirely different usecases. linkfedilink
minus-squareexpr@programming.devtoSelfhosted@lemmy.world•mysql or postgresql? Which is better for an Internet-facing applicationlinkfedilinkEnglisharrow-up16·1 month agoPostgres, hands down. It’s far better than MySQL in every way. linkfedilink
Its query planner is also much, much more powerful. Like it’s not even close.
There’s hardly any good reason to use MySQL today. Postgres is easier and nicer to work with, with a strong community backing it.
SQLite is completely different from both and has entirely different usecases.