Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-build 0.1a0 — Build a directory full of files into a SQLite database
TIL Using pprint() to print dictionaries while preserving their key order — While parsing a CSV file using `csv.DictReader` today I noticed the following surprising result:
Release datasette-auth-tokens 0.4a7 — Datasette plugin for authenticating access using API tokens
TIL Using expect() to wait for a selector to match multiple items — In the Playwright tests for [datasette-cluster-map](https://github.com/simonw/datasette-cluster-map) I wanted to assert that two markers had been displayed on a Leaflet map.
Release datasette-cluster-map 0.18 — Datasette plugin that shows a map for any data with latitude/longitude columns
TIL literalinclude with markers for showing code in documentation — I [wanted to include](https://github.com/simonw/datasette/issues/1830) some example Python tests in the Datasette documentation - but since they were tests, I also wanted to execute them as part of my test suite to make sure they worked correctly.
Release datasette-auth-tokens 0.4a6 — Datasette plugin for authenticating access using API tokens
Release datasette-auth-tokens 0.4a5 — Datasette plugin for authenticating access using API tokens
TIL Writing Playwright tests for a Datasette Plugin — I really like [Playwright](https://playwright.dev/) for writing automated tests for web applications using a headless browser. It's pretty easy to install and run, and it works well in GitHub Actions.
TIL How to get Cloudflare to cache HTML — To my surprise, if you setup a [Cloudflare](https://www.cloudflare.com/) caching proxy in front of a website it won't cache HTML pages by default, even if they are served with `cache-control:` headers.
TIL Running Varnish on Fly — The goal: run [Varnish](https://varnish-cache.org/) in a [Fly](https://fly.io/) container as a caching proxy in front of another Fly application.
Release datasette-search-all 1.1.2 — Datasette plugin for searching all searchable tables at once
Release datasette-upgrade 0.1a0 — Upgrade Datasette instance configuration to handle new features
TIL GitHub Actions, Issues and Pages to build a daily planner — I'm trying a new thing: a private daily planner, where each day I note down my goals for the day and make notes on my progress towards them as the day progresses.
Release datasette-haversine 0.2.1 — Datasette plugin that adds a custom SQL function for haversine distances
Release datasette 0.64.6 — An open source multi-tool for exploring and publishing data
TIL Running Steampipe extensions in sqlite-utils and Datasette — [Steampipe](https://steampipe.io/) build software that lets you query different APIs directly from SQL databases.
Release sqlite-utils-shell 0.3 — Interactive shell for sqlite-utils
Release django-sql-dashboard 1.2 — Django app for building dashboards using raw SQL queries
Release llm-mistral 0.2 — LLM plugin providing access to Mistral models using the Mistral API
Release llm-mistral 0.1 — LLM plugin providing access to Mistral models using the Mistral API
Release datasette-sqlite-authorizer 0.1 — Configure Datasette to block operations using the SQLIte set_authorizer mechanism
Release llm-anyscale-endpoints 0.4 — LLM plugin for models hosted by Anyscale Endpoints
Release llm-gemini 0.1a0 — LLM plugin to access Google's Gemini family of models
Release ospeak 0.3 — CLI tool for running text through OpenAI Text to speech
TIL Editing an iPhone home screen using macOS — My iPhone has a weird bug: I can no longer re-arrange the app icons on the home screen (or in the dock) by dragging them around on my phone. It lets me get into edit mode (where the icons wiggle) and drag them around, but when I release they go back to where they came from.
Release github-to-sqlite 2.9 — Save data from GitHub to a SQLite database
Release llm-llama-cpp 0.3 — LLM plugin for running models using llama.cpp
Release datasette-chronicle 0.2.1 — Enable sqlite-chronicle against tables in Datasette
Release sqlite-utils 3.36 — Python CLI utility and library for manipulating SQLite databases

Beats

Years

Tags