NNidaVellirinnidavellir.hashnode.dev·11h ago · 5 min readAvoiding Pitfalls in QR Code Implementation: A Developer's GuideQR codes have become a staple in diverse environments like cafes, logistics, and marketing campaigns. But imagine this: you've printed a batch of QR codes, only to find they aren't scanning as expecte00
YLYan Lunininyanlunin.hashnode.dev·1d ago · 5 min readI’ve reworked the tutorial in my micro-project three times, and I still don’t know if it’s become any clearer.I’m building a small N-Back trainer — an exercise for working memory and attention. During a training session, a square appears in different positions on the screen while letters are spoken aloud. The00
ALAethan Leeinaethanlee.hashnode.dev·3d ago · 3 min readBuilding a conversion report around shared data and metric definitionsMy work as a software engineer regularly involves data analysis. I built OWL Compose out of that experience: I wanted a practical way to use AI to produce reports whose numbers remain easy to inspect.00
Kkasinadhsarmainblogs.kasinadhsarma.in·4d ago · 12 min readFrom Dashboards to Decisions: An End-to-End Guide to Analytics for Apps and Daily BusinessEvery product team eventually hits the same wall: you have dashboards everywhere — Vercel, Google Analytics, a custom internal tool tracking loans and tasks — but no single thread connecting "what hap10
AAA Adarshinadarshgowda.hashnode.dev·Sep 10 · 6 min readPre-aggregation gets you 100× — until someone applies a filterYou have a dashboard over a large fact table. Tens of millions of new rows a month, thirty tiles on the page, and every tile is an aggregate: orders by channel, revenue by region, units by device. Eac00
SLSean Liuinzhaidata.com·Sep 10 · 7 min readMy semantic layer answers this question confidently. The answer is ambiguous.I'm building an evaluation harness for AI-generated SQL. While simplifying my semantic layer, I accidentally removed a guardrail I didn't know I had — and discovered a class of question that conventio00
АДАртём Дяченкоinartemdiachenko.hashnode.dev·Sep 8 · 6 min readI was proud of 4,410 impressions. Then I read the queries.For about a month I had a number I was quietly proud of. 4,410 impressions in Google Search Console. 31 clicks. Not a lot, but the line went up and to the right, and I'd built the thing myself, so I l00
DDravonicxintheory-vs-reality.hashnode.dev·Sep 6 · 3 min readSQL Window Functions: Calculating Cumulative Sums with Unbounded RowsA cumulative sum (or running total) continuously adds a sequence of numbers, providing a running aggregate at each step. In SQL, you calculate this using window functions combined with specific frame 00
AAmrinsmartlinks-live.hashnode.dev·Sep 6 · 5 min readYour app is live. How do you decide what to fix next?Getting an app into the store gives you a clear finish line. The build passes, the screenshots are uploaded, the review is approved, and the download button finally works. After that, the questions be00
NCN Chandra Prakash Reddyindevopstour.hashnode.dev·Sep 5 · 11 min readFrom Data Lake to Lakehouse: Building Modern Analytics Platforms on AWS with S3 Tables & AWS GlueOkay, we will be honest – data architecture is usually one of those topics that makes your head spin. I was there at AWS Community Day Chennai on 07-Mar-2026. There were a lot of good talks on many ki00