Get all your news in one place.
100’s of premium titles.
One app.
Start reading
The Guardian - UK
The Guardian - UK
Technology
Charles Arthur

Hey, how long should we make the database field for the middle initial?

One that certainly escaped my recent cull of one-third of all my RSS feeds was The Daily WTF, which subtitles itself "Curious Perversions in Information Technology".

Basically, it's about all the weirdnesses that managements and dumb programmers inflict on each other. Non-programmer may find it puzzling in the extreme, but anyone who's had even a nodding acquaintance with trying to wrangle a project will know that feeling. May even know the people.

It's worth a read for the "SQL Sentences" story (why not store all the SQL commands your company will use in a database, which then gets accessed when you need to do a query, though of course you have a list of access permissions for each query to make sure the person (program) executing it is allowed to).

Though David wasn't around when these changes were implemented, when he came onboard and heard the story he asked the Lead Developer if he'd ever heard of a Stored Procedure before.


"Yeah," he replied, "but I've heard they're a big pain to maintain."


Laughing? (If not, you just left.) OK, and now here's a one-liner:

I found this gem of a field in a database table for storing users' names: MiddleInitial NVARCHAR(255)


What about your favourite Code WTFs? Or sites devoted to them?

Sign up to read this article
Read news from 100’s of titles, curated specifically for you.
Already a member? Sign in here
Related Stories
Top stories on inkl right now
One subscription that gives you access to news from hundreds of sites
Already a member? Sign in here
Our Picks
Fourteen days free
Download the app
One app. One membership.
100+ trusted global sources.