3 ms·
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 sw
by adenta 6y ago
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.
- karterk 6y agoAs I posted in another comment [1], the biggest problem is handling updates and deletes. Requires that you do some kind of logical deletion with an `last_updated_at` timestamp to fetch updates from a primary table. [1] https://news.ycombinator.com/item?id=25417856 https://news.ycombinator.com/item?id=25417856
- adenta 6y agoI don't quite follow. For a system reliant entirely on Postgres, you can just fetch the records, and join them in real time, no? It would be much slower than elasticsearch, but still _good enough_ for a lot of use cases.
- karterk 6y agoI was referring to an integration between Postgres and an external search system such that the data sync is automated. That was what the parent comment was asking about (I think).
- adenta 6y agoAhh, I understand, this is my mistake. What I really want is an integration between Instantsearch.js, and Postgres. Typesense has written a custom adapter for Instantsearch & Typesense. I would love to just hook Instantsearch up to directly to my rails all. You could use pg_search to get 90% of the value, with next to no complexity on the backend.
- necovek 6y agoNever tried it out (it's on my never-getting-done list), but someone has built it: https://github.com/zombodb/zombodb https://github.com/zombodb/zombodb