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 in Java using SQLite to persist workflow state and resume from failures.
Explores building a basic Durable Execution engine using SQLite and Java to reliably persist and resume multi-step workflows, like those in agentic systems.
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 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.
The article details the process of converting a Postgres database to SQLite as part of a cloud migration strategy for a SaaS project.
Exploring Go middleware, request context, and database usage with the standard library, continuing a series on building web apps.
A technical guide on extracting 2FA secrets from the abandoned Authenticator Plus iOS app using SQLCipher and Ruby.
A tutorial on setting up a Next.js application with Prisma ORM and SQLite database, covering initial setup and migrations.
Explores the necessity of disposing .NET database connections, commands, and readers, examining the internal behavior of Microsoft.Data.Sqlite types.
