Simon Willison’s Weblog

Subscribe

Monday, 27th July 2020

Release datasette-render-images 0.3 — Datasette plugin that renders binary blob images using data-uris
Release datasette-render-images 0.3.1 — Datasette plugin that renders binary blob images using data-uris
Release sqlite-utils 2.12 — Python CLI utility and library for manipulating SQLite databases

sqlite-utils 2.12 (via) I’ve been experimenting with ways of improving BLOB support in Datasette and sqlite-utils. This new version of sqlite-utils includes a “sqlite-utils insert-files” command, which can recursively crawl directories for files and add their contents to SQLite with configurable columns containing their metadata.

I was inspired by Paul Ford who has been creating multi-GB SQLite databases of images and PDFs. It turns out that when disk space is cheap this is a pretty effective way of working with interesting corpuses of documents and images.

# 7:36 am / projects, sqlite, sqlite-utils

Release datasette-media 0.4 — Datasette plugin for serving media based on a SQL query
Release db-to-sqlite 1.3 — CLI tool for exporting tables or queries from any SQL database to a SQLite file
Sunday, 26th July 2020
Tuesday, 28th July 2020