Turkish Movie Search Engine using PostgreSQL 🔎

Full Text Search
Trigrams

This is PostgreSQL version of Turkish Movie Search Engine. Code contains a template for using FastAPI backend with PostgreSQL for text search. There are two search methods:

1. Full Text Search using TS Vectors (/fts endpoint)
2. Full Text Search using Trigrams (/trgm endpoint)

Data source: Turkish Movie Sentiment Analysis Dataset

• I just selected unique movie names.

Installation

There are only two prerequisites:

• Docker
• Docker-compose

git clone https://github.com/silverstone1903/autocomplete-search-fastapi-postgresql-fts.git

Usage

Start

docker-compose up -d

If you make any changes you can add --build.

docker-compose up --build -d

Stopping containers

docker-compose down

Container Logs

When running containers with detached mode (-d) they work in the background thus you can't see the flowing logs. If you want to check compose logs with cli you can use logs.

docker-compose logs --tail 50

• FastAPI (UI): http://localhost:8000

Tests

If you want to run the tests inside the container;

docker-compose exec web pytest tests -sv

Test results 👇🏻

Resources Tests

• How to use fuzzy string matching with Postgresql
• Postgres Full-Text Search: A Search Engine in a Database