Archive for April 2022

April 2022

April 1, 2022

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.

1st Apr 2022, 5:48 am

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:

1st Apr 2022, 5:35 pm

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.

4th Apr 2022, 1:18 am

April 7, 2022

datasette-dashboards (via) Romain Clement’s datasette-dashboards plugin lets you configure dashboards for Datasette using YAML, combining markdown blocks, Vega graphs and single number metrics using a layout powered by CSS grids. This is a beautiful piece of software design, with a very compelling live demo.

# 6:36 pm / plugins, visualization, datasette

Release pypi-to-sqlite 0.1 — Load data about Python packages from PyPI into SQLite

7th Apr 2022, 11:43 pm

April 8, 2022

Release pypi-to-sqlite 0.2 — Load data about Python packages from PyPI into SQLite

8th Apr 2022, 2:48 pm

Release pypi-to-sqlite 0.2.2 — Load data about Python packages from PyPI into SQLite

8th Apr 2022, 3:12 pm

TIL Using awk to add a prefix — I wanted to dynamically run the following command against all files in a directory:

8th Apr 2022, 4:25 pm

Release shot-scraper 0.11 — A command-line utility for taking automated screenshots of websites

8th Apr 2022, 8:06 pm · shot-scraper

Pillar Point Stewards, pypi-to-sqlite, improvements to shot-scraper and appreciating datasette-dashboards

This week I helped Natalie launch the Pillar Point Stewards website and built a new tool for loading PyPI package data into SQLite, in order to help promote the excellent datasette-dashboards plugin by Romain Clement.

[... 1,985 words]

8:26 pm / continuous-deployment, continuous-integration, natalie-downe, plugins, projects, pypi, datasette, weeknotes, shot-scraper, ben-welsh

April 11, 2022

Release shot-scraper 0.12 — A command-line utility for taking automated screenshots of websites

11th Apr 2022, 7:32 pm · shot-scraper

April 12, 2022

Release geojson-to-sqlite 1.0.1 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

12th Apr 2022, 2:22 am

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.

12th Apr 2022, 6:58 pm

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

12th Apr 2022, 11:35 pm

April 13, 2022

Datasette for geospatial analysis (via) I added a new page to the Datasette website describing how Datasette can be used for geospatial analysis, pulling together several of the relevant plugins and tools from the Datasette ecosystem.

# 12:48 am / gis, plugins, datasette

Release summarize-template 0.1 — Show a summary of a Django or Jinja template

13th Apr 2022, 1:23 am

Litestream: Live Read Replication (via) The documentation for the read replication implemented in the latest Litestream beta (v0.4.0-beta.2). The design is really simple and clever: the primary runs a web server on a port, and replica instances can then be started with a configured URL pointing to the IP and port of the primary. That’s all it takes to have a SQLite database replicated to multiple hosts, each of which can then conduct read queries against their local copies.

# 2:04 am / replication, sqlite, litestream

Release geojson-to-sqlite 1.1 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

13th Apr 2022, 5 am

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

13th Apr 2022, 10:53 pm · sqlite, sqlite-utils

Release geojson-to-sqlite 1.1.1 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

13th Apr 2022, 11:39 pm

Release tweet-images 0.1.1 — Send tweets with images from the command line

17th Apr 2022, 10:24 pm

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.

17th Apr 2022, 11:03 pm

April 18, 2022

Building a Covid sewage Twitter bot (and other weeknotes)

I built a new Twitter bot today: @covidsewage. It tweets a daily screenshot of the latest Covid sewage monitoring data published by Santa Clara county.

[... 1,079 words]

2:49 am / projects, twitter, datasette, weeknotes, github-actions, covid19, sqlite-utils

Release tweet-images 0.1.2 — Send tweets with images from the command line

18th Apr 2022, 3:11 am

How to push tagged Docker releases to Google Artifact Registry with a GitHub Action. Ben Welsh’s writeup includes detailed step-by-step instructions for getting the mysterious “Workload Identity Federation” mechanism to work with GitHub Actions and Google Cloud. I’ve been dragging my heels on figuring this out for quite a while, so it’s great to see the steps described at this level of detail.

# 3:41 am / github, google, docker, ben-welsh

Release shot-scraper 0.13 — A command-line utility for taking automated screenshots of websites

18th Apr 2022, 6:29 pm · shot-scraper

Release asyncinject 0.4 — Run async workflows using pytest-fixtures-style dependency injection

18th Apr 2022, 10:47 pm

page 1 / 2 next »

Simon Willison’s Weblog