Logistics built a fleet mileage tracker

“The database isn't exposed. I think.”— Ravi, Logistics

Reason:

Because the spreadsheet has 40,615 rows and 32 tabs. With a roadmap in the README, last touched 411 days ago.

Built by:

Ravi, an intern

Build time:

43 minutes

Built with:

Python and a cron job on a laptop

Database:

Redis, but used permanently

Authentication:

Basic Auth over plain HTTP

Deployment:

on a VM created for a workshop in 2019

Responsible:

nobody. It has no owner.

Documentation:

comments that say "do not change this"

Security situation:

the security review consisted of opening DevTools

Future disaster:

It will become part of the company's "digital core" slide deck.

Age: 2.3 years · originally expected to last 3 weeks · 2 owners so far · last meaningful change 3 days ago · original builder left 318 days ago

Rated rare mostly because: €318k per year, 117 users, 4 departments depend on it.