Lemmy

2172 readers

4 users here now

Everything about Lemmy; bugs, gripes, praises, and advocacy.

For discussion about the lemmy.ml instance, go to [email protected].

founded 4 years ago

MODERATORS

[email protected]

Is it possible to run a Lemmy instance with a MySQL backend? (lemmy.ml)

submitted 1 year ago by [email protected] to c/[email protected]

10 comments fedilink hide all child comments

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?

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 3 points 1 year ago* (last edited 1 year ago)

They are not really interchangeable... They are intended for different use cases.

And I'm pretty ready to bet that using any kind of bodged together compatibility-anything would be a lot more complex than just setting up postgres to begin with.

I did for my matrix instance, and its bridges, it wasn't complicated.