3 ms·
> some data types are not available, such as Date. That’s not a type, you just get a numeric-affinity column.
by masklinn 3mo ago
> some data types are not available, such as Date.
That’s not a type, you just get a numeric-affinity column.
- petilon 3mo agoRight, and that's a serious limitation when in strict mode.
- masklinn 3mo agoThe serious limitation is that you create a column as date, you don’t understand what sqlite does with it, and you start storing strings in there, at which point everything is confused. You can use comments to preserve intent in strict mode, and that’s strictly more useful than fuzzy mode: it is richer, it is clearer, and it is no less reliable.