Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release healthkit-to-sqlite 1.0 — Convert an Apple Healthkit export zip to a SQLite database
TIL Explicit file encodings using click.File — I wanted to add a `--encoding` option to `sqlite-utils insert` which could be used to change the file encoding used to read the incoming CSV or TSV file - see [sqlite-utils #182](https://github.com/simonw/sqlite-utils/issues/182).
None
Release sqlite-utils 2.22 — Python CLI utility and library for manipulating SQLite databases
Release csv-diff 1.0 — Python CLI tool and library for diffing CSV and JSON files
TIL Upgrading Python Homebrew packages using pip — [VisiData 2.0](https://www.visidata.org/) came out today. I previously installed VisiData using Homebrew, but the VisiData tap has not yet been updated with the latest version.
None
Release swarm-to-sqlite 0.3.2 — Create a SQLite database containing your checkin history from Foursquare Swarm
Release evernote-to-sqlite 0.2 — Tools for converting Evernote content to SQLite
Release evernote-to-sqlite 0.1 — Tools for converting Evernote content to SQLite
Release xml-analyser 1.0 — Simple command line tool for quickly analysing the structure of an arbitrary XML file
Release datasette-json-preview 0.1 — Preview of new JSON default format for Datasette
Release datasette 0.50.2 — An open source multi-tool for exploring and publishing data
TIL Searching for repositories by topic using the GitHub GraphQL API — I wanted to use the GitHub GraphQL API to return all of the repositories on the https://github.com/topics/git-scraping page.
None
Release datasette 0.50.1 — An open source multi-tool for exploring and publishing data
Release datasette 0.50 — An open source multi-tool for exploring and publishing data
TIL Running Datasette on DigitalOcean App Platform — [App Platform](https://www.digitalocean.com/docs/app-platform/) is the new PaaS from DigitalOcean. I figured out how to run Datasette on it.
None
Release datasette 0.50a1 — An open source multi-tool for exploring and publishing data
TIL Manipulating query strings with URLSearchParams — The `URLSearchParams` class, in [every modern browser](https://caniuse.com/?search=URLSearchParams) since IE 11, provides a sensible API for manipulating query string parameters in JavaScript. I first used it to build Datasette's column action menu, see [table.js](https://github.com/simonw/datasette/blob/0.50a0/datasette/static/table.js) and [issue 981](https://github.com/simonw/datasette/issues/981).
None
TIL Using async/await in JavaScript in Selenium — Thanks [Stuart Langridge](https://twitter.com/sil/status/1312137808111304704) for showing me how to do this:
None
TIL Installing Selenium for Python on macOS with ChromeDriver — I needed to run Selenium on macOS for the first time today. Here's how I got it working.
None
Release datasette 0.50a0 — An open source multi-tool for exploring and publishing data
Release datasette-cluster-map 0.12.4 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-edit-schema 0.3 — Datasette plugin for modifying table schemas
Release datasette-edit-schema 0.3a2 — Datasette plugin for modifying table schemas
TIL Escaping strings in Bash using !:q — TIL this trick, [via Pascal Hirsch](https://twitter.com/phphys/status/1311727268398465029) on Twitter. Enter a line of Bash starting with a `#` comment, then run `!:q` on the next line to see what that would be with proper Bash escaping applied.
None
Release datasette-cluster-map 0.12.3 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-cluster-map 0.12.2 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-cluster-map 0.12.1 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release datasette-edit-schema 0.3a1 — Datasette plugin for modifying table schemas
Release datasette-edit-schema 0.3a — Datasette plugin for modifying table schemas
Release datasette-dateutil 0.2.1 — dateutil functions for Datasette