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?

  • sinnerdotbin
    link
    fedilink
    English
    arrow-up
    1
    ·
    edit-2
    1 year ago

    Only PostgreSQL at the moment. I also don’t believe it currently supports SSL connection to Postgres so you’ll want to run it on the same machine or have a tunnel to your DB.

    There is zero chance you’ll get it running on anything else without significant code change.

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

      Diesel, the ORM package used by Lemmy, does have a MySQL backend, but all of the database migrations and performance considerations factored into the schema design are specifically written for PostgreSQL. It would be an absolutely massive undertaking to change this. It would be easier to create an entirely new threadiverse application from scratch.