hi chapo dev here. the tl;dr is diesel. that’s the biggest reason to switch to node. we actually spent the most time discussing which ORM/QB to use lol.
building and testing the queries will be so much easier, then we can implement the query in diesel up in lemmy via the sql escape hatch and a struct to handle the return value if diesel doesn’t offer what we need. off the top of my head, diesel doesn’t support recursive CTEs, self joins, joins for updates/deletes, no having, group by was just added.
Would be interesting to hear some thoughts from the Lemmy developers on the scalability issues of the Rust backend they mention.
hi chapo dev here. the tl;dr is diesel. that’s the biggest reason to switch to node. we actually spent the most time discussing which ORM/QB to use lol.
building and testing the queries will be so much easier, then we can implement the query in diesel up in lemmy via the sql escape hatch and a struct to handle the return value if diesel doesn’t offer what we need. off the top of my head, diesel doesn’t support recursive CTEs, self joins, joins for updates/deletes, no having, group by was just added.