News: 1653294671

  ARM Give a man a fire and he's warm for a day, but set fire to him and he's warm for the rest of his life (Terry Pratchett, Jingo)

Beware the fury of a database developer torn from tables and SQL

(2022/05/23)


Who, Me? Be careful what humorous messages you leave in your app, for you never know who might see them. Welcome to [1]Who, Me?

Our story today is a return for a reader Regomized as "Philip," who does not have the highest opinion of the sales profession.

"We had three developers," he recalled. "One was responsible for UI, another for the database, and a third for image display and capture."

[2]

"We [also] had a couple of salespeople, one of whom was entirely pointless and the other a classic over-reaching individual."

[3]

[4]

The company's systems were sold to local councils and dealt with property records. Business was good, and the list of clients was growing. Then sales did what sales does best and went hunting for an even bigger payday. In this case from overseas.

The potential client was an Italian council, which had been impressed with the boasting of a salesperson. Before any dotted lines were signed, however, the soon-to-be customer wanted to see this marvelous system in operation. Oh, and could it be in Italian too?

[5]

We imagine all manner of goodness was promised. However, our tale takes place before the time of handy resource files that could be popped into the mailbox of a translation company. The user interface was hard-coded, making a simple switch impossible.

"It turns out, our DB developer spoke some Italian and was pressed into service to translate a few of the important screens," explained Philip, "Enough for a demo and to prove we could do the whole application if needed."

The database guru was less than keen. He preferred to immerse himself in the world of tables and columns rather than user interface wizardry. However, the non-Italian speakers insisted and, to make matters worse, the salesperson had already sold the customer on the idea so something would have to be done.

[6]

Doubtless muttering about stored procedures and index optimization being far more interesting than fiddling with the visuals, the database developer got to work.

"Come demo day and everyone was on their best behavior," recalled Philip. "The developers wore shirts that just about passed inspection, tables were booked in restaurants. The trusty 386 demo machine was fired up and our glorious application creaked into life."

"Of course, even a simple task took time back then and we always covered this delay off with a 'Please wait, database initializing' screen."

Except that wasn't what the text now said. The database developer, doubtless realizing that would be the first text seen, had helpfully translated it. There was some nervous tittering from the guests as the updated text appeared.

"Lasciate ogne speranza, voi ch'intrate."

It appears the database developer was a bit of an intellectual and had elected to drop a well-known quote from Dante's Inferno into the splash screen. In this case, the Italian for "abandon hope all ye who enter here," which was supposedly inscribed upon the gates of Hell (and also Philip's property records application).

[7]September 16, 1992, was not a good day to be overly enthusiastic about your job

[8]September 16, 1992, was not a good day to be overly enthusiastic about your job

[9]How to destroy expensive test kit: What does that button do?

[10]Wi-Fi not working? It's time to consult the lovely people on those fine Linux forums

"Our sales chap explained that the system was still starting up and that great delights were to come, not realizing that our finest moment was currently writ large for all to see."

It reminds this writer of jolly japes in the past where a "secret" configuration screen was inserted into an application with a slider to control performance. The options were: Slow, Really Slow, Glacial, Plate Tectonics.

As for Philip, his tale ends on a happier note. After some ribbing about the professionalism of Philip's team, the Italians liked what they saw and bought a license.

And the database guru? He was left alone with his queries while a translation company was contracted to provide the necessary Italian words.

Ever had a developer's witty joke blow up in front of a client's face? Or had that amusing bit of test data put in an appearance when you least expected? We've all been there – share your stomach-swooping moment with an email to [11]Who, Me? ®

Get our [12]Tech Resources



[1] https://www.theregister.com/Tag/Who,%20Me?/

[2] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2YotbRKdBurwiem1D3xmKrwAAAII&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0

[3] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44YotbRKdBurwiem1D3xmKrwAAAII&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0

[4] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33YotbRKdBurwiem1D3xmKrwAAAII&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0

[5] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44YotbRKdBurwiem1D3xmKrwAAAII&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0

