#SQLite
9 related articles
Python SQLite in Practice: Connections, Cursors, and Commits via the Bank Model
Using a bank teller analogy, this article explains the six-step process of Python SQLite operations: connect, cursor, execute, fetch, commit, close. It covers common pitfalls like in-memory databases disappearing, forgetting to commit causing silent data loss, and execute running only one statement, plus the differences between SQLite shell dot commands and MySQL/PostgreSQL dialects.
Twelve Years in the Making: Practical …
Twelve Years in the Making: Practical Lessons from Distributed SQLite
Philip O'Toole reflects on twelve years of distributed SQLite, sharing rqlite's architectural evolution, production lessons, and distributed database design insights.
APSW: The Underrated Advanced Python SQLite Wrapper
APSW (Another Python SQLite Wrapper) fully exposes SQLite's C API to Python. Learn how it differs from sqlite3, when to use it, and whether it fits your project.
Capsule: Pack Web Apps and Data into a Single SQLite File
Capsule is a Rust/Tauri 2.0 tool that packs HTML web apps and data into a single SQLite file — privacy-first, local storage, portable sharing, with AI support.
github-to-sqlite 2.9.1 Released: Fixes sqlite-utils 4.x Compatibility
github-to-sqlite 2.9.1 fixes compatibility with sqlite-utils 4.x. Learn what changed, why it matters for Datasette-based data pipelines, and how to upgrade.
Industry InsightsSQLite Releases AGENTS.md: Explicitly Rejecting AI-Generated Code and Opening a Dedicated Bug Forum
SQLite adds AGENTS.md explicitly rejecting AI-generated code and opens a dedicated Bug forum to handle the flood of AI bug reports. A look at its AI governance strategy.
Tech FrontiersLLM 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.
Tech FrontiersDatasette 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.
Expert OpinionsReinventing 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.