Implementing Full Text Search (FTS) in Postgres

Text search is a common feature many applications have. We usually use this feature on Instagram, Twitter, or any social media to find someone by their account username, first name, or last name. We use this feature to find an address in Google Maps, (Apple) Maps, Waze, or any Map Navigation

Implementing the Full Text Search (FTS) in Postgres is similar to using the LIKE operator, i.e., text query-document matching. In FTS, the text matching is conducted by the operator @@ given <doc_text> as the document and <query_text> as the query, e.g., <doc_text> @@ <query_text>.

Tech Stack

• Go
• Fiber
• PostgreSQL
• Pgx Pool
• Fiber Web Socket
• React JS
• Tailwind CSS

Screnshoots

How to Run?

➤ Clone this repo
➤ cd gosh

# setup postgres with dummy data (see: postgres/init.sql)
➤ docker-compose up -d

# install dependencies
➤ go mod tidy

# run backend
➤ go run main.go

# change to frontend
➤ cd gosh

# install dependencies
➤ yarn

# run frontend
➤ yarn dev

# open in browser (http://localhost:5173/)

References

Fast Text Search to Boost User Experience in Kampus Merdeka Platform