Feb 2026Library System · Web App
Holy Redeemer
Replaced paper logbooks and spreadsheets with a unified library system covering barcode checkouts, fine tracking, and a student portal.
Librarians run checkout, returns, and fines from one screen, while students check loan dates online.
GoPostgreSQLReactTypeScriptTailwind CSS

Demo
Seeded records, no backend. Check out a copy, search the catalog, or switch to the student view. State resets on reload.
My role
- 01Designed the database around physical copies, so every copy has its own barcode and multiple copies of a book can be lent out simultaneously.
- 02Built the backend API with secure accounts and permissions for librarians, administrators, and students.
- 03Created the circulation desk dashboard for fast book checkouts, returns, and automatic ₱5-per-day late fine calculations.
- 04Built a self-service student portal so students can check their loan dates and avoid surprise fines.
Details




The same build at phone width. Staff get a dashboard and the circulation desk; students get their own shelf and fine balance.
The view expands from phone to desktop, then a librarian checks out a copy. The layout reflows in place; nothing reloads.

Availability comes from the copy rows, not a number someone updates by hand. A title with every copy out is disabled at the desk.
