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.
Exploration of DuckDB and DuckLake as lightweight analytics tools, comparing them to traditional data lake architectures.
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.
A technical guide on extracting and exporting book highlights from Kobo eReaders by accessing the hidden SQLite database and using Python.
Explores Django 5.0's new GeneratedField feature for database-calculated columns, with a focus on implementation using SQLite.
Explores the necessity of disposing .NET database connections, commands, and readers, examining the internal behavior of Microsoft.Data.Sqlite types.
Benchmarking Go database drivers for SQLite and PostgreSQL on insert-heavy workloads, showing performance differences between popular and alternative drivers.
