2024_11_venue-management
Venue Management System
Go, Gin, pgx, goose. Hexagonal architecture with domain models at the core and Postgres adapters on the edge. Concurrent slot booking via PostgreSQL advisory locks — no double-books under race conditions. Squirrel for queries, Wire for DI.
GoGinPostgreSQLpgxHexagonalWire
2024_08_inventory-management
Inventory Management System
Clean-architecture Go service. Every stock mutation is an immutable audit log — no UPDATE, only INSERT. Raw SQL for aggregation queries. Alerting runs as a separate goroutine pool with backoff, decoupled from the API.
GoPostgreSQLClean ArchitecturegooseSQL
2024_05_tutoredx
TutoredX
Go backend, React frontend. course→module→lesson schema with enrollment verification at every query. Custom middleware chain for auth, tenant resolution, rate limiting. Progress uses a state machine — transitions enforced at the DB level with CHECK constraints.
GoReactPostgreSQLREST APITypeScript