Tag archive
A tiny SQLite demo of the three-valued logic trap: one NULL in a NOT IN list can wipe every row. Fixes with IS NOT NULL, NOT EXISTS, and a LEFT JOIN.
If you run SQL scripts through sqlcmd - a deploy step, a data fix, a seed script, a pipeline that...
During the past few days I have learned a few basics on SQL and would like to share here. After the...
Most SQL courses warn you about joins. In our data, joins were not the hard part. The first lesson...
TL;DR. Your assistant gives a number, and you cannot tell if it is right. An eval is a repeatable...
SQL Operators Made Simple: Learn with Practical Examples Introduction SQL...
We'll walk through the operators you actually need as a beginner—comparison, logical, range and list,...
The standard answer to SQL injection is "use parameterized queries". It's good advice, and it doesn't...
Databricks NEAREST BY brings batch vector search into SQL with a fused Photon GEMM operator and IVF indexes in Delta tables. How it works, when to use it.
What 42501 means in Supabase, why new tables start throwing it after 30 October 2026, and the grant, RLS and policy that fix it. Reproduced on a local stack.
DuckDB reads Parquet on S3 in one line, and that part is not the problem. The problem shows up a...
A UUID is 16 bytes. In a surprising number of schemas, it occupies 144 bytes — and the index copy...