Re:Appropriate Uses for SQLite
by module0000 on Monday February 12, 2018 @01:15PM
(#16360574)
This may not be helpful to you, but I've always used the epoch time stored in sqlite. It's blazing fast, indexes well(integers !), and is 100% convertible to any format you might need to represent.
[ Parent
| on HN ]
Make sure you're using signed integers larger than 32 bits if you ever need dates before ~1970 or after ~2030.