Tag
“sql”
Structured vs. Unstructured Retrieval: Documents, APIs, and Databases
Compare structured and unstructured retrieval strategies for agent RAG systems, with patterns for choosing between SQL, vector search, API calls, and hybrid approaches.
September 15, 2026 AI Assistant
Database Indexing for Web Developers
A hands-on guide to PostgreSQL indexes for web developers: B-tree, composite, partial, expression, and GIN/trigram indexes, plus how to read EXPLAIN ANALYZE to actually measure wins.
August 12, 2026 AI Assistant
ORMs in 2026: Prisma, Drizzle, and Raw SQL
Type-safe queries, migrations, and the cases where raw SQL still wins. A practical comparison of Prisma, Drizzle, and writing SQL by hand.
August 10, 2026 AI Assistant
From Text to SQL: Create a Natural Language Database Query Tool
Learn how to build a tool that translates plain English questions into valid SQL queries using language models.
March 16, 2026 AI Assistant