Geek Logbook

Tech sea log book

Recent Posts

Categories

#50projectsIn50days Airflow Amazon Web Services Apache Iceberg AWS Azure bash Batch CAP Coders At Work Data data lakes Data Pipelines Data Warehouse Docker Edsger W. Dijkstra Excel Git Hadoop HDFS Hellerstein Hive Javascript Networking NoSql PostHog Postman Power Bi Powershell Pyspark Python Redash S3 Social Skills Software Developer Spark Spark: The Definitive Guide SQL SSH terraform Testing The Elements of Programming Style Understanding Distributed Systems whale-alert Yaml

Archives

Can You Know the Location of an IPv6 Address?

Example IPv6: Short answer: only approximately, and with significant limitations. This article explains what can and cannot be inferred from an IPv6 address, the technical reasons behind those limitations, and how geolocation services actually work. 1. IPv6 Structure and Why It Matters An IPv6 address is 128 bits long and typically structured as: In practice:
Read More

AWS Glue + Chargebee: Diagnosing CERTIFICATE_VERIFY_FAILED After TLS Chain Updates

Context An AWS Glue job that consumes the Chargebee API begins failing with: The same request works in Postman. This pattern typically appears after a certificate chain rotation on the API provider side combined with an outdated trust store in the execution environment. Chargebee announced updates related to its TLS certificate chain (DigiCert G2 becoming
Read More

Why There Is No “Interpreter” Endpoint in the Zoom API

Many teams attempt to retrieve language interpretation usage (e.g., minutes consumed per language channel) through the Zoom REST API, only to discover that no such endpoint exists for Meetings or Webinars. This is not a misconfiguration or missing scope issue — it is a structural limitation of the public API. This article explains: The Common
Read More

Why You Can’t Get Full Social Analytics from the HubSpot API (Even with Marketing Hub Pro)

Many teams assume that upgrading to Marketing Hub Professional unlocks full programmatic access to social media performance metrics. It does not. This article clarifies what is technically possible, what is not, and how to architect a reliable data pipeline for social analytics. The Core Limitation HubSpot allows you to: But HubSpot does not provide an
Read More

From OLTP to OLAP: How Data Moves from 3NF to a Dimensional Data Warehouse

Modern data architectures typically separate operational systems from analytical systems. This separation is not accidental—it reflects fundamentally different workloads, data models, and optimization strategies. This article explains the conceptual transition: Operational Systems (OLTP) and 3rd Normal Form Transactional systems—CRM platforms, payment processors, ERPs, application databases—are designed for: These systems are usually modeled in Third Normal
Read More

Resolving the Node.js Error: Cannot find module jsonwebtoken

When developing backend services with Node.js, especially APIs that implement authentication, it is common to rely on JSON Web Tokens (JWT). One frequent runtime error encountered in this context is: This article explains the root cause of this error and provides a precise, production-oriented solution. Problem Description The error indicates that Node.js cannot resolve the
Read More

Extracting and Managing Access Tokens in Postman

When working with APIs that use OAuth 2.0 or token-based authentication, a common requirement is to extract an access_token from a successful authentication request and reuse it in subsequent API calls. Postman provides a built-in scripting environment that makes this straightforward and repeatable. This article explains how to capture an access token from a POST
Read More

How PostHog Uses ClickHouse for High-Performance Product Analytics

Modern product analytics platforms must process billions of events while still delivering low-latency queries for dashboards, funnels, and retention analysis. PostHog addresses this requirement by building its analytics engine on top of ClickHouse, a column-oriented OLAP database designed for large-scale analytical workloads. This article focuses exclusively on how ClickHouse is used within PostHog, from data
Read More