Tech | skyaching

Hand-drawn scheduling field-notes cover: 'the same order, almost processed twice' — a 'just locking isn't enough' race condition on the left, 'correctness must rest on DB constraints' with a unique index on the right, plus the partial unique index and state-machine takeaways.

Worried the Factory Might Build the Same Order Twice? I Thought a Lock Would Fix It — Turns Out It Was a Design Problem

To go faster, software runs many processes in parallel. But if two flows grab the same order and each sends it to production, that’s a real, physical loss for the company — scrapped goods. I thought ‘just add a lock’; it turned out I needed an idempotency key. The chase ran to an Oracle partial unique index — and the real fix was more than the index: a status column whose single value secretly meant two different things.

Amazon Q Business chatbot answering questions over indexed company documents

Building a Company-Docs Search Assistant with Amazon Q Business

Internal specs were scattered across Confluence, Jira, and Figma, and finding the right rule cost real engineering time. This is how I stood up an Amazon Q Business assistant that lets the team just ask — including the IAM setup, data-source connectors, and what it actually costs.

Imgproxy vs Akamai CDN, Part 2: When On-the-Fly Image Compression Hurts More Than It Helps

Compressing images with Imgproxy actually slows small files down by 113–154%. Only files above 3 MB consistently benefit. Two experiments (cold and warm cache), four compression tiers, correlation analysis — and an action rule that took the guesswork out of our gateway.

Imgproxy vs Akamai CDN: A Statistical Performance Analysis

Imgproxy behind AWS, Wilcoxon-tested. CloudFront → Imgproxy beats Akamai → S3 — but only after the first request warms the cache.