Search

Release: datasette 1.0a21

Fixes an open redirect security issue: Datasette instances would redirect to example.com/foo/bar if you accessed the path //example.com/foo/bar. Thanks to James Jefferies for the fix. (#2429) Fixed datasette publish cloudrun to work with changes to the underlying Cloud Run architecture. (#2511) New datasette --get /path --headers option for inspecting the headers returned by a path. (#2578) New d...

Released 2025-11-05T21:55:15Z

Release: datasette 0.65.2

Fixes an open redirect security issue: Datasette instances would redirect to example.com/foo/bar if you accessed the path //example.com/foo/bar. Thanks to James Jefferies for the fix. #2429 Upgraded for compatibility with Python 3.14. Fixed datasette publish cloudrun to work with changes to the underlying Cloud Run architecture. #2511 Minor upgrades to fix warnings, including pkg_resources deprec...

Released 2025-11-05T18:20:30Z

Datasette News: 2025-11-05

Datasette 0.65.2 and Datasette 1.0a21 have been released with a security fix for an open redirect error, see this advisory. The latest Datasette alphas also include a breaking change to Datasette's permission system, described in detail in A new SQL-powered permissions system in Datasette 1.0a20.

Blog: A new SQL-powered permissions system in Datasette 1.0a20

Datasette 1.0a20 is out with the biggest breaking API change on the road to 1.0, improving how Datasette's permissions system works by migrating permission logic to SQL running in SQLite. This release involved 163 commits, with 10,660 additions and 1,825 deletions, most of which was written with the help of Claude Code. Understanding the permissions system Permissions systems need to be abl...

Published 2025-11-04T21:34:42+00:00

Release: datasette-events-forward 0.1a3

Upgraded for compatibility with Datasette 1.0a20.

Released 2025-11-04T02:47:49Z

Release: datasette-tail 0.1a2

Upgraded for compatibility with Datasette 1.0a20.

Released 2025-11-04T01:34:03Z

Release: datasette-search-all 1.1.5a0

Upgraded for compatibility with Datasette 1.0a20. #22

Released 2025-11-03T23:44:33Z

Release: datasette 1.0a20

This alpha introduces a major breaking change prior to the 1.0 release of Datasette concerning how Datasette's permission system works. Permission system redesign Previously the permission system worked using datasette.permission_allowed() checks which consulted all available plugins in turn to determine whether a given actor was allowed to perform a given action on a given resource. This approach...

Released 2025-11-03T22:50:28Z

Release: datasette-pretty-traces 0.6

Add total request time, total SQL time and number of SQL queries to trace display. #9

Released 2025-10-24T17:24:03Z

Release: datasette-events-forward 0.1a2

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T22:28:19Z

Release: datasette-visible-internal-db 0.1.1a1

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T21:48:39Z

Release: datasette-create-view 0.1a1

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T21:40:05Z

Release: datasette-write-ui 0.0.1a13

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T21:22:19Z

Release: datasette-plot 0.1.0a1

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:54:13Z

Release: datasette-import 0.1a6

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:46:08Z

Release: datasette-public 0.3a4

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:44:28Z

Release: datasette-events-db 0.1a1

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:44:28Z

Release: datasette-edit-schema 0.8a4

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:44:27Z

Release: datasette-query-assistant 0.1a4

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:44:26Z

Release: datasette-extract 0.1a11

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:44:23Z

Release: datasette-checkbox 0.1a3

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:44:19Z

Release: datasette-column-sum 0.1a1

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T20:44:07Z

Release: datasette-tail 0.1a1

Pin to datasette==1.0a19. datasette/#2516

Released 2025-10-21T15:10:09Z

Blog: Claude can write complete Datasette plugins now

This isn't necessarily surprising, but it's worth noting anyway. Claude Sonnet 4.5 is capable of building a full Datasette plugin now. I've seen models complete aspects of this in the past, but today is the first time I've shipped a new plugin where every line of code and test was written by Claude, with minimal prompting from myself. The plugin is called datasette-os-info. It's a simple debugging...

Published 2025-10-08T23:43:43+00:00

Blog: Bad bots

Two of my public Datasette instances - for my TILs and my blog's backup mirror - were getting hammered with misbehaving bot traffic today. Scaling them up to more Fly instances got them running again but I'd rather not pay extra just so bots can crawl me harder. The log files showed the main problem was facets: Datasette provides these by default on the table page, but they can be combined in ways...

Published 2025-10-06T00:56:24+00:00

Blog: llm-openrouter 0.5

llm-openrouter 0.5 New release of my LLM plugin for accessing models made available via OpenRouter. The release notes in full: Support for tool calling. Thanks, James Sanford. #43 Support for reasoning options, for example llm -m openrouter/openai/gpt-5 'prove dogs exist' -o reasoning_effort medium. #45 Tool calling is a really big deal, as it means you can now use the plugin to try out tools ...

Published 2025-09-21T00:24:05+00:00

Release: llm 0.27.1

llm chat -t template now correctly loads any tools that are included in that template. #1239 Fixed a bug where llm -m gpt5 -o reasoning_effort minimal --save gm saved a template containing invalid YAML. #1237 Fixed a bug where running llm chat -t template could cause prompts to be duplicated. #1240 Less confusing error message if a requested toolbox class is unavailable. #1238

