floof.org
Pippin
Pippin 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

Link to source
3 1
Soatok Dreamseeker
Soatok Dreamseeker • mastodon (AP)
@q MySQL (MariaDB really) and PostgreSQL are both okay. They solve problems well and get out of your way.
@Q ✨
Link to source
1
Pippin
Pippin 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 ✨
Link to source
Soatok Dreamseeker
Soatok Dreamseeker • mastodon (AP)
@q I like Postgres better, but that's mostly due to familiarity
@Q ✨
Link to source
1
viq
viq • mastodon (AP)
@soatok @q if you want to play around, AFAIK https://steampipe.io/ actually launches embedded postgresql underneath as you run it

Steampipe | select * from cloud;

Steampipe is an open source tool to instantly query your cloud services (e.g. AWS, Azure, GCP and more) with SQL. No DB required.
Steampipe
@Soatok Dreamseeker @Q ✨
This entry was edited (1 week ago)
Link to source
1 1
Antwan van Houdt
Antwan van Houdt • mastodon (AP)
Don't, its addictive. Need PubSub? yeah. .. it does that. Need a message queue? Yup. Can you write a frontend in it? Yupp. API? YUPPERS. Its bonkers.
Link to source
1 1