Pippin

Pippin 3 months ago friendica

Disclaimer: While I'm sure it's lovely, I have yet to actually use Postgres. I've just never had the push to do so yet — everything I've used so far has wanted MySQL (or SQLite, or…). Also, I wish I had the energy to pick up new things like I used to.

Q ✨

2024-09-09 08:45:35

years of database software development and yet no real world use found for anything other than Postgres

3 1

Soatok Dreamseeker 3 months ago • mastodon (AP)

@q MySQL (MariaDB really) and PostgreSQL are both okay. They solve problems well and get out of your way.

@Q ✨

Pippin 3 months ago friendica

@Soatok Dreamseeker @Q ✨ MySQL and co have certainly grown up a *lot* since mysql was first being compared to Postgres. I've definitely had MySQL/MariaDB databases very occasionally shit themselves in various ways over the years, but at least I know enough I can usually clean up and make it work again. I've read quite a few times (admittedly mostly a long time ago) how much better Postgresql is but I don't have the experience to know if corrupted tables and the like are any less common there. I'm sure I'll give it a go someday, maybe I'll find out! In the meantime, agreed, mysqld certainly does the job, without fuss, pretty well, pretty much of the time.

@Soatok Dreamseeker @Q ✨