Simon Willison: TIL

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

Atom feed

Recently added: How to deploy a folder with a Dockerfile to Cloud Run, SQLite BLOB literals, PostgreSQL full-text search in the Django Admin, Implementing a "copy to clipboard" button, Updating a Markdown table of contents with a GitHub Action

asgi

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

cloudrun

• Use labels on Cloud Run services for a billing breakdown - 2020-04-21
• How to deploy a folder with a Dockerfile to Cloud Run - 2020-08-04

django

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

firefox

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

github

• Accessing repository dependencies in the GitHub GraphQL API - 2020-04-30
• Paginating through the GitHub GraphQL API with Python - 2020-07-09

github-actions

• Only run GitHub Action on push to master - 2020-04-19
• Dump out all GitHub Actions context - 2020-04-19
• Set environment variables for all steps in a GitHub Action - 2020-04-19
• Commit a file if it changed - 2020-04-19
• Running different steps on a schedule - 2020-04-20
• Updating a Markdown table of contents with a GitHub Action - 2020-07-22

heroku

• Using heroku pg:pull to restore a backup to a macOS laptop - 2020-07-10
• Upgrading a Heroku PostgreSQL database with pg:copy - 2020-07-20

javascript

• Implementing a "copy to clipboard" button - 2020-07-23

macos

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

markdown

• Converting HTML and rich-text to Markdown - 2020-05-09

node

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

presenting

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

pypi

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

pytest

• Session-scoped temporary directories in pytest - 2020-04-26
• How to mock httpx using pytest-mock - 2020-04-29
• Asserting a dictionary is a subset of another dictionary - 2020-05-28
• Registering temporary pluggy plugins inside tests - 2020-07-21

python

• Convert a datetime object to UTC without using pytz - 2020-04-19
• macOS Catalina sort-of includes Python 3 - 2020-04-21
• Generated a summary of nested JSON data - 2020-04-28
• Installing and upgrading Datasette plugins with pipx - 2020-05-04
• Use setup.py to install platform-specific dependencies - 2020-05-05
• Build the official Python documentation locally - 2020-05-08
• Introspecting Python function parameters - 2020-05-27
• Password hashing in Python with pbkdf2 - 2020-07-13

sqlite

• Lag window function in SQLite - 2020-04-19
• Null case comparisons in SQLite - 2020-04-21
• Compile a new sqlite3 binary on Ubuntu - 2020-04-30
• List all columns in a SQLite database - 2020-05-06
• Using LD_PRELOAD to run any version of SQLite with Python - 2020-06-17
• SQLite BLOB literals - 2020-07-29

tailscale

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

zeit-now

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