Projects

Engineering case studies from backend systems, reliability work, and database performance tuning.

Geofence Event-Driven Case Study

Processing enter/exit geofence events with ordered retries, duplicate suppression, and visibility into delayed consumer pipelines.

  • Node.js
  • NestJS
  • Kafka
  • PostgreSQL
  • Redis
GitHubCase Study

Kafka Outbox Pattern Demo

Reference implementation for transactional outbox flow with idempotent publishing, dead-letter routing, and operational metrics.

  • NestJS
  • Kafka
  • PostgreSQL
  • Docker
GitHubImplementation Notes

RedisGraph Hierarchical Auth Model

Evaluating graph-based permission inheritance for tenant-scoped authorization where role resolution must stay fast under load.

  • Redis
  • RedisGraph
  • TypeScript
  • Docker
GitHubWrite-up

PostgreSQL Optimization Notes

A running set of production query-plan experiments, index decisions, and p95 latency improvements from real services.

  • PostgreSQL
  • SQL
  • EXPLAIN ANALYZE
RepositoryArticle