Issue:Trending topics
Priority 3 Created 2023-02-09
Also if this is for news, are you going to be doing any NLP on plaintext to find trending topics/ngrams (not just hashtags)?
Natural Language Processing, ML technique to ensure that you could pull out concepts rather than just single words from your database, that would be a way that you could have more intelligent trending topics if you chose to go down that route.
2023-02-25: use Fts4aux https://www.sqlite.org/fts3.html