tembo-io / pg_timeseries

Simple and focused time-series tables for PostgreSQL, from Tembo
PostgreSQL License
324 stars 5 forks source link

Add LOCF and gap-fill logic #12

Closed jasonmp85 closed 5 months ago

jasonmp85 commented 5 months ago

This adds a function to date-bin time-series data, including the production of missing rows (emitted as NULL values). By combining this with the provided LOCF window function, it is possible to produce dense bucketed time series entirely within PostgreSQL and with minimal SQL knowledge.

jasonmp85 commented 5 months ago

Pushing up some changes to this after the demo; it's much improved and good to go after that