Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release django-sql-dashboard 1.1 — Django app for building dashboards using raw SQL queries
Release asyncinject 0.4 — Run async workflows using pytest-fixtures-style dependency injection
Release shot-scraper 0.13 — A command-line utility for taking automated screenshots of websites
Release tweet-images 0.1.2 — Send tweets with images from the command line
TIL How to get credentials for a new Twitter bot — I wanted to build a Twitter bot that would tweet Covid sewage graphs from [this page](https://covid19.sccgov.org/dashboard-wastewater) every day.
None
Release tweet-images 0.1.1 — Send tweets with images from the command line
Release tweet-images 0.1 — Send tweets with images from the command line
Release asyncinject 0.3 — Run async workflows using pytest-fixtures-style dependency injection
Museum Moffett Field Historical Society — Building 126, Severyns Ave, Moffett Field, CA 94035
A diorama showing the scale of the USS Macon airship
Release geojson-to-sqlite 1.1.1 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
Release sqlite-utils 3.26 — Python CLI utility and library for manipulating SQLite databases
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).
None
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.
None
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:
None
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.
None
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:
None
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.
None
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)):
None
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.
None
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.
None
Release datasette-auth0 0.1 — Datasette plugin that authenticates users using Auth0