Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-dns 0.1a1 — Custom SQL function for making DNS lookups
Release datasette-dns 0.1a0 — Custom SQL function for making DNS lookups
Release dogsheep-beta 0.7a0 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release sqlite-utils 2.18 — Python CLI utility and library for manipulating SQLite databases
TIL Basic strace to see what a process is doing — I had a long-running process and I wanted to check that it was at least doing _something_.
None
Release sqlite-utils 2.17 — Python CLI utility and library for manipulating SQLite databases
TIL Display EC2 instance costs per month — The [EC2 pricing page](https://aws.amazon.com/ec2/pricing/on-demand/) shows cost per hour, which is pretty much useless. I want cost per month. The following JavaScript, pasted into the browser developer console, modifies the page to show cost-per-month instead.
None
Release datasette-backup 0.1 — Plugin adding backup options to Datasette
Release sqlite-dump 0.1.1 — An improved version of .iterdump() for sqlite3
Release sqlite-dump 0.1 — An improved version of .iterdump() for sqlite3
TIL Very basic tsc usage — I guess I [have to learn TypeScript](https://twitter.com/simonw/status/1302517496767938561) now.
None
Release sqlite-dump 0.1a — An improved version of .iterdump() for sqlite3
Release datasette-backup 0.1a — Plugin adding backup options to Datasette
Release datasette-block-robots 0.3 — Datasette plugin that blocks robots and crawlers using robots.txt
Release datasette-block-robots 0.2 — Datasette plugin that blocks robots and crawlers using robots.txt
Release dogsheep-beta 0.6 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.5 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.4.1 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.4 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.4a1 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
TIL Debugging a Click application using pdb — This tip is for when you are working on a Python command-line application that runs using that program's name, as opposed to typing `python my_script.py`. I usually need this when I'm working on applications built using [Click](https://click.palletsprojects.com/), e.g. projects I start using my [click-app](https://github.com/simonw/click-app) cookiecutter template.
None
Release dogsheep-beta 0.4a0 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.3 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
TIL Using the gcloud run services list command — The `gcloud run services list` command lists your services running on Google Cloud Run:
None
TIL Looping over comma-separated values in Bash — Given a file (or a process) that produces comma separated values, here's how to split those into separate variables and use them in a bash script.
None
Release dogsheep-beta 0.2 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.1 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.1a2 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release dogsheep-beta 0.1a — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
TIL Start a server in a subprocess during a pytest session — I wanted to start an actual server process, run it for the duration of my pytest session and shut it down at the end.
None