Miniature warehouse management system

End-to-end Spring Boot warehouse picking system with an HHT API, admin dashboard, and PostgreSQL audit trail

A full-stack warehouse-management proof of concept built with Java 21, Spring Boot, and PostgreSQL 17. It models the picking workflow from released customer orders to atomic task claims, location and article scans, stock updates, and completed orders. A separate REST contract supports handheld terminals (HHTs), while a session-authenticated web dashboard gives administrators a live view of available, active, completed, and stuck tasks.

Warehouse task dashboard showing available, completed, and stuck picking tasks
The polling admin dashboard, with a stuck picking task highlighted for operational follow-up.
View the code on GitHub

The application includes FIFO task allocation, concurrent and idempotent picking operations, deterministic QR labels for locations and articles, structured JSON logging, and append-only stock-movement and task-transition ledgers enforced by database triggers. Flyway owns the schema, development fixtures are isolated from preproduction, and unsafe or incomplete preproduction configuration fails fast with an actionable diagnostic.

Operational evidence

PostgreSQL diagnostic query output showing a stuck picking task and integrity overview
The SQL diagnostics pack identifies stuck work and provides an integrity overview for shift handover.
Preproduction startup validation reporting missing database configuration
The preproduction profile refuses to start without required database configuration and provides a safe, actionable diagnostic.
Generated QR label for warehouse article ART-001
A deterministic QR label generated by the article-label API for handheld scanning.

The delivery is backed by 33 PostgreSQL integration tests and 19 documented functional test cases, covering migrations, authentication, inventory integrity, concurrency, recovery paths, labels, logging, the dashboard, and a clean extension seam for future material-flow-control integration. The repository also contains SQL diagnostics, configuration matrices, requirements traceability, architecture decisions, runbooks for Linux and Windows, and retained runtime evidence.