Simon Willison: TILs on sql

Atom feed for sql

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. …