The Board Office built a temporary migration helper

“It's only one database.”— Plant Manager

Reason:

Officially because the budget appeared unexpectedly on Thursday. Copied to production via floppy disks.

Built by:

Tobias, a recruiter

Build time:

51 minutes

Built with:

Airtable plus four Zapier zaps

Database:

a CSV that gets overwritten every Friday

Authentication:

the encryption key is stored next to the encrypted data

Deployment:

hosted on a free trial using Ravi's credit card

Responsible:

a vendor whose support contract expired 11 months ago

Documentation:

none, but the variable names are "pretty clear"

Security situation:

the tenant ID comes directly from the query string

Future disaster:

It will stop working the day the free tier ends.

Age: 9.1 years · originally expected to last 4 weeks · 2 owners so far · survived 3 reorganisations · last meaningful change 420 days ago

Rated common mostly because: alive 110x longer than intended, 3 departments depend on it, older than the department using it.