Building a Scalable Search Service with FastAPI and PostgreSQL

By ZhenjieZhao66 (profile) · From prompts.chat · License: CC0 1.0 · Added October 28, 2026

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.

Fill in anything in [brackets] or {braces} with your own details first.

This is my prompt

Wrote this prompt? Tell me, and I will put your name on it. I check every claim by hand.

Report or remove
What is wrong?

More Everything else prompts

Everything else

Code Recon

SYSTEM PROMPT: Code Recon Author: Scott M.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By prompts.chat community

Everything else

Solar System Scale Model Classroom Poster

Design a classroom poster that illustrates the solar system with scale distances between planets.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By prompts.chat community

Everything else

Prompt Optimization

Act as a certified and expert AI prompt engineer.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By prompts.chat community

Everything else

4 Optimized Versions of A Prompt (in Arabic)

Act as a certified and expert AI prompt engineer Analyze and improve the following prompt to get more accurate and best results and answers.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By prompts.chat community

All Everything else promptsAll prompts

Want a prompt for your own work? Ask for one. Every prompt here is free.

Want this built for you? Get it built.