#PostgreSQL
5 related articles
DB Chat: Conversing with PostgreSQL in Natural Language, with AI Auto-Generating SQL
dbchat lets users converse with a PostgreSQL database in natural language, with an AI agent auto-generating SQL and returning live results. This article analyzes its MCP Server + Next.js + AWS full-stack architecture and anti-hallucination guardrail design.
Hybrid Search in PostgreSQL in Practice: BM25 + Vector Retrieval in One Go
A hands-on PostgreSQL hybrid search course: use pgTextSearch for BM25 ranking, pgVector for semantic retrieval, and RRF to merge results, covering matching vs ranking, index plans, negative-score sorting, and test comparisons.
Building Multilingual Full-Text Search with FastAPI and PostgreSQL
The LectuLibre team shares architecture lessons for multilingual full-text search on FastAPI + PostgreSQL: normalized translation tables, generated tsvector columns, GIN indexes, and pg_trgm fuzzy matching, cutting search latency from 800ms to 20-40ms.
Why PostgreSQL Is the Top Choice in the AI Era: A Complete Guide from Beginner to Advanced
PostgreSQL usage hit 55.6% in Stack Overflow's 2025 survey. Learn why it's the go-to data foundation for AI apps — covering vector search, graph queries, full-text search, and a structured learning path.
PlanetScale Launches Tin: A Full-Text Search Solution Built for Postgres
PlanetScale launches Tin, a full-text search tool built for PostgreSQL that aims to eliminate the need for separate search engines like Elasticsearch.