SQLite Forum

about "strict" mode
> I use "DOUBLE" instead of REAL. Is there any chance this will be accepted?

Someday, maybe, if a good case is made for the extra code and doc complexity. Consider, though, that there is no logical end to the growth of type identifiers.

> ...Old notes to self...

I don't see a question there, or much relevance to a posed question.

> Will there be a performance advantage using PRAGMA strict=ON;?

Compared to what? Not in most cases. Compared to additional column constraints that have the same effect, probably, but that's for measuring.