The Person Who Knows SQL built a freight quote calculator

“The API isn't documented.”— Priya, The Person Who Knows SQL

Reason:

Because the deletion process requires a ticket, a manager and 3 approvals. Quietly rolled out to three countries.

Built by:

Priya, a controller

Build time:

one weekend

Built with:

Kafka, for reasons lost to history

Database:

Supabase with the service role key in the frontend

Authentication:

the password policy requires one uppercase letter and optimism

Deployment:

running behind nginx config copied from Stack Overflow

Responsible:

Plant Manager, who calls it "the little tool"

Documentation:

an architecture diagram containing a box labelled "magic happens here"

Security situation:

the last security review happened before the application existed

Future disaster:

It will cause Security to ask "what application?".

Age: 2.8 years · originally expected to last 14 days · 2 owners so far · survived 3 reorganisations · last meaningful change 74 days ago

Rated common mostly because: alive 72x longer than intended, 2 departments depend on it, 1 users.