» Tag
sql
42 postsA CRM That Changes Its Schema via Typed Tools, Not LLM-Written SQL
A Show HN CRM lets users edit database schemas via chat using typed tools instead of LLM-generated SQL, with dual validation and safe undo.
PostgreSQL 19 Preview: Property Graph Queries and Temporal Updates
PostgreSQL 19 beta introduces SQL/PGQ graph queries, temporal FOR PORTION OF updates, and ON CONFLICT DO SELECT, shown through runnable examples.
Provensql Proves SQL Query Equivalence Instead of Guessing
Provensql is an open-source SQL equivalence checker using SMT proofs that never returns a false positive, unlike LLM-based query judges.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comPostgreSQL Row-Level Security: Where the Performance Cost Hides
Benchmarks show PostgreSQL row-level security is free with proper indexing, but unstable helper functions and membership checks can add seconds of latency.
A Deterministic Guard Stops LLM Agents From SQL Overfetching
An open-source, LLM-free guard checks agent-generated SQL against user roles before execution, preventing text-to-SQL systems from overfetching sensitive data.
DOOMQL: A Doom-like FPS Where SQL Renders Every Pixel
DOOMQL is a terminal-based Doom-like FPS where SQL queries handle all game logic and pixel rendering, with a live SQL audit tool included.
William Kent's Classic Guide to the Five Normal Forms (1982)
Revisit William Kent's 1982 classic on database normalization — a clear, example-driven explanation of the five normal forms every engineer should know.
Text-to-SQL Fails Because of Your Warehouse, Not the Model
Text-to-SQL accuracy collapses on real enterprise warehouses despite strong benchmark scores. Evidence points to undocumented schemas, not model quality, as the cause.
Querying Historical Data in Postgres with the SCD Type 4 Pattern
A practical Postgres pattern using a history table, triggers, and valid_from/valid_to columns to answer point-in-time queries about record state in a single SELECT.
Mnemiq: Open-Source Text-to-SQL Tuned for Your Database
Mnemiq is an open-source text-to-SQL engine that answers natural language queries tailored to your database.