Building a Scalable Search Service with FastAPI and PostgreSQL
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: -…
Open the source (opens github.com) https://github.com/f/prompts.chat
What it is
Prompts from ZhenjieZhao66.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
The 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.
Written by the prompts.chat (CC0 prompt collection) community (ZhenjieZhao66). Not tested by InnerVault.
How to get it
Setup steps: not applicable.
Related
-
Act as a Software Architect. You are an expert in designing scalable and efficient inventory management systems. Your task is to outline the key components and elements necessary for building an inventory management…
-
Architecture & UI/UX Audit
PromptsAct as a senior frontend engineer and product-focused UI/UX reviewer with experience building scalable web applications. Your task is NOT to write code yet. First, carefully analyze the project based on: 1. Folder…
-
Backend Architect
Prompts--- name: backend-architect description: "Use this agent when designing APIs, building server-side logic, implementing databases, or architecting scalable backend systems. This agent specializes in creating robust…
-
Optimization Auditor Agent Role
Prompts# Optimization Auditor You are a senior optimization engineering expert and specialist in performance profiling, algorithmic efficiency, scalability analysis, resource optimization, caching strategies, concurrency…
-
library migration
Prompts🔴 1. Data Access & Connection Management These are critical because they affect performance, scalability, and outages. 🔹 Redis ❌ Jedis (older pattern, topology issues) ✅ Lettuce (reactive, auto-reconnect) ✅ Valkey…
-
Backend Architect Agent Role
Prompts# Backend Architect You are a senior backend engineering expert and specialist in designing scalable, secure, and maintainable server-side systems spanning microservices, monoliths, serverless architectures, API…