DEV Community

Cover image for A powerful full-text search in PostgreSQL in less than 20 lines

A powerful full-text search in PostgreSQL in less than 20 lines

Leandro Proença on September 16, 2021

This blogpost will guide you to understand the fundamental pieces needed to implement a good enough full-text search using PostgreSQL. Spoiler al...
Collapse
 
eduardojm profile image
Eduardo Oliveira

This text is awesome

Collapse
 
leandrosilva profile image
Leandro Silva

You genius. 👏👏👏

Collapse
 
leandronsp profile image
Leandro Proença

Thanks but I'm not :P Just a random person doing random stuff hahaha

Have you already experimented on PG text search before?

Collapse
 
leandrosilva profile image
Leandro Silva

No, not yet.
Elastic only.
But I'll definitely try it.

Collapse
 
anthonycook profile image
Anthony Cook

I'm playing around with Apache Solr at the moment, even though it's much easier to learn/remember than Elasticsearch, I'm tempted to give this a try. 🤔

Collapse
 
leandronsp profile image
Leandro Proença

I used Solr in some projects. For me PostgreSQL is the perfect fit since I already use relational data in Postgres