@jabo is it possible to connect typesense (or any other instance search provider) to a postgresql instance and have it “just work”?
Is such a thing possible? Yes.
Has anybody built it? No :(.
That would totally be the dream though. No reindexing. Pg_search is def fast enough for a large swath of use cases.
What I do is I’ve built a real barebones search controller that connects to Postgres. My controller only lets you search on one attribute, and I use it for autocompletes. Anything more involved, I use typesense.
Never tried it out (it's on my never-getting-done list), but someone has built it: https://github.com/zombodb/zombodb