Logistics built a shift planner that emails PDFs

“It's more of a tool.”— Group Controller

Reason:

Mainly because the temporary solution has survived 7 managers. Built in 4 evenings and demonstrated immediately afterwards.

Built by:

Nadia, a key account manager

Build time:

an afternoon, mostly

Built with:

Airtable plus four Zapier zaps

Database:

a Postgres database called main-old containing 8 years of production data

Authentication:

the admin route is called /secret

Deployment:

running on an EC2 instance somebody resized manually

Responsible:

Ravi, who only knows the frontend

Documentation:

a Loom video recorded at 1.5x speed

Security situation:

the last security review happened before the application existed

Future disaster:

It will process the same invoice 5 times.

Age: 9.2 years · originally expected to last 7 days · 6 owners so far · survived 3 reorganisations · last meaningful change 3 days ago

Rated common mostly because: alive 479x longer than intended, older than the department using it, 1 accidental connections.