zeitgeist team mailing list archive
-
zeitgeist team
-
Mailing list archive
-
Message #00276
[Bug 483603] Re: Use REAL for timestamps
We don't use seconds. We use milliseconds since the Unix epoch.
I dislike floating point timestamps because of two things:
* Python is the only language I have ever heard of that use floats for timestamps
* Float-comparisons (and thus db-indexes) are less effective than integer comparisons
--
Use REAL for timestamps
https://bugs.launchpad.net/bugs/483603
You received this bug notification because you are a member of
Zeitgeist-Engine, which is the registrant for Zeitgeist Engine.
Status in Zeitgeist Engine: New
Bug description:
Seconds are not fine-grained enough to differentiate events, so we should store the timestamps as floating-point numbers.
References