Posts
All the articles I've posted.
-
Window Functions vs JOIN in Spark: A Physical Plan Perspective
When solving analytical queries in Spark SQL, there are often multiple correct formulations. However, they do not produce equivalent execution plans. This article compares two approaches to the same
-
Can You Know the Location of an IPv6 Address?
Example IPv6: 2600:100e:b0c7:7403:f88c:92d0:bc41:46ff Short answer: only approximately , and with significant limitations. This article explains what can and cannot be inferred from an IPv6 address,
-
AWS Glue + Chargebee: Diagnosing CERTIFICATE_VERIFY_FAILED After TLS Chain Updates
Context An AWS Glue job that consumes the Chargebee API begins failing with: SSLError: SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate The same
-
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
-
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
-
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,
-
Why Small Tables Can Explode: Understanding JOIN Cardinality in SQL
It is common to assume that joining two small tables will produce a small result set. In practice, this assumption frequently fails. Even tables with only a handful of rows can generate unexpectedly
-
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: