💾 Archived View for station.martinrue.com › acidus › 8618e0492e264d0bb0e46b0863abb350 captured on 2023-04-20 at 01:02:35. Gemini links have been rewritten to link to archived content
⬅️ Previous capture (2023-03-20)
-=-=-=-=-=-=-
@martin the search feature of Station is really great. How do you implement it?
8 months ago · 👍 martin
@acidus @krixano Yeah, pretty much this. The FTS part is a hand-rolled The Simplest Thing That Could Possibly Work solution (where it constructs a large [but fast] query for the search terms againts the posts usernames). I'll refactor it to use SQLite's FTS once it becomes too slow, but benchmarks show it has a lot of life in it yet :) · 8 months ago
It looks to me like he's doing some type of FTS on both posts and replies, unioning those results together, and then ordering from newest to oldest.
I would also like to know more specifics :D · 8 months ago