Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

TIL Simplest possible OAuth authentication with Auth0 — [Auth0](https://auth0.com/) provides an authentication API which you can use to avoid having to deal with user accounts in your own web application.
None
Release datasette-auth0 0.1a0 — Datasette plugin that authenticates users using Auth0
Release datasette-packages 0.1.1 — Show a list of currently installed Python packages
Release datasette-packages 0.1 — Show a list of currently installed Python packages
Release datasette-hashed-urls 0.4 — Optimize Datasette performance behind a caching proxy
TIL Extracting web page content using Readability.js and shot-scraper — [Readability.js](https://github.com/mozilla/readability) is "A standalone version of the readability library used for Firefox Reader View".
None
Release datasette-hashed-urls 0.3.1 — Optimize Datasette performance behind a caching proxy
TIL Exporting and editing a Twitter Spaces recording — I hosted [a Twitter Spaces conversation](https://twitter.com/simonw/status/1504604448202518529) the other day. The recording is only available for 30 days afterwards, and I wanted to publish it elsewhere.
None
Release datasette-hashed-urls 0.3 — Optimize Datasette performance behind a caching proxy
Release datasette 0.61.1 — An open source multi-tool for exploring and publishing data
Release datasette 0.61 — An open source multi-tool for exploring and publishing data
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).
None
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:
None
TIL Counting SQLite virtual machine operations — When SQLite executes a query, it does so by executing a sequence of virtual machine operations.
None
TIL The simplest recursive CTE — I found this really simple recursive CTE useful for ensuring I understood how to write recursive CTEs.
None
Release datasette-publish-vercel 0.13 — Datasette plugin for publishing data using Vercel
Release datasette 0.61a0 — An open source multi-tool for exploring and publishing data
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.
None
Release datasette-hashed-urls 0.2 — Optimize Datasette performance behind a caching proxy
Release datasette-publish-vercel 0.12.1 — Datasette plugin for publishing data using Vercel
Release datasette-hashed-urls 0.1a0 — Optimize Datasette performance behind a caching proxy
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.
None
Release shot-scraper 0.9 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.8 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.7 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.6 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.5 — A command-line utility for taking automated screenshots of websites
Release image-diff 0.2.1 — CLI tool for comparing images
Release image-diff 0.2 — CLI tool for comparing images
Release image-diff 0.1 — CLI tool for comparing images