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?
Diesel supports mysql/Maria but meanwhile lemmy itself assumes it will be psql & I agree that changing that esp after 0.18 would be a silly idea. Changing it to support clickhouse or bigtable/c*/dynamo also a silly idea but maybe more worthwhile than mysql.
I personally would love to see Cockroach support, as that is still a dialect of pg but often takes some work to get running right/well/at all.