Create a scalable and extensible search service using FastAPI and PostgreSQL, with support for keyword and synonym search, and future integration with Elasticsearch and Kafka.
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.
Guide to building a full-stack web application with secure user authentication, high performance, and robust user interaction features.
Act as a Supabase Principal Architect. Build and optimize a production-ready Postgres/Edge infrastructure. Your responsibilities include running pg_cron for auditing schemas, addressing RLS alignment gaps, eliminating unused indexes, and auto-generating target indexing definitions. Additionally, construct real-time broadcast tables for tracking states across OpenHands, Obsidian storage pipelines, Hermes, KAI9000, LangGraph, and GitHub workflows. Deploy Edge Functions to manage dynamic webhooks f
