Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-sentry 0.3 — Datasette plugin for configuring Sentry
Release datasette-search-all 1.1 — Datasette plugin for searching all searchable tables at once
Release datasette-public 0.1 — Make selected Datasette databases and tables visible to the public
TIL Tommy's Margarita — A few years ago I decided to learn how to make some classic cocktails. It is a very rewarding hobby.
None
TIL GraphQL fragments — One of [the scripts](https://github.com/simonw/datasette.io/blob/main/build_directory.py) that builds and deploys [datasette.io](https://datasette.io/) uses a GraphQL query to retrieve information from GitHub about the repositories used for the various Datasette tools and plugins.
None
TIL HTML video that loads when the user clicks play — Today I figured out how to use the `<video>` tag to show a static thumbnail that gets replaced by the loaded video only when the user clicks play.
None
Release datasette-publish-fly 1.2 — Datasette plugin for publishing data using Fly
Release datasette-pretty-json 0.2.2 — Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays
TIL Athena error: The specified key does not exist — I was trying to run Athena queries against compressed JSON log files stored in an S3 bucket.
None
Release datasette 0.63a0 — An open source multi-tool for exploring and publishing data
TIL Ensure labels exist in a GitHub repository — I wanted to ensure that when [this template repository](https://github.com/simonw/action-transcription) was used to create a new repo that repo would have a specific set of labels.
None
TIL Whisky sour — I picked up the recipe for this one from [this video](https://www.tiktok.com/t/ZTRaxyxQP/) by [@notjustabartender](https://www.tiktok.com/@notjustabartender) on TikTok.
None
Release ttml-to-json 0.2 — Convert TTML to JSON
Release webvtt-to-json 0.2 — Convert WebVTT to JSON, optionally removing duplicate lines
Release ttml-to-json 0.1 — Convert TTML to JSON
Release webvtt-to-json 0.1 — Convert WebVTT to JSON, optionally removing duplicate lines
Release image-diff 0.2.2 — CLI tool for comparing images
TIL Deploying Python web apps as AWS Lambda functions — I've been wanting to figure out how to do this for years. Today I finally put all of the pieces together for it.
None
TIL Using DuckDB in Python to access Parquet data — Did a quick experiment with [DuckDB](https://duckdb.org/) today, inspired by the [bmschmidt/hathi-binary](https://github.com/bmschmidt/hathi-binary) repo.
None
TIL Returning related rows in a single SQL query using JSON — When building database-backed applications you'll often find yourself wanting to return a row from the database along with its related rows.
None
Release datasette-sandstorm-support 0.2 — Authentication and permissions for Datasette on Sandstorm
Release s3-credentials 0.14 — A tool for creating credentials for accessing S3 buckets
Release shot-scraper 0.16 — A command-line utility for taking automated screenshots of websites
Release datasette-edit-templates 0.1a0 — Plugin allowing Datasette templates to be edited within Datasette
TIL Running PyPy on macOS using Homebrew — [Towards Inserting One Billion Rows in SQLite Under A Minute](https://avi.im/blag/2021/fast-sqlite-inserts/) includes this snippet:
None
Release datasette-sandstorm-support 0.1 — Authentication and permissions for Datasette on Sandstorm
TIL Browse files (including SQLite databases) on your iPhone with ifuse — I spotted an intriguing note in the release notes for [osxphotos 0.51.7](https://github.com/RhetTbull/osxphotos/releases/tag/v0.51.7):
None
Release shot-scraper 0.15.1 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.15 — A command-line utility for taking automated screenshots of websites
TIL Driving an external display from a Mac laptop — For a friend's wedding I needed to run a Google Photos slideshow on some large televisions.
None