| Prefer strict tables in SQLite(evanhahn.com) | |
| 308 points by ingve 18 hours ago | 156 comments | |
tl;dr: SQLite's STRICT tables (added in 3.37.0) enforce rigid column typing, rejecting mismatched types on insert/update and disallowing bogus column types like DATETIME or JSON at table creation. The main downsides: you can't easily convert existing tables to strict, older SQLite versions can't read databases containing them, and the SQLite developers themselves argue flexible typing is a feature. Use ANY as the column type when you genuinely need flexibility within a strict table. | |
HN Discussion:
| |