• daq@lemmy.sdf.org
    link
    fedilink
    arrow-up
    33
    ·
    9 months ago

    Huh? Postgresql is not mysql compatible. Mariadb is very popular in a ton of businesses around the world as a not stupidly expensive sql database with great support.

    • lemmyvore@feddit.nl
      link
      fedilink
      English
      arrow-up
      8
      ·
      9 months ago

      Postgresql is not mysql compatible.

      Neither is MariaDB, necessarily… if you think you can simply convert MariaDB databases to MySQL and pick up right where you left off you may be surprised. Depends on a variety of factors including which version you use, what features, the code you’ve built around it etc.

      • daq@lemmy.sdf.org
        link
        fedilink
        arrow-up
        16
        ·
        9 months ago

        I would not be surprised. I’ve done it many times including complicated setups with different databases as replica slaves.

        I’m now seeing a lot of new projects that don’t care much about DB backend since the library they use to wrap sql calls obscures all that stuff anyway, but I promise you mysql to Maria is a much more common and straightforward transition than to postgresql.