Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Release TIL Research Tool Museum Sighting Comment

Filters: Sorted by date

Release datasette-pretty-json 0.2.2 — Datasette plugin that pretty-prints any column values that are valid JSON objects or arrays
28th Sep 2022, 9:06 pm · datasette
None
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.
28th Sep 2022, 3:45 am
Sighting 4:49 PM — Common Raven, in Pillar Point Harbor, CA, US
Common Raven
Common Raven
26th Sep 2022
Release datasette 0.63a0 — An open source multi-tool for exploring and publishing data
26th Sep 2022, 9:56 pm · datasette
None
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.
25th Sep 2022, 6:28 pm
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.
25th Sep 2022, 4:24 pm
Release ttml-to-json 0.2 — Convert TTML to JSON
25th Sep 2022, 12:49 am
Release webvtt-to-json 0.2 — Convert WebVTT to JSON, optionally removing duplicate lines
25th Sep 2022, 12:43 am
Release ttml-to-json 0.1 — Convert TTML to JSON
25th Sep 2022, 12:01 am
Release webvtt-to-json 0.1 — Convert WebVTT to JSON, optionally removing duplicate lines
24th Sep 2022, 11:46 pm
Release image-diff 0.2.2 — CLI tool for comparing images
19th Sep 2022, 7:42 pm
None
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.
19th Sep 2022, 3:08 am
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.
17th Sep 2022, 2:47 am
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.
16th Sep 2022, 7:31 pm
Release datasette-sandstorm-support 0.2 — Authentication and permissions for Datasette on Sandstorm
16th Sep 2022, 5:14 pm · datasette
Release s3-credentials 0.14 — A tool for creating credentials for accessing S3 buckets
15th Sep 2022, 11:43 pm
Release shot-scraper 0.16 — A command-line utility for taking automated screenshots of websites
15th Sep 2022, 3:18 am · shot-scraper
Release datasette-edit-templates 0.1a0 — Plugin allowing Datasette templates to be edited within Datasette
14th Sep 2022, 9:03 pm · datasette
None
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:
14th Sep 2022, 6:39 pm
Release datasette-sandstorm-support 0.1 — Authentication and permissions for Datasette on Sandstorm
14th Sep 2022, 4:09 am · datasette
None
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):
14th Sep 2022, 4:03 am
Release shot-scraper 0.15.1 — A command-line utility for taking automated screenshots of websites
13th Sep 2022, 5:15 pm · shot-scraper
Release shot-scraper 0.15 — A command-line utility for taking automated screenshots of websites
12th Sep 2022, 8:57 pm · shot-scraper
None
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.
10th Sep 2022, 3:38 pm
Release datasette-upload-dbs 0.1.2 — Upload SQLite database files to Datasette
9th Sep 2022, 3:58 pm · datasette
None
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.
8th Sep 2022, 8:47 pm
Release datasette-upload-csvs 0.8.2 — Datasette plugin for uploading CSV files and converting them to database tables
8th Sep 2022, 8:15 pm · datasette
Release datasette-upload-csvs 0.8.1 — Datasette plugin for uploading CSV files and converting them to database tables
8th Sep 2022, 7:51 pm · datasette
Release datasette-upload-csvs 0.8 — Datasette plugin for uploading CSV files and converting them to database tables
8th Sep 2022, 5:07 pm · datasette
None
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.
5th Sep 2022, 11:23 pm

Beats

Years

Tags