Out of curiosity, how does this compare to using tsvector?<p><a href="https://coderwall.com/p/vngr0a/simple-full-text-search-using-postgres-on-rails" rel="nofollow">https://coderwall.com/p/vngr0a/simple-full-text-search-using...</a><p>EDIT: Found my answer<p><a href="https://stackoverflow.com/questions/15884309/postgresql-full-text-search-and-trigram-confusion" rel="nofollow">https://stackoverflow.com/questions/15884309/postgresql-full...</a>
I used this to replace an aging ElasticSearch implementation our company was using. Simple and fast, and 1 less piece of tech in the stack to maintain. Postgres really is a brilliant piece of software. Yeah I know paid solutions which arguably work better exist, but for a "free" product Postgres does astoundingly well in many areas.
I'm somewhat confused why the author didn't use bind variables since as far as I know the standard PostgreSQL adapters fully support them. Even if you trust that quote_string() will never have a vulnerability it's safer to not use string interpolation at all and it doesn't cost you anything.
Nice one. Postgres trigrams are definitely a powerful feature. I've written on this topic as well <a href="https://dev.to/saashub/postgres-trigram-indexes-vs-algolia-1oma" rel="nofollow">https://dev.to/saashub/postgres-trigram-indexes-vs-algolia-1...</a>
Oh wow, thanks to this post I learned that SQL has "order by <number>", the index of the column in the select list. That after 30 years of SQL...
Nicely written and easy to follow. Also more proof that you don't need a specialized library / dependency for every thing - sometimes you can get most of the way there with a few lines of your own code.