Released 2025-08-12T05:15:53Z

Blog: LLM 0.27, the annotated release notes: GPT-5 and improved tool calling

I shipped LLM 0.27 today (followed by a 0.27.1 with minor bug fixes), adding support for the new GPT-5 family of models from OpenAI plus a flurry of improvements to the tool calling features introduced in LLM 0.26. Here are the annotated release notes. GPT-5 New models: gpt-5, gpt-5-mini and gpt-5-nano. #1229 I would have liked to get these out sooner, but LLM had accumulated quite a lot of o...

Published 2025-08-11T23:57:50+00:00

Release: llm 0.27

This release adds support for the new GPT-5 family of models from OpenAI. It also enhances tool calling in a number of ways, including allowing templates to bundle pre-configured tools. New features New models: gpt-5, gpt-5-mini and gpt-5-nano. #1229 LLM templates can now include a list of tools. These can be named tools from plugins or arbitrary Python function blocks, see Tools in templates. #1...

Released 2025-08-11T21:31:49Z

Release: datasette-public 0.3a3

Ability to make canned queries public or private. #14

Released 2025-07-22T15:38:46Z

Blog: Datasette Public Office Hours: Tools in LLM

We're hosting the sixth in our series of Datasette Public Office Hours livestream sessions this Friday, 6th of June at 2pm PST (here's that time in your location). The topic is going to be tool support in LLM, as introduced here. I'll be walking through the new features, and we're also inviting five minute lightning demos from community members who are doing fun things with the new capabilities. I...

Published 2025-06-03T19:42:35+00:00

Blog: Saying Bye to Glitch

Saying Bye to Glitch Pirijan, co-creator of Glitch - who stopped working on it six years ago, so has the benefit of distance: Here lies Glitch, a place on the web you could go to write up a website or a node.js server that would be hosted and updated as you type. 🥀 RIP 2015 – 2025. Pirijan continues with a poignant retrospective about Glitch's early origins at Fog Greek with the vision of provid...

Published 2025-05-29T20:36:06+00:00

Release: llm 0.26

Tool support is finally here! This release adds support exposing tools to LLMs, previously described in the release notes for 0.26a0 and 0.26a1. Read Large Language Models can run tools in your terminal with LLM 0.26 for a detailed overview of the new features. Also in this release: Two new default tools: llm_version() and llm_time(). #1096, #1103 Documentation on how to add tool supports to a mo...

Released 2025-05-27T20:34:28Z

Release: llm 0.26a1

Hopefully the last alpha before a stable release that includes tool support. Features Plugin-provided tools can now be grouped into "Toolboxes". Toolboxes (llm.Toolbox classes) allow plugins to expose multiple related tools that share state or configuration, enhancing modularity and reusability (e.g., a Memory tool or Filesystem tool). (#1059, #1086) Tool support for llm chat. The llm chat comm...

Released 2025-05-26T06:11:10Z

Blog: Datasette ecosystem poster for PyCon US

In addition to my workshop the other day I'm also participating in the poster session at PyCon US this year. This means that tomorrow (Sunday 18th May) I'll be hanging out next to my poster from 10am to 1pm in Hall A talking to people about my various projects. I'll confess: I didn't pay close enough attention to the poster information, so when I first put my poster up it looked a little small: ....

Published 2025-05-17T20:34:39+00:00

Blog: django-simple-deploy

django-simple-deploy Eric Matthes presented a lightning talk about this project at PyCon US this morning. "Django has a deploy command now". You can run it like this: pip install django-simple-deploy[fly_io] # Add django_simple_deploy to INSTALLED_APPS. python manage.py deploy --automate-all It's plugin-based (inspired by Datasette!) and the project has stable plugins for three hosting platforms:...

Published 2025-05-17T12:49:52+00:00

Release: llm 0.26a0

This is the first alpha to introduce support for tools! Models with tool capability (which includes the default OpenAI model family) can now be granted access to execute Python functions as part of responding to a prompt. Tools are supported by the command-line interface: bash llm --functions ' def multiply(x: int, y: int) -> int: """Multiply two numbers.""" return x * y ' 'what is 34234 * 2...

Released 2025-05-14T00:39:04Z

Release: datasette-chronicle 0.3

New trigger design, using sqlite-chronicle 0.4. #4 Existing chronicle tables are automatically upgraded to the new design, maintaining version and timestamp data. Now uses the text "Enable row version tracking for this table" in the UI. #5

Released 2025-05-13T18:21:37Z

Release: sqlite-utils 4.0a0

Upsert operations now use SQLite's INSERT ... ON CONFLICT SET syntax on all SQLite versions later than 3.23.1. This is a very slight breaking change for apps that depend on the previous INSERT OR IGNORE followed by UPDATE behavior. (#652) Python library users can opt-in to the previous implementation by passing use_old_upsert=True to the Database() constructor, see Alternative upserts using INSER...

Released 2025-05-09T03:54:32Z

Release: datasette-enrichments 0.5.1

Fixed error about a missing table on server startup for some environments. #58

Released 2025-05-05T14:53:26Z