Re:Show HN: Instantly search 28M books from OpenLibrary
by adenta on Monday December 14, 2020 @09:56AM
(#25418238)
I 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.
[ Parent
| on HN ]
Re:Show HN: Instantly search 28M books from OpenLibrary
by karterk on Monday December 14, 2020 @10:04AM
(#25418339)
I 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).
Re:Show HN: Instantly search 28M books from OpenLibrary
by adenta on Monday December 14, 2020 @11:10AM
(#25419149)
Ahh, 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.