HSHarpreet Singh Kapulainsingh-technical-blog.hashnode.dev·4d ago · 7 min readYour Router's "AI Threat Detection" Is Probably Just a Lookup Table With Extra StepsThis is a breakdown of what consumer router marketing claims versus what the underlying detection mechanisms actually do — an analysis of the technology and the labeling around it, not a guide to evad00
HSHarpreet Singh Kapulainsingh-technical-blog.hashnode.dev·5d ago · 7 min readReading a DNS Query in Wireshark, Line by LineEveryone knows the one-sentence version: DNS translates domain names into IP addresses. That's usually where the explanation stops — DNS is treated as a black box that happens instantly and invisibly 00
HSHarpreet Singh Kapulainsingh-technical-blog.hashnode.dev·5d ago · 7 min readWhat traceroute Actually Shows You (And What It Doesn't)Most people run traceroute exactly once — usually when something's already broken — see a wall of IP addresses and numbers scroll past, shrug, and close the terminal no wiser than before. It gets trea00
HSHarpreet Singh Kapulainsingh-technical-blog.hashnode.dev·6d ago · 6 min readWhy One-Hot Encoding Turned 25MB Into 1.4GBHere's a real number, produced by running the code below, not borrowed from anywhere: a single categorical column, 500,000 rows, 3,000 unique values, sitting at a modest 25.6MB in memory. One-hot enco00
HSHarpreet Singh Kapulainsingh-technical-blog.hashnode.dev·6d ago · 7 min readWe Added the Index. The Query Was Still Slow. Here's WhyIt's a familiar shape of incident, and versions of it show up constantly in backend post-mortems: everything runs fine in staging against a few thousand rows, ships to production, and then real traffi00