2 ms·
Here's quote: "In retrospect, perhaps it would have been better if SQLite had merely implemented an ANY datatype so that developers could explicitly state when
by vbezhenar 5y ago
Here's quote: "In retrospect, perhaps it would have been better if SQLite had merely implemented an ANY datatype so that developers could explicitly state when they wanted to use flexible typing, rather than making flexible typing the default. But that is not something that can be changed now without breaking the millions of applications and trillions of database files that already use SQLite's flexible typing feature."
For me it means that SQLite developers admit it was a mistake and should have been implemented differently.
I don't understand why this mistake can't be corrected now, with some opt-in "strict types" pragma, but whatever.