

No they don’t use sql views, they’re built using an in query (which we still have to see how performant that’ll be, and is pretty much the same problem as subscribed communities, needing to sort and filter based off joined data)
You can see them in action here: https://github.com/LemmyNet/lemmy-ui/pull/3521













“Gonna need to see a source from a white country before I’ll believe anything positive about China, the DPRK, Venezuela, Cuba. If it ain’t white, it ain’t right.”