Store your epoch times as 64-bit floats

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • awesome-falsehood

    😱 Falsehoods Programmers Believe in

  • It's saddening to see the number of people who critique the idea of storing time as an unsigned integer by immediately responding that that means that times before 1970 cannot exist. This bespeaks of a continuing poor knowledge of the subject, despite all of the "falsehoods that programmers believe about" documentation that has grown up.

    * https://github.com/kdeldycke/awesome-falsehood#dates-and-tim...

    Microsoft, for one example, has been modelling times as a 64-bit unsigned 100-nanosecond count since 1601 (proleptic-Gregorian proleptic-UTC) for about 30 years, now.

    * https://learn.microsoft.com/en-us/windows/win32/api/minwinba...

    Daniel J. Bernstein in the late 1990s chose a 0 point for an unsigned count so far back that it pre-dates most estimates of the point of the Big Bang.

    * http://cr.yp.to/libtai/tai64.html

    1970 is not the mandatory origin for every timescale. (Indeed, in the early years of Unix itself there wasn't even a stable origin for time.) It is not a valid reason for dismissing the idea of storing time as an unsigned integer.

    It's also sad to note that the headlined page's first sentence has one of the very falsehoods that programmers believe about time in it.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Why is it still a practice to not allow special characters in name fields?

    1 project | /r/AskProgramming | 8 Dec 2023
  • Bjarne Stroustrup Quotes

    1 project | news.ycombinator.com | 27 Nov 2023
  • Facebook must pay $100.000 to Norway each day for violating our right to privacy

    1 project | news.ycombinator.com | 18 Aug 2023
  • Falsehoods Programmers Believe In

    1 project | /r/hypeurls | 5 Aug 2023
  • Falsehoods Programmers Believe In

    2 projects | news.ycombinator.com | 3 Aug 2023