Simon Willison’s Weblog

Subscribe
Atom feed

Elsewhere

Filters: Sorted by date

Release datasette-auth-tokens 0.4a11 — Datasette plugin for authenticating access using API tokens
Release datasette-upload-dbs 0.4a0 — Upload SQLite database files to Datasette
Release datasette-configure-fts 1.2a0 — Datasette plugin for enabling full-text search against selected table columns
Release datasette-edit-templates 0.5a0 — Plugin allowing Datasette templates to be edited within Datasette
Release datasette-upload-csvs 0.10a0 — Datasette plugin for uploading CSV files and converting them to database tables
Research UV Run Flow Analysis: Deep Dive into `uv run myscript.py` — Running `uv run myscript.py` in a directory with a `pyproject.toml` launches a multi-phase workflow that automates Python script execution within an isolated, dependency-managed environment. uv scans for project metadata, resolves and validates interpreter and package requirements, manages virtual environments, locks dependencies with a TOML-based `uv.lock` file using the PubGrub algorithm, efficiently syncs the environment with parallel downloads and caching, and finally executes the desired…
Research env86 Analysis Report — env86 is a Go-based management tool that enables users to run x86 Linux virtual machines within browser contexts via the v86 WebAssembly emulator. By combining a native desktop application (embedding a browser), a robust CLI, and an integrated virtual networking stack, env86 provides an easily distributable and reproducible Linux environment that can boot instantly from snapshots, support host-guest communication, and mount host filesystems.
Release datasette-ephemeral-tables 0.2.3 — Provide tables that expire after a time limit
Research LLM Pyodide OpenAI Plugin — Leveraging the LLM Python package and pyodide, this project successfully adapts LLM’s OpenAI model interface for direct use in browser environments by bypassing the standard openai library (which fails in browsers due to its httpx dependency) and instead using the browser-native fetch API for CORS-compliant API calls.
Research OpenAI Codex CLI Sandbox Implementation Analysis — OpenAI Codex CLI's sandbox employs strong, platform-specific isolation to securely constrain the behavior of AI-driven code agents. On macOS, it uses Apple's Seatbelt sandbox with finely tuned dynamic policies, while on Linux, it combines Landlock for strict filesystem controls and seccomp for syscall-based network blocking—ensuring that agents can only write to user-approved directories and have no outgoing network by default.
Release datasette-llm-usage 0.1a2 — Track usage of LLM tokens in a SQLite table
Release datasette-query-assistant 0.1a5 — Query databases and tables with AI assistance
Release datasette-load 0.1a5 — API and UI for bulk loading data into Datasette from a URL
Release datasette-events-db 0.1a2 — Log Datasette events to a database table
Release datasette-remote-actors 0.1a7 — Datasette plugin for fetching details of actors from a remote endpoint
Release datasette-debug-events 0.1a2 — Print Datasette events to standard error
Release datasette-debug-actors-from-ids 0.1a3 — Datasette plugin for trying out the actors_from_ids hook
None
TIL Using Codex CLI with gpt-oss:120b on an NVIDIA DGX Spark via Tailscale — I've written about the [DGX Spark](https://simonwillison.net/2025/Oct/14/nvidia-dgx-spark/) before. Here's how I got OpenAI's Codex CLI to run on my Mac against a gpt-oss:120b model running on the DGX Spark via a Tailscale network.
Release datasette-checkbox 0.1a4 — Add interactive checkboxes to columns in Datasette
Release datasette-enrichments 0.6a0 — Tools for running enrichments against data stored in Datasette
Release datasette 1.0a21 — An open source multi-tool for exploring and publishing data
Release datasette 0.65.2 — An open source multi-tool for exploring and publishing data
Research SQLite Query Linter — The SQLite Query Linter is a lightweight Python library that wraps the standard `sqlite3` module to provide configurable linting and rule-based analysis of SQL queries before execution. Acting as a drop-in replacement, it helps catch common syntax errors and platform incompatibilities—such as invalid types in `CAST`, use of unsupported functions, `SELECT *`, missing `WHERE` clauses, and string quoting mistakes—helping developers avoid runtime errors and improve code quality.
Research H3 Library Performance Benchmark — A systematic performance benchmark was conducted on two prominent Python libraries implementing Uber's H3 geospatial indexing system: h3-py (official, C-based) and h3o-python (Rust-based). Results show h3o-python consistently outperforms h3-py on core operations, achieving over 2x speedup for coordinate conversions and up to 13x faster neighbor queries, while area calculations remain comparable.
Release datasette-acl 0.5a0 — Advanced permission management for Datasette
Release datasette-allow-permissions-debug 0.2a0 — Always allow access to /-/permissions, for debugging