[6] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/databases&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=3&c=33YotbRKdBurwiem1D3xmKrwAAAII&t=ct%3Dns%26unitnum%3D3%26raptor%3Deagle%26pos%3Dmid%26test%3D0

[7] https://www.theregister.com/2022/05/16/who_me/

[8] https://www.theregister.com/2022/05/16/who_me/

[9] https://www.theregister.com/2021/12/06/who_me/

[10] https://www.theregister.com/2021/12/20/who_me/

[11] mailto:whome@theregister.com

[12] https://whitepapers.theregister.com/



Seems to have ended well in this case

BOFH in Training

They got the sale and the developer got his joke, still survived the joke and presumably will not be called upon to do things which do not have anything to do with a database.

Re: Seems to have ended well in this case

Korev

He won't be asked to Rome outside of his area of competence again

Re: Seems to have ended well in this case

Rameses Niblick the Third Kerplunk Kerplunk Whoops Where's My Thribble?

If you try that kind of thing these days you will find that Turin trouble

Re: Seems to have ended well in this case

Pomgolian

Usually without a shroud of evidence.

I've heard all kinds of stories like this

TonyJ

Including a commissioning engineer (this was the early-mid 1990's) who used to think it was funny to upload hardcore porn into the company kit during commissioning, believing it would never be seen or even found.

As you can imagine, it was. I am not sure what the whole story was but he did lose his job, unsurprisingly.

It is simply never a good idea to "hide" something unsavoury inside code or on drives etc. It will eventually be discovered.

Re: I've heard all kinds of stories like this

Pascal Monett

On a much tamer note, I know of a database consultant whe had a thing for the name Alice, and tried to shoehorn that name in somewhere every new job he had. That is why there are a number of servers in the world that are probably still named Alice to this day.

Know your audience.

jake

I damn near killed an idiot who insisted on commenting in Klingon, but only on bits of inline assembler embedded in C ... I wouldn't have cared, but the comments popped up during a surprise visit from the CEO with a couple clients in tow looking to see how their customized version of the code was coming along. The customer knew Klingon. Including the cuss-words.

Re: Know your audience.

Admiral Grace Hopper

I once had the pleasure of attending a marriage ceremony conducted in Klingon. Given the audience here, I'm sure I'm not alone in this.

Just a quick question.

ShadowSystems

If your product is not already available in a language, why did you let the marketing cockwomble survive long enough to complete the sale?

It's a non trivial task to do a proper translation. It costs serious time, money, & employee hours of making sure every last bit of text/graphics have been properly translated lest a mistake cause the client to come after you with a hammer & a very bad attitude.

A previous employer had asked me to do a quick & dirty English>German translation for them. I refused. They promised I'd not get in trouble. I flat out dug in my heels & said hell no. So they got someone else in the company to do it rather than pay for a professional job.

Guess what? The German speaking customer the translation had been for found a few inappropriate translations, was _seriously_ not amused, and threatened to sue for libel. Why? Because the German words for some things is only a letter or two off other words that are slang for some very NSFW sexual acts with animals. Want to guess what the customer saw in screens that would have been their-customer-facing? Not. Good.

The employee that did the translation got thrown under the bus. I felt bad for them because of that fact, but then I also told them not to do it unless they got that promise in writing first.

If the sales turd sold the product with a promise that it would be made available in a different language, either take the cost of that professional translation out of said sales shit's pay, or publicly stand them up against a wall & shoot them with squirt guns filled with skunk stink. One way or the other, the dipshit needs to be made *painfully* aware never to do such shite ever again. =-|

Re: Just a quick question.

My-Handle

I used to work for a large multi-national company who sold websites alongside their main business. It was all highly templated stuff without many bells or whistles, the better to mass-produce them. Of course, said company also had an absolutely huge sales team, a few of which appeared to have no kind of respect for, or understanding of what a template was.

So despite the fact that the whizziest feature we could offer was a slide show on the Home page (and nowhere else), the sales team were promising all kinds of things like user accounts, custom image upload galleries, the works. And whenever the back office couldn't fulfil said ludicrous promises, the customer's wrath always came down on us. Senior management didn't bother to reprimand the sales team, because "they were the ones making the money".

I quickly arrived at the opinion that said company's name rhymed with "Hell" for a very good reason.

Re: Just a quick question.

ComputerSays_noAbsolutelyNo

Nobody knows a foreign language well enough to do a proper translation, except trained professional translators.

It's one thing to speak with english words if you are at a conference or somewhere else; but it's an entirely different thing to do translation.

My significant other is a professional translator, and the things that the non-translator people come up with when they translate themselves are at best hilarious at worst cringy and wrong.

"The component X has been foreseen to do Y".

False friends are not your friends, when it comes to translating languages.

Re: Just a quick question.

GlenP

As a multi-national we have various native language speakers on our staff but still generally use professional translators for anything important (either internal or external).

Oops

Anonymous Coward

i was once explaining to a vague acquaintance of my wife's the size of the village in which I was living at the time, emphasizing how tiny it was by means of the illustration "Its so small the vicars wife has to double as the village hooker". With grinding predicatbility, the acquaintance smiled and calmly announced that her husband was indeed a vicar. I hid under a rock.

Re: Oops

Hans Neeson-Bumpsadese

I'd like to think that I'd have had the presence of mind to follow that with "...and elsewhere on the women's rugby team the postmistress doubles as the scrum half..."

Text files

Caver_Dave

Back in the 1990's I produced a lap timing system (computer, timing beams, radio links, in-car telemetry) primarily for F1, but over the years it filtered down to other formulas and bikes.

In the computer there was one EPROM with the 64K of assembler code and the other EPROM socket was loaded with the text that would appear on the screen.

However, the laptops (Epson PX4) had limited screen size and text had to be abbreviated on almost ever screen.

Everything was fine until a customer insisted that it had to be translated into French. (At their Magnicor site everyone had to speak French all of the time, despite the fact that the majority of the engineers were English.) Now, I could speak a liitle French, but even in those days I had enough sense to get a native French speaker to work out what the abreviations would have to be.

I never had to have it translated into another language, but I received so much qudos for having the text in the seperate EPROM. I even confessed that it was only there because I had run out of space on the first EPROM and text was the best thing to place in a 'slower to access' second EPROM.

Don't forget to proofread

PM from Hell

I Worked with a Welsh Council many years ago who were sold a Council Tax application.it needed all customer facing documents translating into Welsh.Testing had gone reasonably well especially as the proposed legislation had not been passed before The application was written so changes were required several times a week. It took weeks and weeks to find an English / Welsh Translator willing to take the job on due to the tight timescales and the technical nature of the documents. The translator finished and handed over the translations, it had been a tough job as the text had to fit into the same size text boxes as the original English.

On handing it over she asked the senior manager who he had engaged to do the proof reading. Needless to say another several weeks were spent finding somebody qualifies to perform the proofreading

Timescales were incredibly tight as Bills needed to be sent out on time.

spireite

Alpha demos are usually peppered with sofwtare landmines.... and everyone does know it.

I remember having a wait box that appeared for an alpha demo, that rather than saying 'Please wait - processing' said....

'Always look on the briiiiiight side of life, duh, duh....duh,duh,duh, duh, duh duh'

That certainly lightened up a room....

Bodge City

deanb01

Worked for a UK based fruit machine manufacturer a few years ago (Barcrest) that was purchased by a US gaming company (IGT). I was the sole developer on a project to put some more interesting aesthetics on their frankly dull one armed bandits. This involved replacing the neon-tube light box above the game with one that had its own CPU. The Barcrest code was a mixture of Forth and 6809, so plenty of voodoo involved.

Got ushered into my bosses office at a later date with regards to my source code. Apparently the Nevada Gaming Commission took a dim view of some of the comments in my code, for example:

; Entering Bodge City in a bus with no brakes

In my defence, I wasn't told my source code would be submitted.

If you wants to get elected president, you'se got to think up some
memoraboble homily so's school kids can be pestered into memorizin'
it, even if they don't know what it means.
-- Walt Kelly, "The Pogo Party"