Case Study: Architecting an Enterprise Transport & DBS Compliance Portal

In municipal school transport and regulated taxi operations, compliance is mission-critical. Council contracts require operators to maintain meticulous, up-to-the-minute records for hundreds of drivers, passenger assistants, and vehicles—including Enhanced DBS certificates, council badges, paediatric first-aid accreditations, and daily vehicle safety logs.

The Challenge: Spreadsheets & Expired Certificates

Historically, transport companies managed regulatory compliance using disjointed spreadsheets, physical paper binders, and manual calendar reminders. This created massive operational risks:

• Audit Exposure: A single expired DBS certificate or missed MOT inspection could result in council sanctions or lost municipal contracts.
• Slow Paperwork: Onboarding new drivers or passenger assistants took days of back-and-forth email attachments and physical scanning.
• Zero Real-Time Visibility: Council transport officers and company directors had no centralized dashboard to verify route coverage and staff credentials before morning school runs.

The Solution: Serverless Edge Architecture on Cloudflare

Apex Sites designed and deployed Transport Compliance (compliancetransport.uk)—a custom, enterprise-grade web application built with Next.js, Cloudflare D1 (serverless SQLite), Drizzle ORM, and Cloudflare R2 Encrypted Document Storage.

1. Automated DBS & Compliance Tracking

Every driver and escort is monitored via an intelligent expiry matrix. The system automatically flags documents nearing expiration at 60, 30, and 7-day intervals, preventing compliance lapses before they happen.

2. Zero-Lag Edge Database (Cloudflare D1)

By leveraging Cloudflare's global D1 SQLite database, route managers and dispatchers experience sub-millisecond query performance when allocating staff to daily school routes.

3. Encrypted Cloudflare R2 Document Vault

Sensitive identity documents and medical certificates are securely uploaded directly to private Cloudflare R2 buckets with signed access URLs, eliminating GDPR vulnerabilities associated with emailing personal data.

Business Impact

Transport operators running the platform have eliminated 100% of compliance paperwork overhead, passed council audits with zero infractions, and streamlined daily operations across dozens of municipal transport routes.

Need a custom compliance, database, or workflow portal for your enterprise? Contact Apex Sites today to discuss your technical requirements.