Dog Shelter Team built a fleet mileage tracker

“The database isn't exposed. I think.”— Chen, Dog Shelter Team

Reason:

Mainly because the spreadsheet has 192,892 rows and 31 tabs. Started as Customers_backup.xlsx with a script attached.

Built by:

Chen, an intern

Build time:

one weekend

Built with:

WordPress with eleven plugins

Database:

a database running in a container called final-final-db

Authentication:

the API accepts requests from anywhere with confidence

Deployment:

on a VM created for a workshop in 2023

Responsible:

an agency acquired by another agency

Documentation:

an Excel tab called Instructions

Security situation:

no security review, no plans for one

Future disaster:

It will fill the disk at 16:15.

Age: 3.5 years · originally expected to last 3 months · 4 owners so far · survived 3 reorganisations · last meaningful change 19 days ago · original builder left 1247 days ago

Rated mythic mostly because: €4.5m per year, 639 users, 74% chance of becoming business critical.