Introducing cysqlite, a new SQLite driver for Python written in Cython, with improved transaction handling and WASM support.
Introduces cysqlite, a new SQLite driver for Python written in Cython, with improved transaction handling and WASM support for Pyodide.
OpenAI releases a new macOS app for its Codex coding agent, featuring a UI, Skills support, and scheduled Automations.
OpenAI releases Codex, a new macOS app for its AI coding agent, featuring Skills, Automations, and insights into its growing developer usage.
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.
A developer shares their process of optimizing SQLite database configuration for their SaaS application after migrating from Postgres.
A developer documents migrating a SaaS app to DigitalOcean using Kamal, detailing network issues and Docker setup.
The author details migrating a Django SaaS app's database from Heroku's Postgres to SQLite as part of a move to DigitalOcean.
A developer continues migrating a SaaS app from Heroku to DigitalOcean, focusing on secrets with 1Password and creating a hosting droplet.
The author explains why they created a new 'Today I Learned' (TIL) section on their blog to archive useful tools and facts.
