Two patterns, depending on where the work happens
Internal admin / CRUD app
For when "the spreadsheet" no longer cuts it. Multi-user editing, audit history (who changed what when), search, exports, mobile-friendly forms. Replaces the shared Excel file someone keeps overwriting.
Common builds: client roster + intake form, work-order tracker, employee-cert log, equipment inventory + assignment, training-completion tracker, customer-complaint log.
Phone-first internal portal
For field staff who use the tool from a phone in a parking lot. Clock-in / clock-out, photo upload, GPS-stamp, signature capture, daily-briefing view. Offline-tolerant; syncs when connectivity returns.
Common builds: contractor punch-clock with GPS, delivery-driver POD signature capture, technician work-order completion, daycare check-in/out.
What makes these different from off-the-shelf SaaS
- You own the source. Day-one git handoff. No SaaS subscription, no per-seat fee, no upcoming-shutdown announcements.
- Built for your specific workflow. Off-the-shelf tools have 200 features you don't use. These have the 12 features you actually need.
- Audit history is the default. Every change records who-what-when. Most off-the-shelf tools charge extra for this.
- Role-based access — your owner sees everything, managers see their location, employees see only their assignments. Configurable without code changes.
- Hosted on your subdomain — e.g., portal.yourbiz.com. Looks like part of your business, not a third-party tool with a generic URL.
- Documentation written for the operator, not for a developer. Two-page runbook covering: how to add a user, how to back up, how to export data, who to call if something breaks.
What about the database?
- SQLite for small builds (up to a few hundred thousand rows). Single file, easy to back up, runs anywhere.
- PostgreSQL for builds that need concurrent writes from many users or that will grow past the SQLite ceiling.
- Restore-tested backups — nightly automatic, weekly verified by a sandbox restore. The backup is on your server (or in your cloud bucket); we don't hold it.
- Export to CSV / Excel from the UI by default. You're never locked in.
Pricing
Small CRUD app: from $1,500. Single-table CRUD with auth, search, exports. 1-2 weeks. Common for "we just need to track X without a $50/mo SaaS bill."
Medium internal tool: from $4,500. Multi-table relations, role-based access, audit history, mobile-friendly forms, scheduled reports. 3-5 weeks. Most replace-the-spreadsheet builds land here.
Field portal with offline: from $5,500. Phone-first UI, GPS stamps, photo uploads, offline queue + sync. 4-6 weeks.