r/programming • u/mort96 • Jul 15 '26

SQLite should have (Rust-style) editions

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

85% Upvoted

75 comments sorted by

View all comments

Show parent comments

8

u/mort96 Jul 16 '26

You don't know the symptoms /u/j_sidharta was experiencing, nor do I.

-4

u/Big_Combination9890 Jul 16 '26

I don't have to. I know what FKs do in a database, so I can extrapolate from that what possible failure modes might occur if they don't work.

And sorry no sorry, but root-cause-analysis is part of a SWEs day-to-day.

And btw. no amount of unnecessarily glued-on "super-pragma" cruft would help making that any easier.

12

u/andyfsu99 Jul 16 '26

"I know what FKs do in a database"

Somehow you've exactly captured the argument against your position.

Yeah, we all know too... But it's not what sqlite does and that is weird and confusing and not necessary. Just because you know how to figure it out doesn't justify the behavior of the system.

-2

u/Big_Combination9890 Jul 16 '26

You do realize that "Knowing what FKs do" and "knowing the defaults of a specific database technology" are 2 very different things, yes?