Re:Modern SQLite: Features You Didn't Know It Had
by fushihara on Thursday April 02, 2026 @09:31PM
(#47622335)
I wish SQLite would add a bool type and proper date/time types. Is there really no plan to add them?
For bool, it could just be an alias of a numeric type.
Something equivalent to number check(col = 0 or col = 1) would be perfectly fine.
Date/time handling is pretty weak.
Having to store values as GMT text is just inconvenient.
When retrieving values in Node.js, I ended up using new Date(val), which caused the classic bug where a GMT-stored value gets interpreted in the local timezone.
The correct approach was new Date(val + ".Z"), but I really don’t want to deal with that kind of hassle anymore.
For bool, it could just be an alias of a numeric type. Something equivalent to number check(col = 0 or col = 1) would be perfectly fine.
Date/time handling is pretty weak. Having to store values as GMT text is just inconvenient.
When retrieving values in Node.js, I ended up using new Date(val), which caused the classic bug where a GMT-stored value gets interpreted in the local timezone.
The correct approach was new Date(val + ".Z"), but I really don’t want to deal with that kind of hassle anymore.