Facilities built a churn predictor trained on 40 rows

“IT would have taken months.”— Chen, Facilities

Reason:

Because the official form has 41 fields and not the one that matters. With 2 users, one of whom is the CEO.

Built by:

Chen, a field technician

Build time:

6 evenings

Built with:

Streamlit

Database:

a CSV called Suppliers_new2.xlsx in a shared drive

Authentication:

IP allow-list containing 0.0.0.0/0

Deployment:

in a Docker container nobody can rebuild

Responsible:

a contractor invoicing €1335/day through a third party

Documentation:

comments in the code, in a second language

Security situation:

it is indexed by Google. All of it.

Future disaster:

It will duplicate every record after a timezone change.

Age: 9.2 years · originally expected to last 7 days · 2 owners so far · survived 2 reorganisations · last meaningful change 823 days ago · original builder left 2024 days ago

Rated common mostly because: alive 482x longer than intended, €132k per year, the builder has left.