News for hackers. Stuff that matters.

A comment on SQLite Release 3.42.0. Parent comment

Re:SQLite Release 3.42.0 by Thaxll on Tuesday May 16, 2023 @11:23AM (#35963103)
You can remove JSON, when is SQLite adding proper date type?
[ Parent | on HN ]
Re:SQLite Release 3.42.0 by thunderbong on Tuesday May 16, 2023 @11:47AM (#35963479)
It's already available -

https://www.sqlite.org/stricttables.html

[ Parent | on HN ]
Re:SQLite Release 3.42.0 by pdimitar on Tuesday May 16, 2023 @02:34PM (#35965810)
Wrong, there's no datetime there. Only integer can be used for it in a more space-saving manner. But that means you have to convert and invoke calculation functions. It's error-prone.
[ Parent | on HN ]
Re:SQLite Release 3.42.0 by tracker1 on Tuesday May 16, 2023 @05:46PM (#35968192)
Isn't that what most databases do under the covers anyway?
[ Parent | on HN ]
Re:SQLite Release 3.42.0 by pdimitar on Wednesday May 17, 2023 @05:24PM (#35981440)
Yes, and? I prefer the DB to take care of it for me.
[ Parent | on HN ]