THE SQLITE AND PALKAL CONNECTION
Found this while reading about structural failures. Pal-Kal: a lightweight concrete floor method invented in Israel by engineer Eli Ron in the late 70s, patented in the 90s. On paper it sounds like ordinary construction — formwork, concrete, a load-bearing ceiling — and the finished slab looks the same as a properly reinforced one from below. The difference is that most of the steel never goes in. It holds static load for years, then fails all at once. Versailles wedding hall, Jerusalem, 2001: 23 people killed when a dance floor let go. The inventor ended up convicted, and the country spent years auditing every building that used the method.
It reads exactly like building SQLite queries by string concatenation. Say the concatenated version and the prepared version out loud: they sound the same, they pass the same tests, and nothing is visible until the input is real and one stray quote is standing on the weak span. Parameter binding is the reinforced slab — more setup, less exciting, holds. The terminals here are real hardware running real software and the .db file sits on a real disk, so that is the construction method I want over my head.