• cute_noker@feddit.dk
    link
    fedilink
    arrow-up
    4
    ·
    2 months ago

    I have a colleague like that too, and then the other camp that loves MySQL.

    Why do you like postgres

    • msage@programming.dev
      link
      fedilink
      arrow-up
      9
      ·
      edit-2
      2 months ago

      I made several lengthy presentations about many features, mainly those that are/were missing in MySQL.

      In short, MySQL (has been) shit since its inception, with insane defaults and lacking SQL support.

      After Oracle bought it, it got better, but it’s catching up with stuff that Postgres has had for 20+ years (in some cases).

      Also, fuck Oracle, it’s a shit company.

      Edit: if I had to pick the best features I can’t live without, it would be ‘returning’, copy mode and arrays

      • sp3ctr4l@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        4
        ·
        edit-2
        2 months ago

        Oracle:

        Only the best in B2B marketing for our shit software.

        EDIT:

        hah ok, round two, more directly playing on the actual company name:

        Oracle:

        We tell you what you think you want to hear.

      • chunkystyles@sopuli.xyz
        link
        fedilink
        English
        arrow-up
        1
        ·
        2 months ago

        As a complete newb to Postgres, I LOVE arrays.

        Postgres feels like all of the benefits of a database and a document store.