• Olap@lemmy.world
    link
    fedilink
    arrow-up
    43
    ·
    1 year ago

    What would we do without postgres? How does anyone justify another SQL DB these days?

    • Buckshot@programming.dev
      link
      fedilink
      arrow-up
      24
      ·
      1 year ago

      We use SQL Server at work and I really don’t get why. It’s so expensive. We’re hosting it on AWS as well. I can’t remember the numbers but it’s several times more than a similarly specced postgres and we’re only using Standard edition.

      I don’t think we’re really using any features that would stop us moving over, it’s really just inertia and in-house knowledge.

      • ono@lemmy.caOP
        link
        fedilink
        English
        arrow-up
        15
        arrow-down
        1
        ·
        1 year ago

        Sounds like an opportunity to be the shepherd of change that saves the company money.

        Beware of one-trick database admins (if you have those) and salespeople who earn their living fighting such changes.

        • Buckshot@programming.dev
          link
          fedilink
          arrow-up
          6
          ·
          1 year ago

          Yeah I’ve been dropping not very subtle hints. We’re only a small company, about 25 people. We don’t have any dedicated database admins at all.

          It’s on the list I think but we don’t have the people to spare to get it done.

    • abbadon420@lemm.ee
      link
      fedilink
      arrow-up
      15
      arrow-down
      1
      ·
      1 year ago

      You sure know how to bring up the elephant in the room. But mysql is decent enough too, not my favourite, but good enough.

    • Turun@feddit.de
      link
      fedilink
      arrow-up
      5
      ·
      1 year ago

      Sqlite is simple.

      But I get what you mean, for large projects salute is not an option. Its embeddability is unbeatable though. open_database(":memory:") is so unbelievably convenient.

      • Michal@programming.dev
        link
        fedilink
        arrow-up
        2
        ·
        1 year ago

        Sqlite is nice and fast. I think the only disadvantage is you can’t connect to it from multiple processes or machines, so scalability goes out the window.