@r000t @alex Post in the Mastodon db?
I think it should be enough to create a GIN index:
ALTER TABLE statuses ADD COLUMN tsv tsvector; CREATE INDEX tsv_idx ON statuses USING gin(tsv);
populate it:
UPDATE statuses SET tsv = to_tsvector(text);
and than just run a regular SELECT query on it.
You need to update the index every time a post is added or create a trigger for it.
Or it might be easier to just export the column "text" into a file and run grep on it.
@LukeAlmighty Wait what? Did I miss some news?
@LukeAlmighty Doubt it
Accessibility Means GET GOOD SCRUB
@WhiteTemplar LA probably ![]()
@alyx Because cooking the amount of food required to feed the average American is too much work. I dunno ![]()
@kenshinfo It's a meme
@sjw@neckbeard.xyz @shoujoramuneframes #MeToo
I'm the joke, but you're the punchline.
I run this website. I like posting funnies and fugging lolis.