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
Holy Redeemer overview
Demo

Seeded records, no backend. Check out a copy, search the catalog, or switch to the student view. State resets on reload.

My role
  1. 01Designed the database around physical copies, so every copy has its own barcode and multiple copies of a book can be lent out simultaneously.
  2. 02Built the backend API with secure accounts and permissions for librarians, administrators, and students.
  3. 03Created the circulation desk dashboard for fast book checkouts, returns, and automatic ₱5-per-day late fine calculations.
  4. 04Built a self-service student portal so students can check their loan dates and avoid surprise fines.
Details
Holy Redeemer login with the school crest over a blurred bookshelf
Login
Librarian dashboard with on-loan, overdue, fines, and collection counts
Staff dashboard
Catalog list with copy availability and a checkout button on every title
Catalog
Student home with an overdue fine, current loans, and new arrivals
Student portal

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.

Desktop catalog with the sidebar, category filters, and per-title availability

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