Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-render-markdown 2.1.1 — Datasette plugin for rendering Markdown
Release datasette-youtube-embed 0.1 — Turn YouTube URLs into embedded players in Datasette
None
TIL Rewriting a Git repo to remove secrets from the history — I decided to make a GitHub repository public today that had previously been private. Unfortunately the revision history of that repository included some secret values, one of which I could not figure out a way to revoke.
Sighting 1:46 PM – 1:57 PM — Great Blue Heron, Brush Rabbit, in Pillar Point Harbor, CA, US
Great Blue Heron
Great Blue Heron
Brush Rabbit
Brush Rabbit
Release datasette-granian 0.1a0 — Run Datasette using the Granian HTTP server
Release datasette-faiss 0.2 — Maintain a FAISS index for specified Datasette tables
Sighting 2:17 PM — California Brown Pelican, in Pillar Point Harbor, CA, US
California Brown Pelican
California Brown Pelican
Release datasette-openai 0.2 — SQL functions for calling OpenAI APIs
Release openai-to-sqlite 0.2 — Save OpenAI API results to a SQLite database
Release datasette-cookies-for-magic-parameters 0.1.2 — UI for setting cookies to populate magic parameters
Release datasette-openai 0.1a2 — SQL functions for calling OpenAI APIs
Release datasette-cookies-for-magic-parameters 0.1.1 — UI for setting cookies to populate magic parameters
Release datasette-cookies-for-magic-parameters 0.1 — UI for setting cookies to populate magic parameters
None
TIL Upgrading a pipx application to an alpha version — I wanted to upgrade my [git-history](https://datasette.io/tools/git-history) installation to a new alpha version.
Release git-history 0.7a0 — Tools for analyzing Git history using SQLite
Release datasette 0.64.1 — An open source multi-tool for exploring and publishing data
Release datasette-faiss 0.1a0 — Maintain a FAISS index for specified Datasette tables
None
TIL Scraping the Sky News Westminster Accounts, a Flourish application — Sky News in partnership with [Tortoise](https://www.tortoisemedia.com/) published a fantastic piece of investigative data reporting: [the Westminster Accounts](https://news.sky.com/story/westminster-accounts-methodology-12764656), a database of money in UK politics that brought together data from three different sources and make it explorable.
Release json-to-files 0.1 — Create separate files on disk based on a JSON object
Release datasette-openai 0.1a1 — SQL functions for calling OpenAI APIs
Release datasette-auth-passwords 1.1 — Datasette plugin for authentication using passwords
Release datasette 0.64 — An open source multi-tool for exploring and publishing data
Release datasette-publish-fly 1.3 — Datasette plugin for publishing data using Fly
Release shapefile-to-sqlite 0.4.2 — Load shapefiles into a SQLite (optionally SpatiaLite) database
None
TIL Loading SQLite extensions in Python on macOS — I finally found a workaround for this error when attempting to load a SQLite extension in Python on macOS:
None
TIL Geopoly in SQLite — I noticed this morning that one of my Datasette installations had the [Geopoly](https://www.sqlite.org/geopoly.html) SQLite extension enabled. I don't know how it got there - it has to be compiled specifically - but since it was there I decided to try it out.
Release datasette-openai 0.1a0 — SQL functions for calling OpenAI APIs
Release openai-to-sqlite 0.1a0 — Save OpenAI API results to a SQLite database
None
TIL Querying the GitHub archive with the ClickHouse playground — Via [this comment](https://news.ycombinator.com/item?id=34197637) on Hacker News I started exploring the [ClickHouse Playground](https://clickhouse.com/docs/en/getting-started/playground/). It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.