← Back to selected work
01 / FULL-STACK WEB APPLICATIONLocal demo

BorrowLab

Shared equipment. Accountable handovers.

From finding the right camera to recording its return, BorrowLab brings a shared equipment library into one clear workflow.

PROJECT TYPE

Full-stack web application

BUILT WITH

React / TypeScript · Next.js APIs / Vinext · Cloudflare Workers / D1 · Drizzle / SQLite

STATUS

Local demo

Application screenshot · sample/demo data
THE CHALLENGE

Where the simple version breaks.

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.

THE WORKFLOW

A clear path through the task.

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.

ENGINEERING DECISIONS

The details that make it hold.

01

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.

02

Treat a return as one operation.

The loan status, equipment condition, and activity record change atomically. A damaged return immediately moves the item into maintenance.

03

Account for the physical item.

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.

VERIFICATION

Behavior, checked.

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.

CURRENT SCOPE

Where this project stands.

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.

NEXT PROJECT

RelayBox↗

Every event. With a way back.

Expanded project screenshot