Things I've learned, collected in simonw/til. You may also enjoy my blog.
Browse by topic: amplitude 1 · asgi 1 · auth0 2 · aws 8 · awslambda 1 · azure 1 · bash 8 · caddy 1 · cloudflare 1 · cloudrun 8 · cocktails 3 · cookiecutter 2 · datasette 10 · deno 1 · digitalocean 1 · django 16 · docker 9 · duckdb 1 · electron 6 · firefox 1 · fly 7 · gis 2 · git 4 · github 12 · github-actions 23 · google-sheets 1 · googlecloud 5 · gpt3 4 · graphql 3 · heroku 3 · homebrew 5 · html 3 · ics 1 · imagemagick 2 · javascript 14 · jinja 2 · jq 6 · json 1 · jupyter 1 · kubernetes 2 · linux 4 · macos 14 · markdown 3 · mastodon 3 · mediawiki 1 · networking 1 · nginx 1 · node 1 · npm 3 · observable-plot 2 · pixelmator 1 · pluggy 1 · postgresql 6 · presenting 1 · purpleair 1 · pypi 1 · pytest 16 · python 43 · quarto 1 · readthedocs 5 · reddit 1 · selenium 2 · service-workers 1 · shot-scraper 2 · spatialite 3 · sphinx 3 · sql 3 · sqlite 32 · svg 1 · tailscale 1 · tesseract 1 · twitter 3 · typescript 1 · vega 1 · vim 1 · vscode 2 · web-components 1 · webassembly 1 · webauthn 1 · wikipedia 1 · zeit-now 2 · zsh 2
I used the google-github-actions/setup-gcloud action in all of my GitHub Actions workflows that deploy applications to Cloud Run. …
I had a Django project that used pipenv (in particular a Pipfile.lock) to manage dependencies and I wanted to build a Docker container for it. …
I used to use a combination of actions/setup-python and actions/cache in all of my Python GitHub Actions projects in order to install Python dependencies via a cache, rather than hitting PyPI to download copies every time. …
Most modern browsers now include support for the loading="lazy" image attribute, which causes images not to be loaded unti the user scrolls them into view. …
I'm working on dclient, a CLI tool for interacting with Datasette instances via the Datasette API. …
In this Observable notebook I'm plotting a line on a chart, but I want to provide tooltips showing the exact value at any point on the line. …
Mastodon has a really neat way of implementing verification, using the rel=me microformat. …
I figured this out in a Gist in 2016 which has attracted a bunch of comments over the years. Now I'm upgrading it to a retroactive TIL. …
A Datasette feature suggestion concerning autocomplete against a list of known values inspired me to learn how to use the HTML <datalist> element (see MDN). …
I needed to write a relatively repetitive collection of tests, for a number of different possible error states. …
I'm looking at options for representing JSON validation errors in more JSON. The recent RFC 7807: Problem Details for HTTP APIs looks relevant here. …
I wanted to start playing around with OpenAPI. I decided to see if I could get GPT-3 to generate the first version of a specification for me. …
I've been playing around with the Mastodon timelines API. It's pretty fun! …
This TIL is mainly a rehash of these two articles by Jacob and Andrew: …
GitHub Pages is an excellent free hosting platform, but the documentation is missing out on some crucial details. …
Today Carlton told me about the interact command in the Python debugger. …
I extracted and enhanced this TIL from my April 8th 2020 weeknotes to make it easier to find. …
Google Chrome still includes support for Web SQL, the long since abandoned proposed standard for shipping a SQL engine in browser JavaScript. I was reminded of its existence today while reading about the new official sqlite3 wasm build. …
I puzzled over this one for quite a while this morning. I had this test that was failing with Windows on Python 3.11: …
My new datasette-gunicorn plugin adds a new command to Datasette - datasette gunicorn - which mostly replicates the existing datasette serve command but with a few differences. …
I've been using Locust recently to run some load tests - most significantly these tests against SQLite running with Django and this test exercising Datasette and Gunicorn. …
Datasette is implemented as an ASGI application. …
I was experimenting with the new Readwise export API and it gave me back the following JSON: …
For Datasette issue #1844 I wanted to create the following screenshot: …
I was getting this intermittent error running my Datasette test suite: …
This classic Peruvian cocktail recipe is particularly useful if you have chickens producing fresh eggs! …
I've been writing my Fly logs to S3 in newline-delimited JSON format using the recipe described in Writing Fly logs to S3. …
A few years ago I decided to learn how to make some classic cocktails. It is a very rewarding hobby. …
One of the scripts that builds and deploys datasette.io uses a GraphQL query to retrieve information from GitHub about the repositories used for the various Datasette tools and plugins. …
Today I figured out how to use the <video> tag to show a static thumbnail that gets replaced by the loaded video only when the user clicks play. …