Enforce booking rules in the database.
SQLite triggers reject overlapping active reservations, including competing requests. A return date occupies the whole day; next-day reservations are allowed.
BorrowLab
From finding the right camera to recording its return, BorrowLab brings a shared equipment library into one clear workflow.
Full-stack web application
React / TypeScript · Next.js APIs / Vinext · Cloudflare Workers / D1 · Drizzle / SQLite
Local demo
A booking calendar can say an item is free while it is still out on loan. A shared studio needs to prevent overlapping promises, track physical possession, and stop damaged equipment from being issued again.
Members browse equipment, reserve inclusive date ranges, and receive a collection code. Managers verify collections, record returns and condition, and review a chronological activity history.
SQLite triggers reject overlapping active reservations, including competing requests. A return date occupies the whole day; next-day reservations are allowed.
The loan status, equipment condition, and activity record change atomically. A damaged return immediately moves the item into maintenance.
A collected item cannot be collected by another borrower, even if its reservation dates have passed. Member and manager permissions are enforced on the server.
Local verification recorded 10 passing service/database tests, a successful TypeScript check, and a production build. A separate HTTP concurrency check produced one saved booking and 19 conflicts from 20 competing requests.
A local demonstration for one organization, using sample studio inventory and a simulated development identity. Hosted authentication and public deployment have not been verified. The figures shown are demo state, not adoption metrics.
Click an image to inspect it.
Every event. With a way back.