Diamond Diary
Industrial diamond inventory & ledger database
Built to streamline my Dad's daily work
Stack // Next.js 15 / Express / PostgreSQL / Prisma / TypeScript / Tailwind CSS
// 01. The Challenge
Engineered specifically to help my Dad's daily diamond processing work by replacing manual paper logs with a zero-drift, multi-attribute transaction ledger database.
// 02. The Approach
Designed a high-precision PostgreSQL relational schema, built a fast REST API with Hono/TypeScript, and developed an interactive virtualized data table for real-time multi-column search and inventory tracking.
// 03. The Impact
Eliminated transaction calculation errors with zero decimal precision drift, reduced query latency below 100ms, and streamlined daily workflow operations for my Dad's work.