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.
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 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 tutorial on setting up a Next.js application with Prisma ORM and SQLite database, covering initial setup and migrations.
A developer details their journey to diagnose and fix a persistent memory leak in their production Node.js application after a database migration.
The author details their migration from a Postgres cluster to a distributed SQLite setup using LiteFS for their personal website.
A developer details debugging and fixing memory exhaustion bugs in their Golang file-sharing web app, PicoShare, using profiling tools.
A developer details the tech stack and architectural decisions behind the 2021 rewrite of their complex, feature-rich personal website.
How to use SQLite with Litestream for serverless data replication, eliminating database servers and reducing costs to $0.03/month.
Learn how Django uses models and migrations to store and manage data in a relational database.
