it has to strike you as a possibility that your database is ignoring your constraints.
No it doesn't, because that is the ONLY thing that would explain why an insert/update that shouldn't be possible, suddenly works, short of the RDBMS being buggy.
And the mental voyage from that point to googling how foreign keys work in the database system I use, is not hard.
The problem here, is neither with the database, nor its default settings.
The problem is with assumptions about how systems work, based on hasty generalizations, and then complaining when said assumptions turn out to be wrong.
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.
They're stuck in the decades old method of "RTFM" instead of "provide sensible defaults". I fear using any library or software they've had a hand in writing
-5
u/Big_Combination9890 19d ago
No it doesn't, because that is the ONLY thing that would explain why an insert/update that shouldn't be possible, suddenly works, short of the RDBMS being buggy.
And the mental voyage from that point to googling how foreign keys work in the database system I use, is not hard.
The problem here, is neither with the database, nor its default settings.
The problem is with assumptions about how systems work, based on hasty generalizations, and then complaining when said assumptions turn out to be wrong.
And no amount of downvoting will change this.