I don't think Lemmy or Mastodon would be a good place to start necessarily. Don't be discouraged, I just mean that I think this should be something separate, like a library, that other systems like Mastodon or Lemmy could then use. As a code library it could be maintained elsewhere and let these folks keep working on their projects.
However, the large architecture issue is that those tags must be added in secret - or dozens of queries would have to go off. Either:
- When someone comments #pug you also need to add on all possible permutations of pug so it's queryable or
- When someone searches for #pug you need to do a much more complex query for all possible permuations of pug.
It would be possible to do a lookup table in sql for this, but again that requires maintenance and again every instance keeping track of their own set of known lookups. Anyone else have alternative architectures?