Simon Willison: TIL

Things I've learned, collected in simonw/til.

Atom feed

Recently added: Decorators with optional arguments, Writing JavaScript that responds to media queries, Explicit file encodings using click.File, Upgrading Python Homebrew packages using pip, Searching for repositories by topic using the GitHub GraphQL API

python

• Decorators with optional arguments - 2020-10-28
• Explicit file encodings using click.File - 2020-10-16
• Understanding option names in Click - 2020-09-22
• Debugging a Click application using pdb - 2020-09-03
• Outputting JSON with reduced floating point precision - 2020-08-21
• How to call pip programatically from Python - 2020-08-11
• Password hashing in Python with pbkdf2 - 2020-07-13
• Introspecting Python function parameters - 2020-05-27
• Build the official Python documentation locally - 2020-05-08
• Use setup.py to install platform-specific dependencies - 2020-05-05
• Installing and upgrading Datasette plugins with pipx - 2020-05-04
• Generated a summary of nested JSON data - 2020-04-28
• macOS Catalina sort-of includes Python 3 - 2020-04-21
• Convert a datetime object to UTC without using pytz - 2020-04-19

javascript

• Writing JavaScript that responds to media queries - 2020-10-21
• Manipulating query strings with URLSearchParams - 2020-10-04
• Minifying JavaScript with npx uglify-js - 2020-08-30
• Dynamically loading multiple assets with a callback - 2020-08-21
• Working around the size limit for nodeValue in the DOM - 2020-08-21
• Implementing a "copy to clipboard" button - 2020-07-23

homebrew

• Upgrading Python Homebrew packages using pip - 2020-10-14
• Browsing your local git checkout of homebrew-core - 2020-08-27
• Packaging a Python CLI tool for Homebrew - 2020-08-11

github

• Searching for repositories by topic using the GitHub GraphQL API - 2020-10-09
• Paginating through the GitHub GraphQL API with Python - 2020-07-09
• Accessing repository dependencies in the GitHub GraphQL API - 2020-04-30

digitalocean

• Running Datasette on DigitalOcean App Platform - 2020-10-06

selenium

• Using async/await in JavaScript in Selenium - 2020-10-02
• Installing Selenium for Python on macOS with ChromeDriver - 2020-10-02

bash

• Escaping strings in Bash using !:q - 2020-10-01
• Looping over comma-separated values in Bash - 2020-09-01

sqlite

• Figuring out if a text value in SQLite is a valid integer or float - 2020-09-27
• Compiling the SQLite spellfix.c module on macOS - 2020-09-19
• Enabling WAL mode for SQLite database files - 2020-08-09
• SQLite BLOB literals - 2020-07-29
• Using LD_PRELOAD to run any version of SQLite with Python - 2020-06-17
• List all columns in a SQLite database - 2020-05-06
• Compile a new sqlite3 binary on Ubuntu - 2020-04-30
• Null case comparisons in SQLite - 2020-04-21
• Lag window function in SQLite - 2020-04-19

jinja

• Turning on Jinja autoescaping when using Template() directly - 2020-09-18

github-actions

• Talking to a PostgreSQL service container from inside a Docker container - 2020-09-18
• Open a debugging shell in GitHub Actions with tmate - 2020-09-14
• Skipping a GitHub Actions step without failing - 2020-08-22
• Using grep to write tests in CI - 2020-08-19
• Updating a Markdown table of contents with a GitHub Action - 2020-07-22
• Running different steps on a schedule - 2020-04-20
• Commit a file if it changed - 2020-04-19
• Set environment variables for all steps in a GitHub Action - 2020-04-19
• Dump out all GitHub Actions context - 2020-04-19
• Only run GitHub Action on push to master / main - 2020-04-19

linux

• Basic strace to see what a process is doing - 2020-09-07
• Piping echo to a file owned by root using sudo and tee - 2020-08-24

aws

• Display EC2 instance costs per month - 2020-09-06

typescript

• Very basic tsc usage - 2020-09-06

cloudrun

• Using the gcloud run services list command - 2020-09-01
• How to deploy a folder with a Dockerfile to Cloud Run - 2020-08-04
• Use labels on Cloud Run services for a billing breakdown - 2020-04-21

pytest

• Start a server in a subprocess during a pytest session - 2020-08-31
• Code coverage using pytest and codecov.io - 2020-08-15
• Registering temporary pluggy plugins inside tests - 2020-07-21
• Asserting a dictionary is a subset of another dictionary - 2020-05-28
• How to mock httpx using pytest-mock - 2020-04-29
• Session-scoped temporary directories in pytest - 2020-04-26

jq

• Converting Airtable JSON for use with sqlite-utils using jq - 2020-08-28

markdown

• Rendering Markdown with the GitHub Markdown API - 2020-08-22
• Converting HTML and rich-text to Markdown - 2020-05-09

svg

• Creating a dynamic line chart with SVG - 2020-08-22

ics

• Providing a "subscribe in Google Calendar" link for an ics feed - 2020-08-21

macos

• Finding the largest SQLite files on a Mac - 2020-08-19
• Fixing "compinit: insecure directories" error - 2020-04-26
• Close terminal window on Ctrl+D for macOS - 2020-04-21
• Get Skitch working on Catalina - 2020-04-21
• Running pip install -e .[test] in zsh on macOS Catalina - 2020-04-21

heroku

• Programatically accessing Heroku PostgreSQL from GitHub Actions - 2020-08-18
• Upgrading a Heroku PostgreSQL database with pg:copy - 2020-07-20
• Using heroku pg:pull to restore a backup to a macOS laptop - 2020-07-10

readthedocs

• Read the Docs Search API - 2020-08-16
• Pointing a custom subdomain at Read the Docs - 2020-08-14

zsh

• Customizing my zsh prompt - 2020-08-12

docker

• Attaching a bash shell to a running Docker container - 2020-08-10

django

• PostgreSQL full-text search in the Django Admin - 2020-07-25

asgi

• Writing tests for the ASGI lifespan protocol with HTTPX - 2020-06-29

pypi

• Adding project links to PyPI - 2020-05-11

firefox

• Search across all loaded resources in Firefox - 2020-05-05

node

• Constant-time comparison of strings in Node - 2020-05-01

tailscale

• Restricting SSH connections to devices within a Tailscale network - 2020-04-23

presenting

• Using macOS stickies to display a workshop link on the screen - 2020-04-20

zeit-now

• Running a Python ASGI app on Zeit Now v2 - 2020-04-19