[Pako]

SQLite has a solution for this! There's called strict tables and final SQLite to get mad at you when you try to put a string into a number column, etc.

https://www.sqlite.org/stricttables.html

[dbrgn]

Oh wow! Thanks a lot for this link, I wasn't aware of that.