Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette 0.51 — An open source multi-tool for exploring and publishing data
Release datasette 0.51a2 — An open source multi-tool for exploring and publishing data
Release datasette-edit-schema 0.4a0 — Datasette plugin for modifying table schemas
Release datasette 0.51a1 — An open source multi-tool for exploring and publishing data
Release datasette-render-markdown 1.2 — Datasette plugin for rendering Markdown
TIL Decorators with optional arguments — [sqlite-utils](https://sqlite-utils.datasette.io/) provides [a decorator](https://sqlite-utils.datasette.io/en/stable/python-api.html#registering-custom-sql-functions) for registering custom Python functions that looks like this:
Release sqlite-utils 2.23 — Python CLI utility and library for manipulating SQLite databases
Release sphinx-to-sqlite 0.1a1 — Create a SQLite database from Sphinx documentation
Release datasette-cluster-map 0.14 — Datasette plugin that shows a map for any data with latitude/longitude columns
TIL Writing JavaScript that responds to media queries — I wanted to change the layout of [my blog](https://simonwillison.net/) on mobile screens such that the content from the "Elsewhere" right hand column combined with the main column in the correct order (issue [#165](https://github.com/simonw/simonwillisonblog/issues/165)). I couldn't find a way to do this in pure CSS without duplicating a bunch of content, so I decided to do it with JavaScript.
Release inaturalist-to-sqlite 0.2.1 — Create a SQLite database containing your observation history from iNaturalist
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
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
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
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.

Beats

Years

Tags