Elsewhere

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.

23rd Aug 2020, 3:23 am

TIL Creating a dynamic line chart with SVG — I helped build the tide chart visualizations for [Rocky Beaches](https://www.rockybeaches.com/).

22nd Aug 2020, 6:34 pm

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.

22nd Aug 2020, 5:42 am

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)).

22nd Aug 2020, 4:23 am · leaflet

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.

22nd Aug 2020, 4:19 am · leaflet

Release datasette-auth-passwords 0.3.2 — Datasette plugin for authentication using passwords

22nd Aug 2020, 4:08 am · datasette

Release shapefile-to-sqlite 0.3 — Load shapefiles into a SQLite (optionally SpatiaLite) database

22nd Aug 2020, 12:30 am

Release datasette-leaflet-geojson 0.6 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.

21st Aug 2020, 11:54 pm · datasette, leaflet

TIL Working around the size limit for nodeValue in the DOM — TIL that `nodeValue` in the DOM has a size limit!

21st Aug 2020, 11:13 pm

Release datasette-leaflet-geojson 0.5 — Datasette plugin that replaces any GeoJSON column values with a Leaflet map.

21st Aug 2020, 10:48 pm · datasette, leaflet

Release sqlite-utils 2.16 — Python CLI utility and library for manipulating SQLite databases

21st Aug 2020, 9:05 pm · sqlite, sqlite-utils

Release datasette-graphql 0.14 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

20th Aug 2020, 9:52 pm · datasette

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.

20th Aug 2020, 4:26 am

TIL Finding the largest SQLite files on a Mac — This runs using Spotlight so it's really fast:

19th Aug 2020, 3:11 pm

Release datasette-graphql 0.13 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

19th Aug 2020, 5:30 am · datasette

Release datasette-schema-versions 0.1 — Datasette plugin that shows the schema version of every attached database

19th Aug 2020, 4:05 am · datasette

Release datasette-graphql 0.12.3 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

19th Aug 2020, 12:16 am · datasette

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.

18th Aug 2020, 10:46 pm

Release github-to-sqlite 2.5 — Save data from GitHub to a SQLite database

18th Aug 2020, 3:08 pm

Release datasette-publish-vercel 0.8 — Datasette plugin for publishing data using Vercel

17th Aug 2020, 11:35 pm · datasette

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

16th Aug 2020, 9:08 pm

Release datasette-cluster-map 0.12 — Datasette plugin that shows a map for any data with latitude/longitude columns

16th Aug 2020, 7:46 pm · datasette

Release datasette 0.48 — An open source multi-tool for exploring and publishing data

16th Aug 2020, 6:58 pm · datasette

Release datasette-graphql 0.12.2 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

16th Aug 2020, 4 pm · datasette

Release datasette-saved-queries 0.2.1 — Datasette plugin that lets users save and execute queries

15th Aug 2020, 11:38 pm · datasette

Release datasette 0.47.3 — An open source multi-tool for exploring and publishing data

15th Aug 2020, 9:03 pm · datasette

Release datasette-upload-csvs 0.5 — Datasette plugin for uploading CSV files and converting them to database tables

15th Aug 2020, 7:27 pm · datasette

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).

15th Aug 2020, 6:20 pm

Release asgi-csrf 0.7 — ASGI middleware for protecting against CSRF attacks

15th Aug 2020, 6:04 pm

Release asgi-csrf 0.7a0 — ASGI middleware for protecting against CSRF attacks

15th Aug 2020, 2:37 am

Simon Willison’s Weblog

Elsewhere

Beats

Years

Tags