#Sql

Build a Text-to-SQL Agent with Schema-Aware Guardrails

Generate SQL from natural language with an LLM, then validate every query against an AST-based guardrail before it touches your database.

Tutorial · 1mo ago0

Why Your Next SQLite Table Should Be Strict

SQLite's flexible typing is a historical quirk, but strict tables bring modern type safety to your embedded database.

Article · 1mo ago6

Ray Tracing in SQL: Turing Completeness Meets Relational Abuse

What a path tracer written in pure SQL reveals about the modern analytical execution model and its limits.

Article · 1mo ago0

Enforce Multi-Tenant Data Isolation with Postgres Row-Level Security

Lock down tenant data at the database layer using RLS policies, so no application bug can accidentally leak rows across tenants.

Tutorial · 1mo ago0

Ditching ANTLR: How PostHog Rebuilt Its SQL Parser for a 70x Speedup

Replacing a parser generator with a hand-rolled recursive-descent parser using AI agents, differential testing, and compiler design.

Article · 1mo ago3

Instant SQL to ER Diagrams, Right in the Browser

Convert your DDL into interactive entity-relationship diagrams instantly with zero uploads, zero signups, and total privacy.

Article · 1mo ago2

PostgreSQL 19: Native Temporal Tables Are Finally Coming

Native application-time support in Postgres 19 eliminates complex exclusion constraints and simplifies historical data tracking.

Article · 2mos ago4