Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release xml-analyser 1.3 — Simple command line tool for quickly analysing the structure of an arbitrary XML file
Release datasette-dateutil 0.3 — dateutil functions for Datasette
TIL Installing Python on macOS with the official Python installer — I usually use Homebrew on macOS, but I decided to try using the official Python installer based on [this Twitter conversation](https://twitter.com/rtpg_/status/1498115527465914371).
TIL Running the latest SQLite in Datasette using Homebrew — I made a pleasant discovery today: Homebrew are very quick to update to the latest SQLite release (here's [their formula](https://github.com/Homebrew/homebrew-core/blob/master/Formula/sqlite.rb)), and since [Datasette](https://datasette.io/) when installed via Homebrew uses that version, this means you can use `brew update sqlite` to ensure you are running the most recent SQLite version within Datasette.
TIL Crawling Datasette with Datasette — I wanted to add the new tutorials on https://datasette.io/tutorials to the search index that is used by the https://datasette.io/-/beta search engine.
Release datasette-render-markdown 2.1 — Datasette plugin for rendering Markdown
Release datasette-redirect-forbidden 0.1 — Redirect forbidden requests to a login page
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:
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
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
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.
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
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
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
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
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

Beats

Years

Tags