Interview with a Fly.io developer discussing her work on Corrosion, a distributed SQLite replication system, and other infrastructure projects.
A workshop handout on using AI coding agents like Claude Code and OpenAI Codex for data analysis, visualization, and cleaning tasks.
A workshop handout on using AI coding agents like Claude Code and OpenAI Codex for data analysis, visualization, and cleaning tasks.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to test production query plans without moving large datasets.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to replicate production query plans in dev environments.
Introduces cysqlite, a new SQLite driver for Python written in Cython, with improved transaction handling and WASM support for Pyodide.
Introducing cysqlite, a new SQLite driver for Python written in Cython, with improved transaction handling and WASM support.
OpenAI releases Codex, a new macOS app for its AI coding agent, featuring Skills, Automations, and insights into its growing developer usage.
OpenAI releases a new macOS app for its Codex coding agent, featuring a UI, Skills support, and scheduled Automations.
Explains SQLite's selective contribution process and the required public domain copyright release, with a query showing contributor stats.
An interview about Canada Spends, a project using Datasette, SQLite, and LLMs to make Canadian government financial data accessible and explorable.
Announcing sqlite-utils 4.0a1, a Python library and CLI for SQLite, detailing minor backwards incompatible changes before the stable release.
Explores building a basic Durable Execution engine using SQLite and Java to reliably persist and resume multi-step workflows, like those in agentic systems.
Explores building a basic Durable Execution engine in Java using SQLite to persist workflow state and resume from failures.
A developer explains his automated workflow using SQL, Datasette, and Observable to generate a Substack newsletter from his blog content.
Datasette 1.0a20 introduces a major SQL-powered permissions system overhaul, replacing function calls with SQL queries for efficient access control.
A developer advises caution with Litestream 0.5.0 due to migration bugs, recommending users wait for a more stable release.
A detailed comparison of Django ORM features across PostgreSQL, SQLite, MariaDB, MySQL, and Oracle databases, highlighting support and limitations.
A developer's walkthrough of diagnosing and fixing a .NET Core native library loading error for SQLite on Alpine Linux.
Introduces fastmigrate, a simple Python tool for managing SQLite database migrations without requiring a specific ORM.
