HIGH-PRECISION DATE/TIME IN SQLITE

Summary from the TLDR Web Dev newsletter

Sqlean-time is a high-precision date/time extension for SQLite. It provides a structured API and a rich set of functions for working with Time and Duration values. The extension enables storing and manipulating dates for billions of years in the past and future with nanosecond precision.