ankane/groupdate
Groupdate
Groupdate is a PostgreSQL time series aggregator and date grouping tool. It provides a set of SQL functions to group and aggregate temporal records into discrete buckets, such as days, weeks, or months, to calculate sums and averages for reports.
The project focuses on ensuring continuous timelines through time series gap filling, which inserts default values for periods where no data exists. It also includes a temporal data formatter that converts grouped date-time keys into localized strings or custom formatting patterns.
The tool covers broad temporal data operations, including time range filtering and the extraction of calendar components, such as grouping data by the day of the week. It further supports time-zone aware calculations to align grouping with local calendar days.
Features
- Time-Series Aggregations - Provides SQL functions to calculate computational summaries like averages and sums over time-indexed data buckets.
- Time Bucketing - Aggregates data into fixed time windows by slicing the timeline into discrete calendar buckets.
- टेम्पोरल सीक्वेंस जनरेशन - Generates complete date ranges to represent periods with no data in the final result set.
- Temporal Range Filtering - Implements mechanisms to limit data aggregation to specific absolute or relative time windows.
- Null Value Filling - Fills gaps in time series by including periods without data and assigning default values.
- Time-Series Extensions - Provides a PostgreSQL extension for grouping and aggregating temporal data into discrete buckets.
- SQL Date and Time Manipulation - Provides SQL functions for handling time-based bucketing, gap filling, and time zone calculations.
- Time Series Imputation - Ensures continuous timelines by filling missing temporal periods with default values.
- Calendar Component Analysis - Organizes time-based data by calendar components like day of the week to find patterns.
- Dynamic Grouping - Adjusts time-based aggregation intervals at runtime based on user input.
- Temporal Formatters - Converts grouped date-time keys into localized strings or custom formatting patterns.
- Dynamic Granularity Resolution - Determines grouping granularity at execution time by mapping input variables against permitted time units.
- Time Zone Conversions - Adjusts timestamps based on defined time zones to ensure alignment with local calendar days.
- Temporal Component Extraction - Groups data by specific calendar parts, such as the day of the week or month.
- Custom Date-Time Format Patterns - Transforms raw date objects into human-readable strings using customizable format patterns.
- Dynamic Grouping Intervals - Determines grouping intervals at runtime using variables and a permit list to restrict allowed units.
- Date and Time Formatting - Converts grouped temporal keys into human-readable strings or localized formats.
- डेटा मैनेजमेंट - Manages temporal data.
- Date and Time Processing - Group temporal data across various data structures and ORMs.
