• lemmyvore
    link
    fedilink
    English
    89 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.

    • @[email protected]
      link
      fedilink
      179 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.