• 0 Posts
  • 87 Comments
Joined 2 years ago
cake
Cake day: June 12th, 2023

help-circle



  • Postgres is far superior in every way.

    We used MySQL (and Percona XtraDB) servers at work, and it is so bad. So I made several presentations showing generic and specific reasons why Postgres is better. I had to cut a lot of content because MySQL is just that bad.

    Some things may not seem relevant now, but as you keep the DB around long enough, you will appreciate the whole package of Postgres.

    Things that will help a lot, but are extensions:

    • pg_partman - for automatic partition management
    • patroni - management of replicas, automatic failover - it does everything for you with simple commands

    There is a DB comparison matrix, but hasn’t been updated in over a year, which is a shame, but still gives you the idea of how different databases support SQL features: link.

    Spoiler: postgres has the most support, with a huge lead

    Edit: MySQL is dead last, btw







  • The number one reason not to switch is “I don’t want to”. And I dislike that Windows users keep repeating decades old solved issues as excuses instead of being honest.

    ‘But muh games’ only very few don’t work OOB or at all.

    ‘I need this software’ most works flawlessly under Wine.

    ‘It crashes’ exactly as often as Windows with faulty hardware or bug in a driver.

    ‘Hardware isn’t plug&play’ more hardware works with Linux without installing drivers.

    Jusy say “I dont want to give it a shot” or “I’m in the minority that can’t switch”, but don’t bullshit people about Linux requiring cmd to work. And those people then suggest editing registry to remove ads… It’s dishonest and in bad faith.

    FOSS is the only way forward to stop complete enshittification of the digital space, like it or not.

    Also I hate Microsoft and Apple with all my soul.

    I get that most don’t care, but that doesn’t mean supporting those companies is good.