Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release pocket-to-sqlite 0.2.1 — Create a SQLite database containing data from your Pocket account
Release datasette 0.51a0 — An open source multi-tool for exploring and publishing data
Release datasette-json-preview 0.2 — Preview of new JSON default format for Datasette
Release datasette-cluster-map 0.13 — Datasette plugin that shows a map for any data with latitude/longitude columns
Release github-to-sqlite 2.7 — Save data from GitHub to a SQLite database
Release sphinx-to-sqlite 0.1a — Create a SQLite database from Sphinx documentation
Release dogsheep-beta 0.9 — Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
Release healthkit-to-sqlite 1.0 — Convert an Apple Healthkit export zip to a SQLite database
None
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).
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
None
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.
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
Sighting 7:28 PM — Striped Skunk, in San Francisco County, US, CA
Striped Skunk
Striped Skunk
Release datasette 0.50.2 — An open source multi-tool for exploring and publishing data
None
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.
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
None
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.
Release datasette 0.50a1 — An open source multi-tool for exploring and publishing data
None
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.
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