Learn how to prevent silent database value truncation in ColdFusion by adding boot-time assertions in Application.cfc for MySQL datasources.
An overview of Neo4j graph database, covering installation, Cypher query language, and basic commands for beginners.
sqlite-utils 4.2 release: Python CLI/library for SQLite, enhancing table.transform() with better schema preservation and new introspection features.
Mark Seemann argues that with LLMs writing code, ORMs may be unnecessary, suggesting direct SQL queries as a better alternative.
Comparison of SQLite prototypes for storing compressed text revision histories using whole-blob vs chunked compression strategies.
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.
