Geofence Event-Driven Case Study
NestJS microservices for geofence enter/exit detection with PostGIS, transactional outbox publishing to Kafka, and idempotent event logging.
- NestJS
- TypeScript
- PostgreSQL
- PostGIS
- Kafka
- Docker
Projects
Backend systems work: messaging, data stores, and production debugging.
Kafka Outbox Pattern Demo
Reference implementation for transactional outbox flow with idempotent publishing, dead-letter routing, and operational metrics.
- NestJS
- Kafka
- PostgreSQL
- Docker
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
PostgreSQL Optimization Notes
Production query-plan experiments, index decisions, and latency work from real services.
- PostgreSQL
- SQL
- EXPLAIN ANALYZE