Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

TIL Working around the size limit for nodeValue in the DOM — TIL that `nodeValue` in the DOM has a size limit!
None
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.
None
TIL Finding the largest SQLite files on a Mac — This runs using Spotlight so it's really fast:
None
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.
None
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
TIL Read the Docs Search API — I stumbled across this API today: https://docs.datasette.io/_/api/v2/docsearch/?q=startup&project=datasette&version=stable&language=en
None
Release datasette-cluster-map 0.12 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette 0.48 — An open source multi-tool for exploring and publishing data
Release datasette-graphql 0.12.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-saved-queries 0.2.1 — Datasette plugin that lets users save and execute queries
Release datasette 0.47.3 — An open source multi-tool for exploring and publishing data
Release datasette-upload-csvs 0.5 — Datasette plugin for uploading CSV files and converting them to database tables
TIL Code coverage using pytest and codecov.io — I got my [asgi-csrf](https://github.com/simonw/asgi-csrf) Python package up to 100% code coverage. Here's [the pull request](https://github.com/simonw/asgi-csrf/issues/13).
None
Release asgi-csrf 0.7 — ASGI middleware for protecting against CSRF attacks
Release asgi-csrf 0.7a0 — ASGI middleware for protecting against CSRF attacks
TIL Pointing a custom subdomain at Read the Docs — I host the documentation for Datasette on [Read the Docs](https://readthedocs.org/). Until today it lived at https://datasette.readthedocs.io/ but today I moved it to a custom subdomain, https://docs.datasette.io/
None
Release datasette-cluster-map 0.11.1 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-cluster-map 0.11 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-graphql 0.12.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 0.12 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette 0.47.2 — An open source multi-tool for exploring and publishing data
TIL Customizing my zsh prompt — I got fed up of the default macOS `zsh` prompt:
None
Release sqlite-utils 2.15.1 — Python CLI utility and library for manipulating SQLite databases