Why You Should Choose Your DBMS's Full Text Search Over a Dedicated Search Engine
At Sophilabs, we are used to seeing the following architecture: relational DBMS for data storage, structured queries and manipulation, and a separate search engine for search. However, many DBMS support full text search. PostgreSQL, our favorite one, supports full text search since at least version 8.3, released in 2008.
If your project already uses a DBMS and you are uncertain whether to use a dedicated search engine, today we will share 3 reasons why you should not.
Simple is better than complex.
— The Zen of Python
Okay, so this is an easy one. Why work with two different systems when you can just work with one? We are probably talking about systems which understand different languages, have different dependencies, and will of course consume resources on their own. Each dependency you add to your project is a liability for your team. If you can keep it simple, please do!