Home/Case Studies
Technical deep-dives by Sharon Rosario

Case Studies

Security breakdowns, product builds, and engineering notes - written to help you understand the problem and act on it.

Security

Understanding & Removing the Git Config Injection Worm

How a self-propagating Git worm spreads across local project folders — detection, removal, and a Windows-first playbook.

Technical breakdown of VS Code auto-task exploitation, PostCSS config injection, and silently rewritten Git commits — with copyable IoCs, audit scripts, and step-by-step removal on Windows.

Malware AnalysisGitWindows
June 202612 min
Read case study
Architecture

Zero-Leak Multi-Tenant RAG Architecture

How to build a B2B AI product that mathematically guarantees one customer can never read another customer's data — using Postgres RLS and pgvector.

A deep technical guide for CTOs and founding engineers on enforcing true data isolation in multi-tenant RAG systems — covering Postgres Row-Level Security, pgvector, namespace partitioning, and a complete security test suite.

AISaaSSecurity
June 202618 min
Read case study
Architecture

Decoupling AI: From Blocking Calls to Event-Driven Microservices

Why synchronous OpenAI API calls will kill your production server under load — and the exact architecture that fixes it using Redis, BullMQ, and WebSocket streaming.

A complete implementation guide for moving from fragile, timeout-prone synchronous AI calls to a scalable event-driven pipeline — with Node.js, Python FastAPI, BullMQ, Redis, and a React streaming frontend.

AINode.jsPython
June 202620 min
Read case study
AI Engineering

Taming Autonomous Agents: Orchestrating Multi-Agent Workflows with LangGraph

How to move beyond unreliable "God prompts" and build deterministic, self-correcting AI agent pipelines that are actually production-ready.

A complete architectural guide and Python implementation for building a Researcher-Writer-Verifier multi-agent pipeline using LangGraph — including state management, self-correction loops, observability with LangSmith, and production hardening patterns.

LangGraphAI AgentsPython
June 202625 min
Read case study