Re:SQL is 43 years old – Here’s why we still use it today
by prashnts on Tuesday May 02, 2017 @10:17AM
(#14246491)
We used to use Postgres for almost everything, including full-text search.
Later when we needed a bit more control over search, we started using Elasticsearch. The way we do it now is to perform joins and get a nice serialized object with all the possible search/filter/sort fields, and put it in ES. All the data still remains in postgres, though.
Later when we needed a bit more control over search, we started using Elasticsearch. The way we do it now is to perform joins and get a nice serialized object with all the possible search/filter/sort fields, and put it in ES. All the data still remains in postgres, though.