Simon Willison

I wonder if this works for all of the other hooks using that pattern as well? Need comprehensive tests to prove it before I document this.

I'm torn on what to call the option, since `--functions` already means "these Python functions will be turned into SQL custom functions". Maybe this: ```bash sqlite-utils insert data.db creatures --code...

Could call it `--python` instead of `--code`. Might be a little bit more clear.

The problem with this one: ```bash sqlite-utils insert data.db --code ' def creatures(): yield {"id": 1, "name": "Cleo"} yield {"id": 2, "name": "Suna"} def foods(): yield "id", "name" yield 1,...

I told Claude with its [new code environment](https://simonwillison.net/2025/Sep/9/claude-code-interpreter/): > `Use your code environment. Run "git clone https://github.com/simonw/datasette-lite" and then edit the code such that it can handle CSV that uses...

I'm not doing this as part of https://github.com/simonw/datasette/milestone/34

Relevant code: https://github.com/nomic-ai/gpt4all/blob/60627bd41f49c5363c7e2abecc9b3be6ce59570f/gpt4all-bindings/python/gpt4all/gpt4all.py#L16

It looks like the desktop app stores models here: ~/Library/Application Support/nomic.ai/GPT4All/

Yeah a library that behaves differently if you have a desktop app installed is a little bit strange. Maybe the library could take a list of search paths for models?...

I can do that using this: ```bash git-history file counts.db instances.json \ --convert "return [ { 'id': 'all', 'users': sum(d['users'] or 0 for d in json.loads(content)), 'statuses': sum(int(d['statuses'] or 0)...