Great and very insightful!
I did not know about fuzzystrmatch
Do you think NOSQL alternatives (ElastiSearch and MelliSearch) are always better than SQL ones(PostgreSQL) in terms of search?
I think PostgreSQL provides a lot of features that would typically need a normal application using NOSQL 2 or 3 different types of databases for the uses cases.