DKDave Kurianinotf-kit.hashnode.dev·24m ago · 7 min readLock GitHub Actions dependencies to reviewed commits with workflow lockfilesA moving tag is not a review Your workflow can keep saying uses: vendor/build-action@v3 while the code behind v3 changes. That leaves a gap between the commit your team reviewed and the commit a later00
SGSoham Gaichorinsoham111.hashnode.dev·11h ago · 5 min readThe Cashier and the CEO: A Tale of Two Database Worlds (OLTP vs. OLAP)Imagine you walk into a bustling coffee shop. At the front counter, a barista is rapidly tapping the screen, printing paper receipts, and handing out lattes. In the back office, the store owner is sit00
DKDave Kurianinotf-kit.hashnode.dev·13h ago · 7 min readGitHub App least privilege for SaaS repo creation and accessA SaaS product may need to create a customer repository during onboarding, or add an existing repository to an already installed GitHub App. Those are legitimate product workflows, but asking a custom00
Ddouzataninaiools.hashnode.dev·14h ago · 9 min readAndroid Accessibility Tree vs Vision Agents: Architecture Tradeoffs for Mobile UI AutomationEvaluating the Android accessibility tree vs vision agents is the central architectural decision when building AI systems that operate real mobile applications. Relying exclusively on the Accessibilit00
DKDave Kurianinotf-kit.hashnode.dev·14h ago · 8 min readAdd consented voice cloning to a TypeScript app with Sarvam AIA voice sample is easy to collect. Turning it into a safe, useful feature is the harder part. If your app needs spoken replies in a user’s own voice, the integration has to do more than send audio to 00
DKDave Kurianinotf-kit.hashnode.dev·14h ago · 8 min readDeploy a Hono backend on AWS Lambda without an adapter layerA Hono app may already have a normal HTTP server, routes, middleware, and database calls. Moving that app to Lambda used to mean adapting the request lifecycle or adding a bridge layer. AWS Lambda Web00
DKDave Kurianinotf-kit.hashnode.dev·15h ago · 9 min readCloudflare web search and bounded fetch for SaaS agent research workflowsAn assistant that can search the web is useful only if it can bring back the right evidence. Give it unrestricted page fetching, though, and a simple research question can turn into a large, noisy pro00
SGSoham Gaichorinsoham111.hashnode.dev·17h ago · 6 min readThe Shepherd, the Dog, and the 700 Sheep: A Visual Guide to SQL Server Composite IndexesHave you ever wondered what actually happens inside a database when you run a query filtering on multiple columns? Or why adding an index sometimes makes your queries lightning-fast, but other times b00
DKDave Kurianinotf-kit.hashnode.dev·18h ago · 7 min readSupabase pg-delta migration guide: adopt declarative schemas safelyA schema diff can be technically valid and still remove data you meant to keep. That is why switching an existing Supabase project to Declarative Schemas 2.0 needs a review plan, not a blind toggle. T00
SGSoham Gaichorinsoham111.hashnode.dev·18h ago · 6 min readThe Secret Life of Database Pages: Why "Fill Factor" is the Ultimate Balancing ActImagine you are packing your school backpack for the year. Do you shove your books in so tightly that you can't even zip it closed? Or do you leave a bunch of empty space in every pocket so you can ea00
