>_ BuildaPrompt
TEXT en

Building a Scalable Search Service with FastAPI and PostgreSQL

Building a Scalable Search Service with FastAPI and PostgreSQL — a ready-to-use text prompt for Development & Code. Copy it and paste into ChatGPT, Claude, or your preferred AI assistant.

How to use it

  1. Copy the prompt as-is.
  2. Paste it into ChatGPT, Claude, or your preferred AI assistant.

Pairs well with Ethereum Developer — try running them back to back.

Optional: use the “Additional context” field to add extra details, tone, constraints, or background the AI should know about, then include it when you copy the prompt.

Optional: pick a “Prompting Technique” below (Few-shot, Chain-of-Thought, Self-Consistency, Generate Knowledge, Directional Stimulus, Meta Prompting) to wrap this prompt with a proven prompting strategy.

The base prompt

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.

Want it filled in and enhanced? Use the builder →

Related prompts