3 ms·
STRICT only works for simple types though as the article noted, so you can't do CREATE TABLE mytable ( id INTEGER PRIMARY KEY, created DATETIM
by SahAssar 2y ago
STRICT only works for simple types though as the article noted, so you can't do
CREATE TABLE mytable (
id INTEGER PRIMARY KEY,
created DATETIME,
mything JSON
) STRICT;
- c0wb0yc0d3r 2y agoThat's the point of STRICT isn't it? 2 of the 3 types in your SQL statement aren't valid sqlite data types.
- SahAssar 2y agoThe point is that they are types supported by most other sql databases and supported as input/output by sqlite functions, but you can't validate that stored data is the correct type.