• lemmyvore
    link
    fedilink
    English
    arrow-up
    8
    ·
    4 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
      17
      ·
      4 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.