SQLite Forum

about "strict" mode
Login
I don't understand what, if anything, you are disputing or questioning here. (It would help if you quoted the point(s) to which you are responding.)

Only a single representation of an INSERT value is stored. You can think of it as what is known as a [tagged union](https://en.wikipedia.org/wiki/Tagged_union) except the stored size varies along with the type and value.

As for "all these checks required", an insertion under STRICT is more restrictive than a traditional, plain SQLite insertion. Some extra branching will be involved. This has a performance impact, albeit not a big one. Yet, compared to effecting the same restriction with column constraints, the additional STRICT restriction will be relatively faster.

Now, unless your questions, disputations or puzzlements become more concrete and specific, I am going to beg off a continuation of this nebulosity.