[Palmik]

I would like something that can keep postgres (or other source of truth) in sync with existing search database (like Elastic, Meili, or Qdrant).

But the catch is that it's rare that there's 1:1 mapping between the source of truth and what is indexed. The simplest example would be: You have a document table, but you actually index document chunks.

Therefore I would like something that accepts a preprocessing function and keeps the search data in sync when the source changes. Ideally, it should not reinvent full-text / vector based search and plug in with existing solutions.