#Python SQLite
126 related articles
Tutorials·2 min
Simon Willison Built a Wildlife Sightings Feature for His Blog Using Claude Code on His Phone
Simon Willison used Claude Code for web on his phone to aggregate a decade of iNaturalist wildlife data into his blog. A look at the architecture, Beats system, and how AI is reshaping dev workflows.
Read more →
Tutorials·3 min
Phone + Claude Code: Building an iNaturalist Observation Display Tool While Camping
Simon Willison built a complete iNaturalist observation display tool using only his phone and Claude Code while camping. A breakdown of the three-layer architecture: Python CLI, Git Scraping automation, and pure frontend display.
Read more →
Tutorials·2 min
Building an iNaturalist Observation Display Tool Entirely on a Phone with Claude Code
Simon Willison built an iNaturalist observation display tool on his phone while camping using Claude Code, Git Scraping, and GitHub Actions with zero servers.
Read more →
Tech Frontiers·2 min
LLM 0.32 Refactoring Deep Dive: Message Sequence Input and Streaming Multi-Type Response Design
Deep dive into LLM 0.32 alpha's two core refactorings: message sequence API aligned with OpenAI format, stream_events for typed streaming responses, serialization design, and backward compatibility.
Read more →
Tutorials·3 min
Phone + Claude Code: Building an iNaturalist Observation Tool with Zero Servers — Full Workflow
Simon Willison built a complete iNaturalist observation tool during camping using his phone and Claude Code. A deep dive into the three-layer architecture: Python CLI, Git Scraping, and AI-generated frontend — all on GitHub with zero servers.
Read more →
Product Reviews·3 min
Simon Willison's Complete Process of Building an iNaturalist Observation Gallery with Phone + Claude Code
Simon Willison built an iNaturalist observation gallery using only his phone and Claude Code while camping. A breakdown of the three-layer architecture: Python CLI clustering, Git Scraping automation, and AI-generated frontend.
Read more →
Tech Frontiers·2 min
LLM CLI 0.32a1 Released: Fixes Tool-Calling Session Storage Bug
Simon Willison's open-source CLI tool LLM releases v0.32a1, fixing a data integrity issue when restoring tool-calling sessions from SQLite. Learn about the fix, core features, and how to update.
Read more →
Deep Dives·3 min
LLM 0.32 Refactor: How Message Sequences and Streaming Chunks Are Reshaping Python LLM Interactions
Simon Willison releases LLM 0.32a0 alpha with message sequences and typed streaming chunks, redefining how Python developers interact with LLMs while maintaining full backward compatibility.
Read more →
Tech Frontiers·2 min
Datasette 1.0a29 Released: Fixing a Gnarly Segfault Race Condition with GPT-5.5
Datasette 1.0a29 preview released, fixing a segfault race condition introduced by test optimization. Developer Simon Willison used GPT-5.5 xhigh to help reproduce the issue, showcasing AI debugging in practice.
Read more →
Tutorials·3 min
Using LLMs as Script Interpreters: Shebang Lines Turn Natural Language into Executable Scripts
Simon Willison shows how putting LLM CLI tools in shebang lines turns plain English text files into executable scripts, from basic usage to tool calls and YAML templates.
Read more →
Expert Opinions·3 min
Reinventing the Wheel: Why Building From Scratch Is the Shortcut to the Technical Frontier
Developer Andrew Quinn compressed a 3GB SQLite database into a 7MB FST file, sharing a profound insight: reinventing four or five wheels by hand beats passive study at pushing you to the technical frontier.
Read more →
Product Reviews·3 min
Datus-agent: An AI-Native CLI Tool Reshaping Data Engineering with Context Engineering
Deep dive into Datus-agent, an open-source AI-native CLI SQL client that brings Context Engineering to data engineering with natural language queries and modern data stack support.
Read more →
Product Reviews·3 min
Dash Open-Source Data Agent: 6-Layer Context Anchoring + Self-Learning That Gets Smarter with Use
Deep dive into Dash by agno-agi: a self-learning data agent built on systems engineering principles, featuring 6-layer context anchoring and query-driven continuous evolution.
Read more →
Tech Frontiers·1 min
LLM 0.32a1 Released: Fixes Critical Bug Where Tool-Calling Conversations Failed to Restore from SQLite
Simon Willison releases LLM CLI tool v0.32a1, fixing a critical bug where tool-calling conversations failed to restore from SQLite. Details on the fix and installation.
Read more →
Tech Frontiers·2 min
LLM CLI Tool 0.32a0 Released: One Interface to Call All Large Language Models
Simon Willison releases LLM 0.32a0 preview—an open-source CLI tool that calls GPT-4, Claude, Gemini, and more through a unified interface with plugins.
Read more →
Tech Frontiers·1 min
LLM CLI Tool 0.32a1 Released: Fixes Tool-Calling Conversation Storage Bug
Simon Willison releases LLM CLI tool 0.32a1 preview, fixing a critical bug where tool-calling conversations failed to restore from SQLite. Learn about the update and installation.
Read more →
Tutorials·3 min
Building an iNaturalist Observation Display Tool Over a Weekend with a Phone + Claude Code: Full Workflow
Simon Willison built an iNaturalist observation display tool from scratch using his phone and Claude Code while camping. Full breakdown of the three-layer data pipeline architecture and AI-assisted mobile development workflow.
Read more →
Expert Opinions·2 min
The Vibe Coding Era: Why We Need RSS to Distribute Personal AI Apps
As vibe coding makes app development as frequent as blogging, we need lightweight mechanisms like RSS to discover and share personal AI tools. Exploring the future infrastructure of AI app distribution.
Read more →
Tech Frontiers·2 min
LLM 0.32a0 Released: Message Sequences and Typed Streaming Refactor Explained
Simon Willison releases LLM 0.32a0 alpha with message sequence modeling and typed streaming parts, supporting multimodal output and conversation history injection while maintaining backward compatibility.
Read more →
Product Reviews·2 min
Building an iNaturalist Observation Tool Entirely on a Phone with Claude Code
Simon Willison built an iNaturalist observation display tool entirely on his phone with Claude Code while camping, using Git Scraping + GitHub Actions for a zero-cost serverless architecture.
Read more →