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 …

More →

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 …

More →

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 …

More →

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 …

More →

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 …

More →

With BackBrowse, it’s simplicity itself to build smart, searchable collections, and share them with anyone. Backbrowse

FrSky Horus X10S and X10 Systems PDF https://www.frsky-rc.com › X10&X10S

The modern web application has really come a long way over the years with the introduction of many popular frameworks such as bootstrap, Angular JS, etc. All of these frameworks are based on the popular JavaScript framework.   via Guru99