Prefer STRICT tables in SQLite
- In short: I prefer strict tables in SQLite because they avoid some datatype problems, such as putting text in number columns.
- SQLite has a feature that I think is underrated: strict tables.
- Strict tables help enforce rigid typing, preventing mistakes like putting text into integer columns.
Unverified
- In short: I prefer strict tables in SQLite because they avoid some datatype problems, such as putting text in number columns.
- SQLite has a feature that I think is underrated: strict tables.
- Strict tables help enforce rigid typing, preventing mistakes like putting text into integer columns.
Sources: Evanhahn