Jul 16 2023 Querying a power outage database

I have been tracking power outage data using a technique I learned about from Simon Willison called git-scraping. The outages are broken down by city, a stylized version of the data looks like:

1pm     seattle: 300
          2pm     seattle: 200    tacoma: 150
          3pm                     tacoma: 140     # implied seattle = 0 …

Jan 21 2023 video-to-sqlite

Inspired by Simon Willison's collection of sqlite tools, I created a library for extracting information from a video, and storing it in an sqlite database. It's called video-to-sqlite. You can also install it via pip install video-to-sqlite.

You can use Simon's very nifty tool Datasette to explore the resulting DB …

Aug 30 2022 Summing an array in SQLite

Summing the values in an array in SQLite