Offline first full text search

[ouvreboite]

Wondering if some here already tried to do full text search on top of tanstack-db.

I see several options and I'm sure I'm missing some.

• using db's ilike operator in the where clause: the most idiomatic, even if a little barebone. I don't know if having a query that change very fast is optimal (think "search as you type" scenario)
• using a browser-compatible FTS lib (like minisearch) and building an index based on a non-filtered db query

[samwillis]

The indexes that are applied to collections are extendable (they are used by the query engine to loop up matching rows), and so it's possible to create a FTS index using something like BM25. We plan to get to this, but current priorities are to stabilise and finish the incremental sync implementation.

In my mind we end up with an api like this (after indexing the content column):

q
  .from({ item: itemsCollection })
  .where(({ item }) => fts.like(item.content, 'something')
  .select(({ item }) => {
    ...item,
    score: fts.score(item.content, 'something')
  })