Simon Willison’s Weblog

Subscribe

August 2021

75 posts: 6 entries, 20 links, 8 quotes, 41 beats

Aug. 24, 2021

Release sqlite-utils 3.17 — Python CLI utility and library for manipulating SQLite databases

Aug. 25, 2021

API Tokens: A Tedious Survey. Thomas Ptacek reviews different approaches to implementing secure API tokens, from simple random strings stored in a database through various categories of signed token to exotic formats like Macaroons and Biscuits, both new to me.

Macaroons carry a signed list of restrictions with them, but combine it with a mechanism where a client can add their own additional restrictions, sign the combination and pass the token on to someone else.

Biscuits are similar, but “embed Datalog programs to evaluate whether a token allows an operation”.

# 12:12 am / apis, security, thomas-ptacek, fly

Allo shows the ultimate failure of Google's Minimum Viable Product strategy. MVP works when you have almost no competition, or if you are taking a radically different approach to what's on the market, but it completely falls on its face when you are just straight-up cloning an established competitor. There's no reason to use a half-baked WhatsApp clone when regular WhatsApp exists.

Ron Amadeo

# 10:28 pm / product-management, google

Aug. 26, 2021

Sighting 5:06 PM — Red-shouldered Hawk, in San Mateo County, CA, US
Red-shouldered Hawk
Red-shouldered Hawk
Release evernote-to-sqlite 0.3.2 — Tools for converting Evernote content to SQLite

Aug. 28, 2021

Release datasette 0.59a2 — An open source multi-tool for exploring and publishing data
Release datasette-verify 0.1 — Verify that files can be opened by Datasette

Dynamic content for GitHub repository templates using cookiecutter and GitHub Actions

Visit Dynamic content for GitHub repository templates using cookiecutter and GitHub Actions

GitHub repository templates were introduced a couple of years ago to provide a mechanism for creating a brand new GitHub repository starting with an initial set of files.

[... 1,413 words]

Aug. 30, 2021

Building a desktop application for Datasette (and weeknotes)

Visit Building a desktop application for Datasette (and weeknotes)

This week I started experimenting with a desktop application version of Datasette—with the goal of providing people who aren’t comfortable with the command-line the ability to get Datasette up and running on their own personal computers.

[... 1,423 words]

Unshipped work is inventory and it costs you money as it spoils

Avery Pennarun

# 5:46 am / deployment

Aug. 31, 2021

None
TIL Calculating the AQI based on the Purple Air API for a sensor — [Purple Air](https://www.purpleair.com/) sensors have an API at `https://www.purpleair.com/map.json?show=SENSOR-ID-HERE`, which returns JSON that looks something like this:
None
TIL Using the Chrome DevTools console as a REPL for an Electron app — I figured out how to use the Chrome DevTools to execute JavaScript interactively inside the Electron main process. I always like having a REPL for exploring APIs, and this means I can explore the Electron and Node.js APIs interactively.
Release datasette-app-support 0.1 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.1.1 — Part of https://github.com/simonw/datasette-app
Release datasette-app-support 0.1.2 — Part of https://github.com/simonw/datasette-app

2021 » August

MTWTFSS
      1
2345678
9101112131415
16171819202122
23242526272829
3031