#SQLite STRICT tables
7 related articles
·3 min
SQLite STRICT Tables Explained: The Type Enforcement Debate and Best Practices
Deep dive into SQLite STRICT tables: is flexible typing a feature or flaw? Covers the author's stance, type vs. validation debate, Turso alternatives, and best practices for type-safe database design.
Read more →
·4 min
Self-Contained Portable Python Distributions: Saying Goodbye to Environment Configuration Nightmares
Deep dive into self-contained portable Python distributions: how python-build-standalone uses static linking and path relocation for zero-dependency deployment, and how modern tools like uv leverage this technology.
Read more →
·4 min
The Cursor Swarm Experiment: What AI Rebuilding SQLite from Scratch in Rust Reveals About Cost
Cursor's swarm experiment had AI teams implement a SQLite engine in Rust from scratch using only 835 pages of docs. All-frontier models cost $10K+, hybrid role division just $1.3K—a 7.9x gap.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows via Python, type overrides to solve ZIP-code leading-zero loss, STRICT table mode switching, drop-index, and more. A deep dive into the design and AI-assisted dev workflow.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows with Python, field type overrides fixing leading-zero ZIP codes, STRICT table mode switching, drop-index, and more. A deep dive into each design and the AI-assisted dev workflow.
Read more →
sqlite-utils 4.1.1: Fix for Silent Dat…
·2 min
sqlite-utils 4.1.1: Fix for Silent Data Loss Risk in Foreign Key Transactions
sqlite-utils 4.1.1 fixes a silent data loss risk in table.transform() caused by foreign key cascade actions inside transactions, introducing a TransactionError fail-fast mechanism.
Read more →
