Are there any good options to support logic (and/or) and facets/fields with Postgres? We started using ES basically just for the "free" query language. (Obviously we would want something that is safe from sql injection.)
Re:PostgreSQL 9.6 Released
by anewhnaccount on Thursday September 29, 2016 @07:57PM
(#12609711)
SQL supports logic. Either escape manually, use the templating in your driver or use an ORM.
So, "No".
Re:PostgreSQL 9.6 Released
by eyelidlessness on Sunday October 02, 2016 @10:31AM
(#12622478)
I'm confused. Seems the answer is "yes"?
What about when having different PG database instances that has data you want to join on? Would you still use PG as an aggregated read-only copy of the databases or would you use for example ES?
Re:PostgreSQL 9.6 Released
by brightball on Wednesday October 05, 2016 @10:24AM
(#12644044)
It's situational. When you need a search across multiple data sources, standing up a dedicated search engine makes a lot more sense. Then again...PG Foreign Data wrappers would make that scenario pretty simple without the need for an aggregate.
I can't speak to performance in that situation though.
IMO, the only time to reach for an outside system is when the data isn't being written to PG first (like log ingestion with elastic search) or when search is such a central part of your app that it mandates a separate dedicated system.