I Went to SQL Injection Court
Chicago argued that answering a FOIA request with a database query means creating a new record. Matt Chapman sued, I wound up on the stand explaining SQL, and now there's a bill to fix it.
Thomas and Erin Ptacek on software, security, cryptography, hiring, and the occasional cocktail.
Visit sockpuppet.org → RSS feedOn Hacker News Jul 2013 – Sep 2026
Security & Privacy 7Software Engineering 7Systems & Performance 3Tools & Productivity 2Society, Policy & Culture 2Life, Learning & Writing 2
Chicago argued that answering a FOIA request with a database query means creating a new record. Matt Chapman sued, I wound up on the stand explaining SQL, and now there's a bill to fix it.
Two rules keep an LLM from pasteurizing your writing: never take a word it suggests, and never let it encourage you. Then hand it all the tedious work.
The developer job interview doesn't work: it measures a basket of skills uncorrelated with job performance. Work-sample tests, warm-ups, and how to grade your own hiring process.
Everything looks like Emacs now: personal, complicated, idiosyncratic, and shrink-wrapped around exactly what you want it to do. Does shipping software even make sense in the long run?
It's time to stop drawing user interfaces with punctuation characters. Native UI is a completely solved problem.
An Erin post. On finding, in app pentesting, the only game worth loving, and turning that into Starfighter: a company that hires people by letting them play it.
Computers now work the way I thought they did when I was 8. What does computing look like when most applications have an audience of 1-2 people? I'm leaving Fly.io to build a phone for that world.
Vulnerability discovery has always been gated by elite attention. Elite attention is now abundant. What happens next?
10 years later and still unrebutted: DNSSEC is pageantry, it's not security, which is why so few security teams deploy it.
Dual_EC was almost certainly an NSA backdoor. Extended Random is the TLS extension that would have made it practical to exploit. Did NSA plant that one too? A look at the evidence.
Applied Cryptography taught two generations of developers what they know about crypto, and it is a dreadful instruction manual. The book to replace it with, and what you still have to learn after.
Dewars, safety rules, barware, and drinks: how to throw a liquid nitrogen cocktail party, in the spirit of Dave Arnold's Liquid Intelligence, without anybody losing an eye.
XTS is the de-facto standard disk encryption mode, which makes it look like a good general-purpose one. It isn't. What disk encryption actually promises, and why XTS's guarantees don't travel.
Use urandom. That is the whole answer. Why the entropy-depletion story is a myth, and why userspace CSPRNGs are behind most of the last decade's randomness disasters.