News for hackers. Stuff that matters.
Re:Postgres Full-Text Search: A search engine in a database by SOLAR_FIELDS on Tuesday July 27, 2021 @07:29PM (#27978827)
Nice insightful comment. Can you give a bit additional insight related to when it makes sense to use ES vs Postgres? My takeaway from your comment is that unless your product depends on search as a central component that inbuilt search is good enough. Is that an incorrect takeaway?
Re:Postgres Full-Text Search: A search engine in a database by nostrademons on Tuesday July 27, 2021 @07:41PM (#27978905)
That's probably a decent takeaway. If full-text search is a "nice to have" (a bonus feature for advanced users, for example) you can probably rely on built-in Postgres search. If search is a fundamental way that users interact with your product, you want to spend the time and money to get it right, and that probably means ElasticSearch and a custom ranking function.