A quote from D. Richard Hipp about how SQL replaced COBOL programmers for data queries, changing programming jobs.
A fun SQL Server quiz called 'Well, Actually…' to test database knowledge, built as a free WordPress plugin.
Explains database page splits with animations, their impact on writes and disk order, and historical context with hard drives.
An animated explanation of how SQL Server index seeks work, covering B-tree root pages, intermediate pages, and leaf pages.
Lobste.rs migrated from MariaDB to SQLite, improving performance and reducing costs.
Lobste.rs migrates from MariaDB to SQLite, achieving lower CPU/memory usage and reduced costs.
Release notes for sqlite-utils 4.1.1, a Python CLI and library for SQLite, fixing a foreign key transaction edge case.
sqlite-utils 4.1.1 release fixes foreign key edge case in table.transform() and improves documentation cross-references.
A personal recap of Data Saturday Rheinland 2026, covering PostgreSQL, SQL Server, GenAI, and data literacy sessions.
sqlite-utils 4.1 release: new CLI features like --code for inserts, --type for column types, drop-index command, strict mode support, and more.
sqlite-utils 4.1 release adds --code option, --type flag, strict mode support, and other minor features for SQLite manipulation.
Explores multi-tenancy in SaaS beyond databases, focusing on isolation through boundaries like compute, deployments, and schema changes.
Announcement of sqlite-migrate 0.2, a simple database migration system for SQLite based on sqlite-utils.
sqlite-utils 4.0rc3 release adds compound foreign key support and case-insensitive column name handling.
Roundup of T-SQL Tuesday #199 blog party discussing the challenges and considerations of moving back to on-premises from cloud computing.
A talk exploring PostgreSQL generated columns by example, covering virtual vs stored behavior, performance trade-offs, and Django integration.
Guide to creating Azure HorizonDB clusters, compute scaling, graph DB, and AI pipelines in Microsoft's new PostgreSQL-based data platform.
A blog post listing database job opportunities for June 2026, with rules for employers to post positions and links to related hiring posts.
Talk at PyCon Italia 2026 on Django's GeneratedField, covering practical examples, trade-offs, and evolution from Django 5.0 to 6.0.
Solutions to SQLAlchemy 2 exercises covering database queries, relationships, and async features.
