Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-hashed-urls 0.1a0 — Optimize Datasette performance behind a caching proxy
None
TIL Concatenating strings and newlines in Google Sheets — I was asked if there was a way to run [shot-scraper](https://github.com/simonw/shot-scraper) against a list of URLs in a Google Sheet.
Release shot-scraper 0.9 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.8 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.7 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.6 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.5 — A command-line utility for taking automated screenshots of websites
Release image-diff 0.2.1 — CLI tool for comparing images
Release image-diff 0.2 — CLI tool for comparing images
Release image-diff 0.1 — CLI tool for comparing images
Release sqlite-utils 3.25.1 — Python CLI utility and library for manipulating SQLite databases
Release shot-scraper 0.4 — A command-line utility for taking automated screenshots of websites
Sighting 11:06 AM – 11:34 AM — California Sea Lion, Willet, in Monterey Bay National Marine Sanctuary, CA, US, CA
California Sea Lion
California Sea Lion
Willet
Willet
Release shot-scraper 0.3 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.2 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.1 — A command-line utility for taking automated screenshots of websites
Release shot-scraper 0.1a0 — A command-line utility for taking automated screenshots of websites
Release django-sql-dashboard 1.0.2 — Django app for building dashboards using raw SQL queries
None
TIL pytest coverage with context — [This tweet](https://twitter.com/mariatta/status/1499863816489734146) from \@Mariatta tipped me off to the ability to measure "contexts" when [running coverage](https://coverage.readthedocs.io/en/6.3.2/contexts.html#context-reporting) - as a way to tell which tests exercise which specific lines of code.
Sighting 12:31 PM – 12:37 PM — Brewer's Blackbird, California Gull, in Monterey Bay National Marine Sanctuary, CA, US, CA
Brewer's Blackbird
Brewer's Blackbird
California Gull
California Gull
None
TIL Natural Earth in SpatiaLite and Datasette — Natural Earth ([website](https://www.naturalearthdata.com/), [Wikipedia](https://en.wikipedia.org/wiki/Natural_Earth)) is a a public domain map dataset.
Release geojson-to-sqlite 1.0 — CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
Release sqlite-utils 3.25 — Python CLI utility and library for manipulating SQLite databases
Release xml-analyser 1.3 — Simple command line tool for quickly analysing the structure of an arbitrary XML file
Release datasette-dateutil 0.3 — dateutil functions for Datasette
None
TIL Installing Python on macOS with the official Python installer — I usually use Homebrew on macOS, but I decided to try using the official Python installer based on [this Twitter conversation](https://twitter.com/rtpg_/status/1498115527465914371).
None
TIL Running the latest SQLite in Datasette using Homebrew — I made a pleasant discovery today: Homebrew are very quick to update to the latest SQLite release (here's [their formula](https://github.com/Homebrew/homebrew-core/blob/master/Formula/sqlite.rb)), and since [Datasette](https://datasette.io/) when installed via Homebrew uses that version, this means you can use `brew update sqlite` to ensure you are running the most recent SQLite version within Datasette.
None
TIL Crawling Datasette with Datasette — I wanted to add the new tutorials on https://datasette.io/tutorials to the search index that is used by the https://datasette.io/-/beta search engine.
Release datasette-render-markdown 2.1 — Datasette plugin for rendering Markdown
Release datasette-redirect-forbidden 0.1 — Redirect forbidden requests to a login page