Systems in Prod

Real data & AI use cases, built for production. Every use case shows the business problem, the architecture, working code, the real costs and what breaks.

All use cases Courses

Why this site exists

There are tutorials for every tool. What is missing is when to use which tool, how they fit together, and what happens once real data and real users hit them. Every page starts from a business problem and ends with a system running in production.

Business problem

Who has it, what it costs, why the usual approach falls short.

Architecture

A diagram and the reason behind each tool choice.

Working code

Code you can run, shared in the projects repo.

Real costs

Measured numbers from real runs, not marketing estimates.

What breaks

The failure modes, and how to catch them before your users do.

Explore topics

Use cases on the way. Each one follows the same shape.

Data quality gate

Stop bad data before it reaches dashboards.

Lineage impact analysis

“What breaks if I change this column?”

AI agent for Jira triage

An AI agent that triages Jira tickets.

Private RAG

RAG on company documents, running locally with Qwen.

Real-time anomaly alerts

Kafka and Spark Structured Streaming.

Text-to-SQL with guardrails

Text-to-SQL for business users, with safety guardrails.

Follow the build

New use cases, code and cost breakdowns as they ship.