What is the best way to implement a search engine?

Question

JavaScript

There are 250,000 objects in the database and a page that should display everything, and you also need to implement a search for these objects. There are thousands of ways, but I would like an effective one, so as not to heavily load the database, it is possible to cache, etc. please advise something!

Answer 1

If only this
- Postgres + GiN/GiST index on the name field gin_trgm_ops (gist_trgm_ops). It is created like this:
Difference gin/gist in a nutshell:
gin is faster to search, but longer to create, gist is the other way around.
If something more (not just one field, ranking) - Full Text Search. Here the choice is yours. Sphinx, ElasticSearch, Postgres, MongoDB.

Answer 2

I am for sphinx, but for 250,000 you can get off with Postgres