this post was submitted on 20 Jun 2023
7 points (100.0% liked)
Lemmy
12514 readers
23 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
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Lemmy is implemented in Rust using the Diesel ORM/Query Builder for persistence. I don't know enough rust to comment specifically, but based on my knowledge of other ORMs and stuff it should be possible to support different database backends, but it would likely not "just work" without some effort on the part of the developers.
One of the things that is being done for the next release is a bunch of pg optimization work, which to me makes it even less likely for it to work with minimal changes, as they are likely putting in some amount of postgres-specific code to achieve those gains.
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.