Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Sighting 11:20 AM – 12:01 PM — Eastern Gray Squirrel, American Robin, Red-eared Slider, in Golden Gate Park, CA, US
Eastern Gray Squirrel
Eastern Gray Squirrel
American Robin
American Robin
Red-eared Slider
Red-eared Slider
None
TIL Using curl to run GraphQL queries from the command line — I wanted to run a query against the GitHub GraphQL API using `curl` on the command line, while keeping the query itself as readable as possible. Here's the recipe I came up with (tested in both `bash` and `zsh`), with TOKEN replaced by my GitHub API personal access token:
Sighting 11:15 AM – 12:24 PM — Brewer's Blackbird, in San Mateo County, CA, US
Brewer's Blackbird
Brewer's Blackbird
Brewer's Blackbird
Brewer's Blackbird
Release sqlite-diffable 0.2.1 — Tools for dumping/loading a SQLite database to diffable directory structure
Release google-drive-to-sqlite 0.4 — Create a SQLite database containing metadata from Google Drive
Release google-drive-to-sqlite 0.3 — Create a SQLite database containing metadata from Google Drive
Sighting 6:04 PM – 6:12 PM — American Kestrel, Great Blue Heron, in San Mateo County, CA, US
American Kestrel
American Kestrel
Great Blue Heron
Great Blue Heron
Release google-drive-to-sqlite 0.2a0 — Create a SQLite database containing metadata from Google Drive
Release google-drive-to-sqlite 0.1a2 — Create a SQLite database containing metadata from Google Drive
Release google-drive-to-sqlite 0.1a1 — Create a SQLite database containing metadata from Google Drive
None
TIL Recursively fetching metadata for all files in a Google Drive folder — For [google-drive-to-sqlite](https://github.com/simonw/google-drive-to-sqlite) I wanted a mechanism to recursively return metadata on every file in a specified Goole Drive folder.
None
TIL Google OAuth for a CLI application — > :warning: The OOB flow described in this document has been [scheduled for deprecation](https://developers.googleblog.com/2022/02/making-oauth-flows-safer.html?m=1#disallowed-oo) by Google. See [issue #39](https://github.com/simonw/google-drive-to-sqlite/issues/39) for notes on how to replace it.
Release google-drive-to-sqlite 0.1a0 — Create a SQLite database containing metadata from Google Drive
None
TIL Combining substr and instr to extract text — Derek Willis has [a Datasette instance full of political campaign emails](https://political-emails.herokuapp.com/) running on Heroku.
Release sqlite-utils 3.24 — Python CLI utility and library for manipulating SQLite databases
None
TIL nullglob in bash — I ran into a tricky problem while working [on this issue](https://github.com/simonw/datasette-publish-fly/issues/17): the following line was behaving in an unexpected way for me:
Release datasette-publish-fly 1.1.1 — Datasette plugin for publishing data using Fly
Release datasette-tiddlywiki 0.2 — Run TiddlyWiki in Datasette and save Tiddlers to a SQLite database
None
TIL Enabling a user to execute a specific command as root without a password — I wanted a script running as a non-root user to be able to restart a systemd service on my Ubuntu machine without needing a password.
Release strip-hidden-form-values 0.2.1 — CLI tool for stripping hidden form values from an HTML document
Release strip-hidden-form-values 0.2 — CLI tool for stripping hidden form values from an HTML document
Release strip-hidden-form-values 0.1 — CLI tool for stripping hidden form values from an HTML document
None
TIL Annotated package.json for idb-keyval — Jake Archibald [pointed to](https://twitter.com/jaffathecake/status/1491771402294370306) his `package.json` for `idb-keyval` as a "modernish example" of NPM packaging on Twitter this morning.
Release datasette-publish-fly 1.1 — Datasette plugin for publishing data using Fly
Release datasette-auth-passwords 1.0 — Datasette plugin for authentication using passwords
Release datasette 0.60.2 — An open source multi-tool for exploring and publishing data
None
TIL Ordered group_concat() in SQLite — I was trying to use `group_concat()` to glue together some column values into a stiched together Markdown document. My first attempt looked like this:
Release sqlite-utils 3.23 — Python CLI utility and library for manipulating SQLite databases
None
TIL Testing against Python 3.11 preview using GitHub Actions — I decided to run my CI tests against the Python 3.11 preview, to avoid the problem I had when Python 3.10 came out with [a bug that affected Datasette](https://simonwillison.net/2021/Oct/9/finding-and-reporting-a-bug/).