#SQLite test database
155 related articles
Tech Frontiers·2 min
datasette-llm 0.1a7 Released: Model Default Configuration Makes Data Enrichment More Controllable
datasette-llm 0.1a7 adds model default configuration, supporting preset temperature and other parameters for specific LLMs to standardize batch data enrichment.
Read more →
Tutorials·2 min
Simon Willison's Full Process of Building an iNaturalist Observation Tool with Phone + Claude Code
Simon Willison built a complete iNaturalist observation aggregation tool using only his phone and Claude Code while camping. A detailed look at the Python CLI, Git Scraping, and static frontend architecture.
Read more →
Product Reviews·6 min
Redis Array Data Type Explained: 18 New Commands and a WASM Online Playground
Redis creator antirez adds Array data type with 18 new commands including ARGREP regex search. Simon Willison built a WASM browser playground with Claude Code for zero-install experimentation.
Read more →
Tutorials·2 min
Simon Willison's Full Process of Fixing a Datasette Map Bug with GPT-5.5 + Codex
Datasette creator Simon Willison debugged an OpenStreetMap display issue, uncovering CAPTCHA and Referrer-Policy conflicts, then built a plugin fix using GPT-5.5 and Codex.
Read more →
Tutorials·4 min
inaturalist-clumper: A Guide to Automatic Clustering of iNaturalist Observation Data
A detailed guide to Simon Willison's open-source tool inaturalist-clumper 0.1, which automatically clusters iNaturalist observation records by time and location, outputting JSON for nature blogs, data visualization, and static site integration.
Read more →
Tech Frontiers·3 min
Simon Willison Builds a QR Code Generator with Claude: A Vibe-Coding Case Study
Simon Willison built a QR code generator with Claude AI, supporting URL text and WiFi QR code generation with style customization. A detailed look at this vibe-coding project's design and AI-assisted development insights.
Read more →
Product Reviews·4 min
Trae Solo vs Cursor Real-World Comparison: Which AI Coding Tool Builds a Better Student Management System?
Real-world comparison of Trae Solo vs Cursor building a Python Flask student management system, testing architecture design, code generation speed, runtime results, and practical recommendations.
Read more →
Product Reviews·3 min
Claude Code vs Cursor Real-World Comparison: Which Wins on an Elevator Simulator Project?
Real-world comparison of Claude Code and Cursor through an elevator scheduling simulator project — analyzing task planning, architecture understanding, code generation, and delivery quality.
Read more →
Tutorials·3 min
Codex Cache Cleanup Guide: A Hands-On Tutorial for Slimming Down the .codex Folder
Guide to cleaning OpenAI Codex's local .codex folder cache, including deleting conversations with community Python tools, cleaning logs.sqlite, and periodic archiving to slim from 17MB to 41KB.
Read more →
Product Reviews·3 min
Haiku 4.5 vs GPT-5 Mini vs GLM-4.6: Real-World Benchmark of Budget Coding Models
In-depth comparison of Claude Haiku 4.5, GPT-5 Mini, and GLM-4.6 across speed, cost, code quality, concurrency safety, and tool calling to help developers choose the right budget AI coding model.
Read more →
Tech Frontiers·2 min
Datasette Launches Official Blog: Simon Willison Built It from Scratch with OpenAI Codex
Datasette founder Simon Willison launches official blog built with OpenAI Codex Desktop, sharing full AI session transcripts and demonstrating transparent AI-assisted development practices.
Read more →
Tutorials·4 min
LangChain Agent in Practice: Building a Production-Grade AI Agent from Scratch
A comprehensive guide to building production-grade AI Agents with LangChain, covering architecture design, tools, memory systems, ReAct strategy, and enterprise deployment.
Read more →
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 →
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 →
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 →
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·1 min
LLM 0.32a1 Released: Detailed Fix for Tool-Calling Conversation Storage Bug
Simon Willison releases LLM CLI tool v0.32a1, fixing a critical bug where tool-calling conversations failed to reload from SQLite. Details on the fix and upgrade.
Read more →