Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

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.
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.
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.
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.
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:
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):
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.
Release datasette-upload-dbs 0.1.2 — Upload SQLite database files to Datasette
TIL Clone, edit and push files that live in a Gist — GitHub [Gists](https://gist.github.com/) are full Git repositories, and can be cloned and pushed to.
Release datasette-upload-csvs 0.8.2 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-upload-csvs 0.8.1 — Datasette plugin for uploading CSV files and converting them to database tables
Release datasette-upload-csvs 0.8 — Datasette plugin for uploading CSV files and converting them to database tables
TIL Run pytest against a specific Python version using Docker — For [datasette issue #1802](https://github.com/simonw/datasette/issues/1802) I needed to run my `pytest` test suite using a specific version of Python 3.7.
Release datasette-render-image-tags 0.1 — Turn any URLs ending in .jpg/.png/.gif into img tags with width 200
TIL Loading Twitter Birdwatch into SQLite for analysis with Datasette — [Twitter Birdwatch](https://twitter.github.io/birdwatch/) is "a collaborative way to add helpful context to Tweets and keep people better informed".
TIL How to scp files to and from Fly — I have a Fly instance with a 20GB volume, and I wanted to copy files to and from the instance from my computer using `scp`.
Release datasette-sitemap 1.0 — Generate sitemap.xml for Datasette sites
Release datasette-block-robots 1.1 — Datasette plugin that blocks robots and crawlers using robots.txt

Beats

Years

Tags