cross-posted from: https://lemmy.ml/post/1374138

I’m thinking about setting up my own (bare metal) Lemmy instance to play around with it, but it seems to require PostgreSQL. Everything else on my system uses MySQL, and I don’t really want to run 2 separate database services. I guess I would also be fine with using an SQLite file, but that’s not ideal.

Has anyone managed to set up a Lemmy instance with MySQL instead of PostgreSQL? Are you aware of any PostgreSQL to MySQL or SQLite compatibility layers?

  • suborbital@lemmy.ml
    link
    fedilink
    English
    arrow-up
    1
    ·
    1 year ago

    I know you stated wanting to run it on bare metal, but why not docker containers with a compose file? Would keep your system clean.

    • JuxtaposedJaguar@lemmy.mlOP
      link
      fedilink
      English
      arrow-up
      3
      ·
      1 year ago

      I don’t like Docker, personally. I’m not strongly opposed to using it, but I want to keep everything bare metal if I can.