Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release asgi-csrf 0.7.1 — ASGI middleware for protecting against CSRF attacks
TIL Piping echo to a file owned by root using sudo and tee — I wanted to create a file with a shell one-liner where the file lived somewhere owned by root.
Release datasette-graphql 1.0.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.0 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.15 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-render-images 0.3.2 — Datasette plugin that renders binary blob images using data-uris
Release datasette-atom 0.7 — Datasette plugin that adds a .atom output format
Release shapefile-to-sqlite 0.4.1 — Load shapefiles into a SQLite (optionally SpatiaLite) database
TIL Rendering Markdown with the GitHub Markdown API — I wanted to convert the Markdown used in my TILs to HTML, using the exact same configuration as GitHub does. GitHub has a whole load of custom extensions for things like tables and syntax highlighting (see [issue 17](https://github.com/simonw/til/issues/17)).
Release shapefile-to-sqlite 0.4 — Load shapefiles into a SQLite (optionally SpatiaLite) database
TIL Skipping a GitHub Actions step without failing — I wanted to have a GitHub Action step run that might fail, but if it failed the rest of the steps should still execute and the overall run should be treated as a success.
TIL Creating a dynamic line chart with SVG — I helped build the tide chart visualizations for [Rocky Beaches](https://www.rockybeaches.com/).
TIL Providing a "subscribe in Google Calendar" link for an ics feed — If you provide your own custom generated ICS file hosted at a URL it's nice to be able to give Google Calendar users an easy way to subscribe to that feed.
TIL Dynamically loading multiple assets with a callback — For [datasette-leaflet-geojson](https://github.com/simonw/datasette-leaflet-geojson) I wanted to dynamically load some external CSS and JavaScript and then execute some code once they had loaded ([issue 14](https://github.com/simonw/datasette-leaflet-geojson/issues/14)).
TIL Outputting JSON with reduced floating point precision — [datasette-leaflet-geojson](github.com/simonw/datasette-leaflet-geojson) outputs GeoJSON geometries in HTML pages in a way that can be picked up by JavaScript and used to plot a Leaflet map.
Release datasette-auth-passwords 0.3.2 — Datasette plugin for authentication using passwords
Release shapefile-to-sqlite 0.3 — Load shapefiles into a SQLite (optionally SpatiaLite) database
Release datasette-leaflet-geojson 0.6 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.
TIL Working around the size limit for nodeValue in the DOM — TIL that `nodeValue` in the DOM has a size limit!
Release datasette-leaflet-geojson 0.5 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.
Release sqlite-utils 2.16 — Python CLI utility and library for manipulating SQLite databases
Release datasette-graphql 0.14 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
TIL Using grep to write tests in CI — GitHub Actions workflows fail if any of the steps executes something that returns a non-zero exit code.
TIL Finding the largest SQLite files on a Mac — This runs using Spotlight so it's really fast:
Release datasette-graphql 0.13 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-schema-versions 0.1 — Datasette plugin that shows the schema version of every attached database
Release datasette-graphql 0.12.3 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
TIL Programatically accessing Heroku PostgreSQL from GitHub Actions — My [db-to-sqlite](https://github.com/simonw/db-to-sqlite) tool can connect to a PostgreSQL database, export all of the content and write it to a SQLite database file on disk.
Release github-to-sqlite 2.5 — Save data from GitHub to a SQLite database
Release datasette-publish-vercel 0.8 — Datasette plugin for publishing data using Vercel

Beats

Years

Tags