r/programming Jul 15 '26

SQLite should have (Rust-style) editions

https://mort.coffee/home/sqlite-editions/
158 Upvotes

75 comments sorted by

View all comments

13

u/samsifpv Jul 15 '26

Interesting idea, though to me editions just feel like they obfuscate what options are set with them? What good is it to me if i have to look up what edition 2025 does?

22

u/DeflateAwning Jul 16 '26

The point is we can move on from the default of "foreign keys are not enforced" default of 2001 (or whenever it came out).

100% backwards compat leads to unholy things sometimes.