Settings

Theme

How to store weather forecast data for fast time-series APIs (2022)

openmeteo.substack.com

27 points by tcumulus 4 months ago · 2 comments

Reader

jeffbee 4 months ago

Much of the article seems to be discussing the advantages of using time as the major dimension, without using the word "major". But an alternative to switching the major dimension would be to arrange the data along a Hilbert curve in 4 dimensions, giving good locality of access for range scans in time or geographical coordinate. That seems like it would also offer better compression from delta coding, since with better locality you should also enjoy smaller deltas.

Keyboard Shortcuts

j
Next item
k
Previous item
o / Enter
Open selected item
?
Show this help
Esc
Close modal / clear selection