--- title: SQLite should have (Rust-style) editions | daily.dev description: SQLite has several problematic defaults that can cause real-world bugs: foreign key constraints are ignored by default, columns accept wrong data types due to... canonical: https://daily.dev/posts/sqlite-should-have-rust-style-editions-gbz3t7szn twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: SQLite should have (Rust-style) editions | daily.dev og:description: SQLite has several problematic defaults that can cause real-world bugs: foreign key constraints are ignored by default, columns accept wrong data types due to... og:url: https://daily.dev/posts/sqlite-should-have-rust-style-editions-gbz3t7szn og:image: https://api.daily.dev/og/posts/gBz3t7SZN.png og:image:alt: SQLite should have (Rust-style) editions og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # SQLite should have (Rust-style) editions **[Lobsters](https://daily.dev/sources/lobsters)** · 11 min read · 0 upvotes · 0 comments ## Summary SQLite has several problematic defaults that can cause real-world bugs: foreign key constraints are ignored by default, columns accept wrong data types due to flexible typing, concurrent writers immediately get SQLITE_BUSY errors instead of waiting, and WAL mode is disabled hurting performance. Each issue has a pragma fix, but users must know to apply them. The author proposes borrowing Rust's edition system to bundle these fixes into a single 'PRAGMA edition = 2026' that enables sane defaults without breaking backwards compatibility for existing software. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### Are foreign key constraints enabled by default in SQLite? No, foreign key constraints are ignored by default in SQLite, unlike most other relational databases. This means you can delete a referenced row without error, and because SQLite reuses ROWID values, a new row can silently inherit stale references from deleted rows. To enforce constraints, run PRAGMA foreign_keys = ON for each connection. _Developers hardening SQLite schemas can find configuration pitfalls like this one on daily.dev._ ### Why do I get SQLITE_BUSY errors when writing to SQLite from multiple processes? By default, SQLite only allows one writer at a time, and if two writers contend for the lock simultaneously, one immediately receives an SQLITE_BUSY error instead of waiting. Setting PRAGMA busy_timeout = 5000 makes SQLite retry acquiring the lock for up to 5 seconds before failing, which avoids unnecessary crashes from lock contention. _Anyone debugging flaky concurrent writes in sqlite can track fixes like this on daily.dev._ ### How do I make SQLite enforce column data types instead of allowing any value to be stored? Add the strict keyword when creating a table, for example CREATE TABLE music (...) strict, which makes SQLite raise a runtime error when a value of the wrong type is inserted into a column. Without strict mode, SQLite uses flexible type affinity and can silently store a TEXT value in an INTEGER column. There is no global pragma to make all tables strict; it must be set per table. _Teams deciding on schema strictness in sqlite can compare tradeoffs like these on daily.dev._ ## Similar posts on daily.dev - [SQLite in Production: Optimizing WAL Mode, Concurrency, and VFS Layers for Low-Latency App Servers](https://daily.dev/posts/sqlite-in-production-optimizing-wal-mode-concurrency-and-vfs-layers-for-low-latency-app-servers-wedvue3es) · Hacker News · 0 upvotes · 0 comments - [SQLite Release 3.53.0 On 2026-04-09](https://daily.dev/posts/sqlite-release-3-53-0-on-2026-04-09-qfesmnxqk) · Lobsters · 0 upvotes · 0 comments - [Learning a few things about running SQLite](https://daily.dev/posts/learning-a-few-things-about-running-sqlite-lnbwnhclc) · Julia Evans · 2 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#rust](https://daily.dev/tags/rust), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/sqlite-should-have-rust-style-editions-gbz3t7szn) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"SQLite should have (Rust-style) editions","url":"https://daily.dev/posts/sqlite-should-have-rust-style-editions-gbz3t7szn","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/sqlite-should-have-rust-style-editions-gbz3t7szn"},"datePublished":"2026-07-15T21:05:37.929Z","dateModified":"2026-09-14T08:40:31.122Z","description":"SQLite has several problematic defaults that can cause real-world bugs: foreign key constraints are ignored by default, columns accept wrong data types due to...","image":"https://media.daily.dev/image/upload/s--VDukGCjf--/f_auto/v1722860399/public/Placeholder%2002","thumbnailUrl":"https://media.daily.dev/image/upload/s--VDukGCjf--/f_auto/v1722860399/public/Placeholder%2002","isAccessibleForFree":true,"articleSection":"Lobsters","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Lobsters","logo":"https://media.daily.dev/image/upload/s--tl8v_Fku--/f_auto,t_logo/v1698841318/logos/lobste.jpg","url":"https://daily.dev/sources/lobsters"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/sqlite-should-have-rust-style-editions-gbz3t7szn","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,rust,sqlite","timeRequired":"PT11M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Lobsters","item":"https://daily.dev/sources/lobsters"},{"@type":"ListItem","position":3,"name":"SQLite should have (Rust-style) editions"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/sqlite-should-have-rust-style-editions-gbz3t7szn#faq","mainEntity":[{"@type":"Question","name":"Are foreign key constraints enabled by default in SQLite?","acceptedAnswer":{"@type":"Answer","text":"No, foreign key constraints are ignored by default in SQLite, unlike most other relational databases. This means you can delete a referenced row without error, and because SQLite reuses ROWID values, a new row can silently inherit stale references from deleted rows. To enforce constraints, run PRAGMA foreign_keys = ON for each connection. Developers hardening SQLite schemas can find configuration pitfalls like this one on daily.dev."}},{"@type":"Question","name":"Why do I get SQLITE_BUSY errors when writing to SQLite from multiple processes?","acceptedAnswer":{"@type":"Answer","text":"By default, SQLite only allows one writer at a time, and if two writers contend for the lock simultaneously, one immediately receives an SQLITE_BUSY error instead of waiting. Setting PRAGMA busy_timeout = 5000 makes SQLite retry acquiring the lock for up to 5 seconds before failing, which avoids unnecessary crashes from lock contention. Anyone debugging flaky concurrent writes in sqlite can track fixes like this on daily.dev."}},{"@type":"Question","name":"How do I make SQLite enforce column data types instead of allowing any value to be stored?","acceptedAnswer":{"@type":"Answer","text":"Add the strict keyword when creating a table, for example CREATE TABLE music (...) strict, which makes SQLite raise a runtime error when a value of the wrong type is inserted into a column. Without strict mode, SQLite uses flexible type affinity and can silently store a TEXT value in an INTEGER column. There is no global pragma to make all tables strict; it must be set per table. Teams deciding on schema strictness in sqlite can compare tradeoffs like these on daily.dev."}}]} ```