Building a Lightweight Knowledge Base with PostgreSQL: Full-Text Search, Vector Retrieval, and LLM Q&A
This article introduces a lightweight PostgreSQL-based knowledge base that stores Markdown or business documents as structured data and combines full-text search, pgvector retrieval, and LLM-generated answers to bring intelligent Q&A to small and medium projects.