alt Hacker News> The downside of strict tables is that some data types are not available, such as Date.
There are only 5 datatypes in sqlite. INTEGER, TEXT, BLOB, REAL, and NUMERIC.
Replies
ncruces • today at 8:18 PM
The downside is that you loose the place to store the metadata that a column is supposed to store a date.
Which is why I prefer not to use them.
masklinn • today at 7:45 PM
numeric is not a type it’s an affinity, the underlying types are real and integer. That is why numeric is not valid on strict tables.
Right, and that's the problem. There should be DATE and BOOL as well, especially in strict mode.