Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release geojson-to-sqlite 1.1 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
Release summarize-template 0.1 — Show a summary of a Django or Jinja template
TIL Trick Apple Photos into letting you access your video files — I had an 11GB movie in Apple Photos (sync'd from my iPhone) and I wanted to upload it to YouTube (actually via AirDrop to another laptop first).
TIL GUnion to combine geometries in SpatiaLite — I was playing around with [datanews/amtrak-geojson](https://github.com/datanews/amtrak-geojson), which provides GeoJSON for Amtrak stations and track segments.
Release geojson-to-sqlite 1.0.1 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
Release shot-scraper 0.12 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.11 — A command-line utility for taking automated screenshots of websites
TIL Using awk to add a prefix — I wanted to dynamically run the following command against all files in a directory:
Release pypi-to-sqlite 0.2.2 — Load data about Python packages from PyPI into SQLite
Release pypi-to-sqlite 0.2 — Load data about Python packages from PyPI into SQLite
Release pypi-to-sqlite 0.1 — Load data about Python packages from PyPI into SQLite
TIL Logging users out of Auth0 — If you [implement Auth0](https://til.simonwillison.net/auth0/oauth-with-auth0) for login, you may be tempted to skip implementing logout. I started out just with a `/logout/` page that cleared my own site's cookies, ignoring the Auth0 side of it.
TIL Treating warnings as errors in pytest — I was seeing this warning in a Django project when I thought I was correctly using timezone-aware dates everywhere:
TIL Allowing a container in Docker Desktop for Mac to talk to a PostgreSQL server on the host machine — I like using [Postgres.app](https://postgresapp.com/) to run PostgreSQL on my macOS laptop. I use it for a bunch of different projects.
TIL Generating a calendar week grid with the Python Calendar module — I needed to generate a grid calendar that looks like this (design [by Natalie Downe](https://github.com/natbat/pillarpointstewards/issues/23)):
Release shot-scraper 0.10 — A command-line utility for taking automated screenshots of websites
TIL Compiling to WASM with llvm on macOS — [howto-wasm-minimal](https://github.com/ern0/howto-wasm-minimal) by Zalka Ernő ([my fork here](https://github.com/simonw/howto-wasm-minimal)) is a neat demo of a minimal WASM module. It uses C++ to define functions for simple image manipulation including blurring an image, compiles it to WASM using llvm/clang++, then uses JavaScript to run those functions against an image loaded into a `<canvas>` element.
TIL Deploying a live Datasette demo when the tests pass — I've implemented this pattern a bunch of times now - here's the version I've settled on for my [datasette-auth0 plugin](https://github.com/simonw/datasette-auth0) repository.
Release datasette-auth0 0.1 — Datasette plugin that authenticates users using Auth0
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.
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".
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.
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

Beats

Years

Tags