Full-text search with Postgres

This week I built very basic search capabilities into Level.

In the past, I’ve used Elasticsearch. I had some hesitations:

⇨ Synchronizing data stores is a pain
⇨ It’s another piece of infrastructure to administrate
⇨ It makes it harder and more expensive for someone to download and run their own copy of Level (if they care about production-level reliability)

I decided to try out Postgres’ built-in text search features and found it to be a pleasant experience!

Here are a few resources that helped me:

The Official Manual - a well-written tutorial, worth a read through
Postgres full-text search is Good Enough!
Mastering PostgreSQL Tools: Full-Text Search and Phrase Search

 
26
Kudos
 
26
Kudos

Now read this

How to display server-rendered HTML in Elm 0.19

I’m building a team communication product called Level, and one of the core features is rendering posts as Markdown. Elm has a library to handle this on the client-side. It’s a wrapper around the marked.js library that uses Kernel code... Continue →