Simon Willison’s Weblog

Subscribe

August 2020

110 posts: 5 entries, 10 links, 5 quotes, 90 beats

Aug. 23, 2020

Release datasette-graphql 0.15 — Datasette plugin providing an automatic GraphQL API for your SQLite databases
Release datasette-graphql 1.0 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

Aug. 24, 2020

Release datasette-graphql 1.0.1 — Datasette plugin providing an automatic GraphQL API for your SQLite databases

Aug. 25, 2020

TIL Piping echo to a file owned by root using sudo and tee — I wanted to create a file with a shell one-liner where the file lived somewhere owned by root.

Aug. 27, 2020

Release asgi-csrf 0.7.1 — ASGI middleware for protecting against CSRF attacks

Aug. 28, 2020

TIL Browsing your local git checkout of homebrew-core — The [homebrew-core](https://github.com/Homebrew/homebrew-core) repository contains all of the default formulas for Homebrew.

Weeknotes: California Protected Areas in Datasette

Visit Weeknotes: California Protected Areas in Datasette

This week I built a geospatial search engine for protected areas in California, shipped datasette-graphql 1.0 and started working towards the next milestone for Datasette Cloud.

[... 1,099 words]

Mexican bean shakshuka

Visit Mexican bean shakshuka

The first time I ever tried a shakshuka I cooked it from this recipe by J. Kenji López-Alt. It quickly became my favourite breakfast.

[... 448 words]

Release sqlite-utils 2.16.1 — Python CLI utility and library for manipulating SQLite databases
Release datasette 0.49a0 — An open source multi-tool for exploring and publishing data

Aug. 29, 2020

TIL Converting Airtable JSON for use with sqlite-utils using jq — The Airtable API outputs JSON that looks like this:
Release airtable-export 0.1 — Export Airtable data to YAML, JSON or SQLite files on disk
Release airtable-export 0.1.1 — Export Airtable data to YAML, JSON or SQLite files on disk
Release airtable-export 0.2 — Export Airtable data to YAML, JSON or SQLite files on disk
Release airtable-export 0.3 — Export Airtable data to YAML, JSON or SQLite files on disk

airtable-export. I wrote a command-line utility for exporting data from Airtable and dumping it to disk as YAML, JSON or newline delimited JSON files. This means you can backup an Airtable database from a GitHub Action and get a commit history of changes made to your data.

# 9:48 pm / json, projects, yaml, airtable

Release airtable-export 0.3.1 — Export Airtable data to YAML, JSON or SQLite files on disk
Release datasette-yaml 0.1a — Export Datasette records as YAML

Aug. 30, 2020

Release airtable-export 0.4 — Export Airtable data to YAML, JSON or SQLite files on disk
TIL Minifying JavaScript with npx uglify-js — While [upgrading CodeMirror](https://github.com/simonw/datasette/issues/948) in Datasette I figured out how to minify JavaScript using `uglify-js` on the command line without first installing any teels, using [npx](https://www.npmjs.com/package/npx) (which downloads and executes a CLI tool while skipping the install step):

2020 » August

MTWTFSS
     12
3456789
10111213141516
17181920212223
24252627282930
31