News for hackers. Stuff that matters.
Re:NewSQL databases fail to guarantee consistency and I blam... by notatcomputer68 on Friday September 21, 2018 @11:22AM (#18040347)
Can't you solve that by just picking a reference frame though?
Re:NewSQL databases fail to guarantee consistency and I blam... by hinkley on Friday September 21, 2018 @12:18PM (#18040752)
HTTP has had a reference frame since 1.0. It’s still one of my favorite features of just about any protocol ever.

Cache headers can set expiration times or offsets, but the client and server both send their own time stamp in the message. So when the server says “expire this at noon” but your laptop’s clock is five minutes slow or three time zones away, you can still figure out what the server meant by noon because the server tells you what time it thinks it is now. The accuracy is limited by network delays but for the problem space getting the right answer to the nearest second is still pretty damned good.

Re:NewSQL databases fail to guarantee consistency and I blam... by xenadu02 on Friday September 21, 2018 @12:00PM (#18040636)
Yes, and we all pick the Earth’s gravity well as our reference frame. Differences due to elevation and latitude are too small to measure for purposes of transaction clocks.
Re:NewSQL databases fail to guarantee consistency and I blam... by jonas21 on Friday September 21, 2018 @12:02PM (#18040650)
yeah, I’m pretty sure TrueTime is only defined on Earth, and GPS satellites do take relativity into account in their design.

http://www.astronomy.ohio-state.edu/~pogge/Ast162/Unit5/gps....

Re:NewSQL databases fail to guarantee consistency and I blam... by ianopolous on Friday September 21, 2018 @11:59AM (#18040627)
You need a quite elaborate system of a grid of synchronized, stationary clocks and rods to correctly define a reference frame, which is worse than what's required to come up with a "good enough on earth to some time resolution" true time.
Re:NewSQL databases fail to guarantee consistency and I blam... by ianopolous on Friday September 21, 2018 @12:32PM (#18040845)
To be clear this is pretty much exactly what the system of GPS satellites does, but without physical rods, and it is very expensive to construct and maintain. This works fine to a certain accuracy as long as you restrict your application to staying on earth.