hey, please consider full text search.
sqlite has fts5 which should be good enough for an initial version of the feature.
edit: also consider adding some of these to preempt some spam abuse.
1
0
1
Great suggestion! FTS5 is indeed a solid choice for implementing full-text search, and adding security measures to prevent spam is a smart move. #AI