Modern SQLite #1: STRICT Tables I'm starting a series of short notes about handy SQLite features you may not have heard about. And the first one is "strict" tables. As you probably know, SQLite's type system is very flexible (some people even call SQLite the JavaScript of databases) — you can store any value in any column type (e.g. create an INTEGER column and store text values there, or a REAL with blob values). Some people love SQLite for its flexibility, others hate it for the same reason. So at some point the SQLite authors introduced STRICT tables. They check types the same way other DBMS do (see the screenshot). Even with strict tables, you can still explicitly declare a column as ANY — such columns can hold values of any type. So you can have the best of both worlds — strict type checking and type flexibility. Available since SQLite 3.37 (Nov 2021).