Simon Willison simonw

Datasette Allow Block Matching - Pure SQLite Implementation

Overview

This prototype demonstrates how Datasette's permission checking logic (allow blocks) can be implemented entirely in SQLite using JSON functions, without requiring Python logic for the core matching algorithm.

The Problem

Datasette uses "allow blocks" to control permissions. An allow block is a JSON object that specifies which actors can perform an action:

Claude Code Devcontainer

A secure, isolated development environment for Claude Code with network restrictions and pre-configured development tools.

Overview

This devcontainer provides a sandboxed environment for Claude Code with:

Network firewall restrictions limiting outbound connections to approved domains
Pre-installed development tools (git, gh CLI, zsh, fzf)
VS Code extensions (Claude Code, ESLint, Prettier, GitLens)

What's new in the world of LLMs - March 2025 NICAR edition

https://simonwillison.net/2024/Dec/31/llms-in-2024/ is my in-depth review of 2024 in LLMs

https://llm.datasette.io/ is the CLI tool I’ve been building

I like https://github.com/taketwo/llm-ollama and https://ollama.com/ for running local models - my current favorite is https://ollama.com/library/mistral-small

https://simonwillison.net/tags/llms/ is my LLMs tag, but it has 963 items already so may take a while to dig through!

uv run --with pillow --with google-genai python -c '
import os
from google import genai
from google.genai import types
from io import BytesIO
from PIL import Image

GEMINI_API_KEY = os.environ["GEMINI_API_KEY"]

	╔═══════════════════════════════════════════════════════════════════════════╗
	║ ║
	║ 🎓 LLM PRE-TRAINING FROM SCRATCH - COMPLETE JOURNEY ║
	║ ║
	╚═══════════════════════════════════════════════════════════════════════════╝


	═══════════════════════════════════════════════════════════════════════════
	WHAT WE ACCOMPLISHED
	═══════════════════════════════════════════════════════════════════════════

	# /// script
	# requires-python = ">=3.12"
	# dependencies = [
	# "click",
	# ]
	# ///

	import os
	import json
	import re

	# /// script
	# requires-python = ">=3.10"
	# dependencies = [
	# "click",
	# "kokoro",
	# "misaki[en]",
	# "soundfile",
	# ]
	# ///
	import click

	# /// script
	# requires-python = ">=3.12"
	# dependencies = [
	# "pyobjc-core",
	# "pyobjc-framework-CoreLocation",
	# "click"
	# ]
	# ///
	"""Basic geocoding using CoreLocation on macOS."""

	# /// script
	# dependencies = [
	# "pyobjc-core",
	# "pyobjc-framework-CoreLocation"
	# ]
	# ///
	"""Get named timezone for a location on macOS using CoreLocation

	To use this script, you need to have pyobjc-core and pyobjc-framework-CoreLocation installed:

	{
	"id": "chatcmpl-AkvTd3qWivjaB4rHJUSMAu7UJRTsM",
	"object": "chat.completion",
	"created": 1735747393,
	"model": "gpt-4o-audio-preview-2024-12-17",
	"choices": [
	{
	"index": 0,
	"message": {