B2B SaaS platform
WastePickup
Multi-tenant business app for pickup routes, driver dispatch, and automatic customer billing.
- Role
- Full-stack engineer - system design, database architecture, deployment
- Stack
- TypeScriptNext.jsPrismaPostgreSQLTailwind CSS
- The problem
- Waste collection companies often run on paper schedules and phone calls. Managers cannot see which routes were finished, cannot balance work between drivers, and have to type invoices by hand.
- The constraint
- Different companies share the same database, so customer records must never mix. Drivers use the app on mobile phones with weak cell service.
- The approach
- Built on PostgreSQL with Prisma. I locked down tenant IDs at the database query layer so one company can never see another company's data. Built live driver dispatch screens, street maps for pickups, and bills that generate automatically when a driver marks a job done.
- The result
- Deployed live on Vercel at enterprise-waste-pickup.vercel.app. Companies can schedule jobs, track drivers on routes, and send bills with zero manual paperwork.
What the platform does
Waste collection companies schedule pickups, assign drivers to zones, track route progress, and send bills to customers from one clean dashboard.
What is interesting here
Customer data is locked at the database layer. In a shared database, one missing
WHERE clause can leak private data to a competitor. I locked the queries down in
the data layer so nobody has to remember to add tenant checks. A data leak is impossible
by design.
Bills are generated automatically, not typed. Invoices are created right from completed pickup logs. That stops billing mistakes where customers get billed for pickups that never happened, or drivers do work that never gets billed.
Built for drivers with weak phone signals. Drivers use this in trucks on rough roads. The dispatch screens are light, fast on mobile, and save work even if the internet drops for a few minutes.
Why it is the flagship
It solves a hard, real-world business problem: multiple companies using one system, drivers working on phones in the field, and money that must be billed accurately. You can open and test the live app right now on Vercel.
Need something like this?
I build web products and the backend systems underneath them, from first commit to live production. Tell me what you are trying to do.
