sqlite-utils 40rc2 mostly written by Claude Fable for about 14925

Happy 250th I’m at the New Jersey shore with family and friends, where we’ve spent this Fourth of July eating hot dogs, playing miniature golf, and wading into the ocean that my great-grandparents crossed to escape calamities they knew about and much greater calamities that they didn’t. Tonight we’ll see the fireworks,

An American privacy emergency Guest post from Cynthia Dwork et al Scott’s foreword: Cynthia Dwork is Gordon McKay Professor of Computer Science at Harvard, and a pioneer in the fields of differential privacy and algorithmic fairness. On my recent travels to the SigmaWest science camp and then STOC, there was much talk about a recent Trump administration action that would ban

Summary of reading April - June 2026

Have your agent record video demos of its work with shot-scraper video

Spreading the Gospel of Theoretical Computer Science to an Omega1 Fraction of Humanity My Trevisan Award Acceptance Speech at STOC Spreading the Gospel of Theoretical Computer Science to an Ω(1) Fraction of Humanity (Or, How We Can Do Like the Physicists)Scott Aaronson’s Trevisan Award Acceptance SpeechSalt Lake City, Utah, June 23, 2026 Thank you so much! It’s one of the highlights of my life, frankly, to accept the first-ever Luca ...

50 Years of Aumanns Agreement Theorem One of the most popular posts in this blog’s history was Common Knowledge and Aumann’s Agreement Theorem, based on a lecture that I gave to high-school students 11 years ago. One of the impacts of that post, I’m proud to say, is that (according to Steven Pinker) it helped to

Quickly apply LUTs color grading with ffmpeg This is a quick post, mostly for my own reference. I’ve avoided LUTs and ‘Log’ video footage for years1, mostly because of the extra tiny bit of workflow involved. Like RAW photos, ‘Log’ footage retains the video sensor’s full dynamic range, so you can pull more color and luminance information out

Finishing Some of the best advice I ever received came years ago from a coworker named Joe. Joe always had a few side-projects going on—weird and wonderful mashups of electronics, software, and fabrication of just about every kind: welding, woodwork, 3D printing, you name it. His projects were the kinds of things

Frameworks 10G Ethernet module exposes USB-Cs complexity I’ve been following WisdPi’s development of various 5 Gbps and 10 Gbps Ethernet adapters for the past couple years. They use newer Realtek Ethernet chips, which sometimes have performance quirks—most frequently encountered under Linux. In today’s video, I tested the new WisdPi 10G Ethernet Expansion Card for Framework computers. It fits in