โ† Back

Building a Scalable Search Service with FastAPI and PostgreSQL

Programming
๐Ÿ’ก How to use: Copy this prompt and paste it into ChatGPT, Claude, Gemini, or any AI assistant. You can modify the placeholder text to customize it for your needs.
ID: #1160
Category: Programming
Contributor: ZhenjieZhao66
Developer: No
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.
โœ“ Prompt copied to clipboard!