Prefer STRICT tables in SQLite
SQLite's strict tables enforce rigid typing, preventing type mismatches like inserting text into integer columns and rejecting bogus column types. Flexible typing is still available via the ANY type. Downsides include inability to alter existing tables to strict, requirement for SQLite 3.37.0+, and slight theoretical overhead.