SQLite Forum

about "strict" mode
Login
I think I like the way this is being introduced. Just a table modifier at creation time, that only introduces strict typing for fields with types other than "Any"

Since it does not have to deal with other issues like single vs double quoted strings or globally handling strict mode for the whole connection/db as others here are requesting, it can be tested and verified faster and can be released much sooner, with the opportunity for it to be improved upon (more data types) and for a global strict mode to still be viable in the future.

Keep up the great work!