git bisect
I extracted and enhanced this TIL from [my April 8th 2020 weeknotes](https://simonwillison.net/2020/Apr/8/weeknotes-zeit-now-v2/#git-bisect) to mak...
476 words
|
2 minutes
Open external links in an Electron app using the system browser
For [Datasette.app](https://github.com/simonw/datasette-app) I wanted to ensure that links to external URLs would [open in the system browser](http...
177 words
|
1 minute
Configuring Django SQL Dashboard for Fly PostgreSQL
I have a Fly application that uses their PostgreSQL service. I wanted to run [Django SQL Dashboard]() with a read-only user against that database.
463 words
|
2 minutes
Summing columns in remote Parquet files using DuckDB
[vivym/midjourney-messages](https://huggingface.co/datasets/vivym/midjourney-messages) on Hugging Face is a large (~8GB) dataset consisting of 55,0...
2149 words
|
11 minutes
Export a Mastodon timeline to SQLite
I've been playing around with [the Mastodon timelines API](https://docs.joinmastodon.org/methods/timelines/). It's pretty fun!
314 words
|
2 minutes
Natural Earth in SpatiaLite and Datasette
Natural Earth ([website](https://www.naturalearthdata.com/), [Wikipedia](https://en.wikipedia.org/wiki/Natural_Earth)) is a a public domain map dat...
348 words
|
2 minutes
Using the gcloud run services list command
The `gcloud run services list` command lists your services running on Google Cloud Run:
347 words
|
2 minutes
Verifying your GitHub profile on Mastodon
Mastodon has a really neat way of implementing verification, using the [rel=me microformat](https://microformats.org/wiki/rel-me).
539 words
|
3 minutes