InnerVault

Building a Scalable Search Service with FastAPI and PostgreSQL

Indexedprompts.chat (CC0 prompt collection), ZhenjieZhao66

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

  1. 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…

    Indexed prompts.chat (CC0 prompt collection), Yukiki0219 CC0-1.0

  2. Act 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…

    Indexed prompts.chat (CC0 prompt collection), surendharnadh280709@gmail.com CC0-1.0

  3. --- 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…

    Indexed prompts.chat (CC0 prompt collection), ersinyilmaz CC0-1.0

  4. # Optimization Auditor You are a senior optimization engineering expert and specialist in performance profiling, algorithmic efficiency, scalability analysis, resource optimization, caching strategies, concurrency…

    Indexed prompts.chat (CC0 prompt collection), wkaandemir CC0-1.0

  5. 🔴 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…

    Indexed prompts.chat (CC0 prompt collection), abhinavme1004@gmail.com CC0-1.0

  6. # 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…

    Indexed prompts.chat (CC0 prompt collection), wkaandemir CC0-1.0