PostgreSQL FullText Search 🐘

Repo for study and testing postgreSQL fulltext search

Demo

The tests was make with 16000 users on database

Prerequisites

• docker
• docker-compose
• node
• npm

Execute server

After clone repository

cd server
npm install #Install dependencies
cd .docker/
docker-compose up #Up postgreSQL instance
cd .. 
npm run run-seed #Register 2000 users on database
npm run start #Start server

Execute front-end app

After clone repository

cd web
npm install #Install dependencies
npm run start #Run app

References

https://www.compose.com/articles/mastering-postgresql-tools-full-text-search-and-phrase-search/
https://austingwalters.com/fast-full-text-search-in-postgresql/

Author

👤 Jeferson Vinícius

• Website: https://www.linkedin.com/in/jefersonvinicius/