- advanced search operators prototype. status: not quite ready for prime time.
- has a bunch of goofy operators nobody but me will ever use, such as
is:article
- still missing some classics like
lang:
,domain:
,before:
, andafter:
, and some oddballs likeis:bot
(would require extra join) andsort:
(would break ID-based paging) - needs docs, although i know where Past Vyr basically already wrote them: https://github.com/VyrCossont/mastodon/pull/8
- has a bunch of goofy operators nobody but me will ever use, such as
- indexed full text search prototype. status: heretical.
- only works on PostgreSQL: SQLite's full-text search is much fussier and requires using a "virtual table" and frankly i can't be bothered, at least tonight
- direct port of https://github.com/VyrCossont/mastodon/pull/3 and has the same limitations: HTML isn't stripped, and media alt text and poll options aren't indexed
- fixing that would start by adding a
tsvector
column that concatenates (with record separators? as an array?) the contents offilterableFields
for a status, updates it every time the status or its attachments are edited, and GIN-indexes that column - ignores the whole issue of matching posts to language tags and language tags to PG text search configurations by assuming that everything is English
- still massively faster than unindexed
ILIKE
that vanilla GTS uses
edit: fixed a backwards flag in has:media
and related operators
