Motel Management System

Problem

Small motels and guesthouses often rely on paper logs or spreadsheets to track room occupancy, bookings, and daily revenue.

Approach

A TypeScript app for managing bookings, tracking occupancy in real time, and generating automated daily summary reports, built on Prisma ORM.

Tech highlights

Next.js with TypeScript, Prisma ORM for the booking and occupancy schema, and Tailwind CSS for the admin dashboard.

Results

Full write-up and live demo coming soon — check back or follow the GitHub repo for progress.

Challenges

Keeping occupancy state consistent when bookings, check-ins, and check-outs can overlap — modeling room availability so a single Prisma transaction blocks double-booking the same room for overlapping dates, and generating the daily summary correctly across day boundaries.