AeroTools
Home AI Prompts Building a Scalable Search Ser...

Building a Scalable Search Service with FastAPI and PostgreSQL

chatgpt • development • 13 uses
Free
What is this prompt for?

Turns a coding request into a specification the model can actually work from, rather than a general description that comes back not compiling.

What it actually does: Act as a software engineer tasked with developing a scalable search service.

Main use cases:
  • Refactoring legacy code and improving its performance
  • Writing automated tests that cover the edge cases
  • Reviewing pull requests with practical suggestions
Benefits and results:
  • Clearer documentation, so the project stays maintainable
  • Faster development and higher output
  • Code that follows current security practice
Prompt length: 133 words Reading time: ~1 min Best with: Claude Sonnet (recommended for code), GPT-4o, GitHub Copilot

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.

Related Prompts

AeroTools

AeroAssistant

Online AI
Hello! I am your official AeroTools AI Assistant. How can I help you use our tools today?