Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum

Filters: Sorted by date

TIL Rewriting a repo to contain the history of just specific files — I wanted to start [a new git repository](https://github.com/simonw/graphql-scraper/tree/828a1efc4307cca6cd378c394c2d33eac2eceb52) containing just the history of two specific files from my [help-scraper repository](https://github.com/simonw/help-scraper).
22nd Mar 2022, 11:11 pm
TIL Using the GitHub Actions cache with npx and no package.json — Some of my repositories have GitHub Actions workflows that execute commands using `npx`, for example my [graphql-scraper](https://github.com/simonw/graphql-scraper) repo using `npx` to [install and run](https://github.com/simonw/help-scraper/blob/54ef9b1fa579dc2d3f68055ffdac9996fd6dae9c/.github/workflows/scrape.yml#L76-L80) the `get-graphql-schema` tool:
22nd Mar 2022, 9:57 pm
TIL Counting SQLite virtual machine operations — When SQLite executes a query, it does so by executing a sequence of virtual machine operations.
21st Mar 2022, 4:45 am
TIL The simplest recursive CTE — I found this really simple recursive CTE useful for ensuring I understood how to write recursive CTEs.
21st Mar 2022, 4:32 am
Release datasette-publish-vercel 0.13 — Datasette plugin for publishing data using Vercel
20th Mar 2022, 2:01 am · datasette
Release datasette 0.61a0 — An open source multi-tool for exploring and publishing data
20th Mar 2022, 1:16 am · datasette
TIL Async fixtures with pytest-asyncio — I wanted to use a fixture with `pytest-asyncio` that was itsef as `async def` function, so that it could execute `await` statements.
19th Mar 2022, 10:48 pm
Release datasette-hashed-urls 0.2 — Optimize Datasette performance behind a caching proxy
16th Mar 2022, 4:35 am · datasette
Release datasette-publish-vercel 0.12.1 — Datasette plugin for publishing data using Vercel
15th Mar 2022, 11:10 pm · datasette
Release datasette-hashed-urls 0.1a0 — Optimize Datasette performance behind a caching proxy
15th Mar 2022, 10:46 pm · datasette
TIL Concatenating strings and newlines in Google Sheets — I was asked if there was a way to run [shot-scraper](https://github.com/simonw/shot-scraper) against a list of URLs in a Google Sheet.
15th Mar 2022, 5:11 pm
Release shot-scraper 0.9 — A command-line utility for taking automated screenshots of websites
14th Mar 2022, 12:05 am
Release shot-scraper 0.8 — A command-line utility for taking automated screenshots of websites
13th Mar 2022, 5:05 pm
Release shot-scraper 0.7 — A command-line utility for taking automated screenshots of websites
13th Mar 2022, 4:49 am
Release shot-scraper 0.6 — A command-line utility for taking automated screenshots of websites
12th Mar 2022, 9:30 pm
Release shot-scraper 0.5 — A command-line utility for taking automated screenshots of websites
12th Mar 2022, 7:17 pm
Release image-diff 0.2.1 — CLI tool for comparing images
11th Mar 2022, 11:54 pm
Release image-diff 0.2 — CLI tool for comparing images
11th Mar 2022, 11:42 pm
Release image-diff 0.1 — CLI tool for comparing images
11th Mar 2022, 10:19 pm
Release sqlite-utils 3.25.1 — Python CLI utility and library for manipulating SQLite databases
11th Mar 2022, 6:35 pm · sqlite, sqlite-utils
Release shot-scraper 0.4 — A command-line utility for taking automated screenshots of websites
10th Mar 2022, 10:33 pm
Release shot-scraper 0.3 — A command-line utility for taking automated screenshots of websites
9th Mar 2022, 10:24 pm
Release shot-scraper 0.2 — A command-line utility for taking automated screenshots of websites
9th Mar 2022, 9:05 pm
Release shot-scraper 0.1 — A command-line utility for taking automated screenshots of websites
9th Mar 2022, 7:16 pm
Release shot-scraper 0.1a0 — A command-line utility for taking automated screenshots of websites
8th Mar 2022, 11:10 pm
Release django-sql-dashboard 1.0.2 — Django app for building dashboards using raw SQL queries
8th Mar 2022, 8 pm
TIL pytest coverage with context — [This tweet](https://twitter.com/mariatta/status/1499863816489734146) from \@Mariatta tipped me off to the ability to measure "contexts" when [running coverage](https://coverage.readthedocs.io/en/6.3.2/contexts.html#context-reporting) - as a way to tell which tests exercise which specific lines of code.
5th Mar 2022, 12:53 am
TIL Natural Earth in SpatiaLite and Datasette — Natural Earth ([website](https://www.naturalearthdata.com/), [Wikipedia](https://en.wikipedia.org/wiki/Natural_Earth)) is a a public domain map dataset.
4th Mar 2022, 7:11 pm
Release geojson-to-sqlite 1.0 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
4th Mar 2022, 2:14 am
Release sqlite-utils 3.25 — Python CLI utility and library for manipulating SQLite databases
2nd Mar 2022, 6:35 am · sqlite, sqlite-utils

Beats

Years

Tags