Simon Willison’s Weblog

Subscribe

Monday, 21st March 2022

TIL The simplest recursive CTE — I found this really simple recursive CTE useful for ensuring I understood how to write recursive CTEs.
TIL Counting SQLite virtual machine operations — When SQLite executes a query, it does so by executing a sequence of virtual machine operations.