🕒 Java Developer’s Guide to Understanding Time This comprehensive guide explains how Java developers should think about time, timezones, DST (Daylight Saving Time), and formats like ISO 8601 and RFC 3339. It makes an explicit and critical distinction between the representation of time (format) and the interpretation of time (timezone). Most importantly, it clarifies a …
✅ TL;DR ChronoGraf is a high-performance, Java-based time series analytics platform backed by PostgreSQL.It supports three complementary data modes: Each is available across six fixed UTC-aligned temporal granularities:5s, 1m, 1h, 1d, 1w, 1mo. With mixed-granularity querying, dynamic percentile calculation, and late event correction (via upward propagation), ChronoGraf provides scalable, accurate analytics for: It runs as …
Overview A comprehensive time series service designed to handle multiple data types and query patterns for event-driven applications. The service supports both aggregated metrics (counting and histograms) and detailed event retrieval with flexible filtering capabilities. Core Functionality Data Types Supported The service handles two primary data categories: Key Features Metrics Storage and Retrieval The service …
Executive Summary This document describes an optimized approach for retrieving histogram data stored across multiple temporal granularities (5-second, 1-minute, 1-hour, 1-day, 1-week, 1-month) when querying with timezone-specific ranges. The solution leverages histogram aggregation properties to minimize data retrieval overhead while maintaining statistical accuracy through intelligent granularity selection and bucket merging. Problem Statement Histogram data is …
Executive Summary This document describes an optimized approach for retrieving time series event counter data stored in multiple granularities (5-second, 1-minute, 1-hour, 1-day, 1-week, 1-month) when querying with timezone-specific ranges. The solution minimizes data retrieval overhead while ensuring precise boundary coverage through intelligent granularity selection. Problem Statement Time series data is stored in UTC-aligned segments …
In the annals of aviation, there are few aircraft that have inspired awe quite like the Airbus A380. Colossal, graceful, and whisper-quiet, the double-decked superjumbo was more than just a plane. It was a flying cathedral of engineering brilliance and a symbol of humanity’s unrelenting ambition to reach higher, farther, and in greater comfort than …
I asked ChatGPT to “Write pascal code to manage a sorted symbol table using two tables the main table and a secondary table, when the secondary table becomes more then 10% of the main table do a merge sort into the main table” This is something I wrote back in the late eighties, and aside …
Have it Have it Have it Want it Want it Want it
The Enchanted Principles of Wizarding Codecraft Ah, young witches and wizards, gather ’round! Today, we shall uncover the ancient and powerful magic that governs the art of spellbinding software development. These sacred enchantments, whispered through the ages, are known as the SOLID Principles, and they shall lead you to craft code as elegant as Dumbledore’s …
The database is range partitioned into 24 partitions based on the ts field, the main table and the partitions are indexed on the timestamp (ts) and status fields. Hardware spec AMD Ryzen 7 5800x 128gb Corsair 3600 MT/s RAM SABRENT M.2 NVMe SSD 1TB Gen 4, Internal Solid State Debian Linux 12 PostgreSQL 15 With …