High-precision date/time in SQLite

from blog Anton Zhiyanov, | ↗ original
A rich set of functions for working with date, time and durations.
This is a short summary. ↗ Open original to view full content

Related

SQLite 3.45: Interactive release notes
Anton Zhiyanov | original ↗
Modern SQLite #1: STRICT tables
Anton Zhiyanov | original ↗
Modern SQLite: Delete limit
Anton Zhiyanov | original ↗
High-precision date/time in SQLite
Anton Zhiyanov | original ↗
0018: last reflections, why start a new database conference, 2021 retrospective, imp schemaless db + crdt, office hours, internal inconsistency in the wild, rss feeds, salsa needs finite collections, tiddlywiki vs unigraph, multidimensional indexes, arrow, just don't fsync, testing distributeds systems, tigerbeetle perf demos, web3, explicit formal structure, zig doctests, rust arenas, semidirect products of crdts, single-program distributed systems, sqlite qpsg, valhalla, mundanity of excellence, to mmap or not to mmap, libgavran, relational e-matching
Scattered Thoughts | original ↗
Recipes from Python SQLite docs
Redowan's Reflections | original ↗
Modern SQLite: Delete limit
Anton Zhiyanov | original ↗
SQLite: Dropping an index for a 300x speedup
nickb.dev | original ↗
Exploring TimescaleDB as a replacement for Graphite
nickb.dev | original ↗
ISO 8601 and Nanosecond Precision Across Languages
nickb.dev | original ↗

More from Anton Zhiyanov

Gist of Go: Wait groups
30 Jul 2024 | original ↗

Waiting for goroutines to finish.

Gist of Go: Goroutines
30 Jul 2024 | original ↗

Let's write a concurrent program in Go!

Gist of Go: Concurrency
30 Jul 2024 | original ↗

Interactive book on concurrent programming with many exercises.

Go features by version
22 Jul 2024 | original ↗

Which major features appeared in which versions of Go.

Go 1.23: Interactive release notes
20 Jul 2024 | original ↗

Iterators, timers and canonical values.