Simon Willison: TILs on sql

sql Consecutive groups in SQL using window functions - 2023-06-08

I have a database table with all of my Swarm checkins since 2011, created using my swarm-to-sqlite tool. …

sql Using recursive CTEs to explore hierarchical Twitter threads - 2023-01-30

This TIL adapted from a Gist I put together in 2019, before I started tracking TILs here. …

sql Cumulative total over time in SQL - 2021-09-13

This is a quick trick for creating a cumulative chart of the total number of items created over time based just on their creation date. …

sql Building a Markdown summary of Django group permissions - 2021-06-03

Django SQL Dashboard can display rendered markdown generated by a SQL query. …

sql Finding duplicate records by matching name and nearby distance - 2021-05-19

I wanted to find potentially duplicate records in my data, based on having the exact same name and being geographically located within 500 meters of each other. …