News for hackers. Stuff that matters.

A comment on SQLite Release 3.37.0. Parent comment

Re:SQLite Release 3.37.0 by dotancohen on Sunday November 28, 2021 @06:34AM (#29368075) 

  > What about TIMESTAMP? DATETIME?
The same thing as we've always done: proper column names and strong datatypes in the application layer.
[ Parent | on HN ]
Re:SQLite Release 3.37.0 by SPBS on Sunday November 28, 2021 @08:42AM (#29368828)
Yeah, I'm starting to warm to the idea of `CREATE TABLE tbl ( created_at INT ) STRICT;`. The name still hints at what domain type it contains, and enforcing INT timestamps should make any indexes on that column considerably smaller.
[ Parent | on HN ]