|
|
|
|
|
by IshKebab
20 days ago
|
|
Yeah that doesn't make any sense at all. It sounds like a post-hoc justification to me. > If you find a real-world case where STRICT tables prevented or would have prevented a bug in an application, please post a message to the SQLite Forum so that we can add your story to this document. Kind of wild that they don't believe this happens. Also they totally drew the wrong conclusions from their example in Appendix A. The data type was CHECK'd for a column and they are like "oh if only we hadn't enforced checks of this data type, we would have had to verify it when we opened the database!" instead of "thank goodness we have this CHECK'd this data type, it means we are forced to robustly verify it in one place, instead of using unreliable checks in the application code". |
|