Conditionally running a second job in a GitHub Actions workflow
My [simonwillisonblog-backup workflow](https://github.com/simonw/simonwillisonblog-backup/blob/main/.github/workflows/backup.yml) periodically crea...
385 words
|
2 minutes
get-graphql-schema
The GraphQL schema language is a concise way to represent the available schema provided by a GraphQL endpoint. It looks something like this:
281 words
|
1 minute
Running gdb against a Python process in a running Docker container
While investigating [Datasette issue #1268](https://github.com/simonw/datasette/issues/1268) I found myself with a Python process that was hanging,...
169 words
|
1 minute
Packaging a Python CLI tool for Homebrew
I finally figured out how to package [Datasette](https://github.com/simonw/datasette) for installation with Homebrew. My package was accepted into ...
653 words
|
3 minutes
Lag window function in SQLite
Here's [how to use a lag window function](https://covid-19.datasettes.com/covid?sql=with+italy+as+%28%0D%0A++select%0D%0A++++rowid%2C%0D%0A++++day%...
129 words
|
1 minute
Running Datasette on Replit
I figured out how to run Datasette on https://replit.com/
133 words
|
1 minute
Rewriting a Git repo to remove secrets from the history
I decided to make a GitHub repository public today that had previously been private. Unfortunately the revision history of that repository included...
548 words
|
3 minutes
Planning parallel downloads with TopologicalSorter
For [complicated reasons](https://github.com/simonw/datasette/issues/878) I found myself wanting to write Python code to resolve a graph of depende...
321 words
|
2 minutes