3 ms·
As 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_update
by karterk 6y ago
As 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.