Simon Willison’s Weblog

14th December 2022

TIL Comparing database rows before and after with SQLite JSON functions — Here's a trick I've been using to compare the rows in a table before and after I perform an operation against it. It works well for a few hundred (and maybe a few thousand) rows.

None

Posted 14th December 2022 at 11:47 pm

Recent articles

Is Claude Code going to cost $100/month? Probably not - it's all very confusing - 22nd April 2026
Where's the raccoon with the ham radio? (ChatGPT Images 2.0) - 21st April 2026
Changes in the system prompt between Claude Opus 4.6 and 4.7 - 18th April 2026

This is a beat by Simon Willison, posted on 14th December 2022.

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe