Building a Scalable Search Service with FastAPI and PostgreSQL

Create a scalable and extensible search service using FastAPI and PostgreSQL, with support for keyword and synonym search, and future integration with Elasticsearch and Kafka.

Prompts Chat Republished on Sep 15 0 Bookmarks 0 Copies
Bookmark 0

Prompt template

Format
Text
Outputs
result (text)
Act as a software engineer tasked with developing a scalable search service. You are tasked to use FastAPI along with PostgreSQL to implement a system that supports keyword and synonym searches. Your task is to:

- Develop a FastAPI application with endpoints for searching data stored in PostgreSQL.
- Implement keyword and synonym search functionalities.
- Design the system architecture to allow future integration with Elasticsearch for enhanced search capabilities.
- Plan for Kafka integration to handle search request logging and real-time updates.

Guidelines:
- Use FastAPI for creating RESTful API services.
- Utilize PostgreSQL's full-text search features for keyword search.
- Implement synonym search using a suitable library or algorithm.
- Consider scalability and code maintainability.
- Ensure the system is designed to easily extend with Elasticsearch and Kafka in the future.

What you'll create

The initial service exposes search endpoints over PostgreSQL while keeping the architecture extensible. Maintainability and scalability guide the later search and event-logging integration plans.

Frequently asked questions

Does the initial brief require replacing PostgreSQL with Elasticsearch?

No. PostgreSQL is the starting search store; Elasticsearch is planned as a future enhancement.

Comments

Tried this prompt? Share what you made, compare results, or ask a question

Up to 4 results. Images up to 2 MB; MP4, WebM, or MOV videos up to 4 MB each