Charlie Hatton About This
About Me
Email Me

Charlie Hatton
Brookline, MA

All Quotes


Howdy, friendly reading person!
I'm on a bit of a hiatus right now, but only to work on other projects -- one incredibly exciting example being the newly-released kids' science book series Things That Make You Go Yuck!
If you're a science and/or silliness fan, give it a gander! See you soon!

They Queryin’ ERRR’BODY Out Here!

(Yesterday was for Bugs & Cranks love, with the bittersweet story of Luis Salazar’s former eyeball in The Cost of Doing Baseball.

And now, look — look with your special eyes — at what’s going on today.)

I wouldn’t have thought that writing technical documentation would be an ‘angry‘ kind of job. Boring, maybe. Soul-sucking and nit-picky and dry, perhaps. But not so much angry.

Apparently, I was wrong.

This afternoon, I was sitting with an analyst in our group who was trying to pull information from a database we keep. He was using a statistical package called ‘R’.

(It’s called ‘R’ because statisticians are evidently intent on making the names of their tools as non-descriptive and web un-searchable as possible. I fully expect the next package to be named ‘4’ or ‘/’ or half a letter ‘K’.

Maybe I should have recognized this ‘angry’ thing before, come of think of it. Remind me not to turn my back on any statisticians wielding sharp pencils in future.)

Anyway, R. I noticed our guy had a web page open to the online documentation, and sat down to have a look. Right at the top of the section was an example query. Every database package in the world has these examples; they’re meant to illustrate how a real-life question would convert to the particular syntax used.

“We’re already doing statistics, for crissakes; our lives are clearly awful enough. Throw us a bone over here.”

So, for example, a lot of packages use examples that have to do with music. They assume that there are data tables with information on artists, CDs, songs and the like, and show how to ask the database pertinent and practical questions like:

“How many CDs were published in a given year?” or

“How many groupies were banged backstage during shows in the East Coast time zone?” or

“Who the fuck put Kenny G in here? Are you people shitting me? Kenny G? Really?

(That last question has no good answer. This is why computers hate us from the bottoms of their cold heartless motherboards.)

But think about it. These examples could be about anything. They’re pulled out of thin air, and whatever things you can think of with relationships of some type to other things — which is, basically, everything — then that can be your example. And the more familiar and close to home the better — I’ve seen queries about movies and actors, beers and breweries, stores and products, zoos and animals, cars and drivers, breads and butters, Laurels and Hardies, locks stocks and barrels, and you get the idea. These can be literally anything.

So what was the query at the top of this R documentation page?

select row_names, Murder from arrests where Rape > 30 order by Murder

Wow. Just wow.

Of all the topics, all the queries, with the entire universe of things to choose from, they chose to answer that urgent pressing question on the tips of all of our tongues:

Yeah, how many places have there been at least thirty rapes, sorted in descending order of murder rate, pretty please with sugar on top?

I’m not making this up. It’s out there in black and white. But honestly — wow.

I mean, first of all, it’s pretty grim stuff. Short of penning examples based on genocide or suicide bombers or something, I can’t think of a darker topic for this kind of thing. We’re already doing statistics, for crissakes; our lives are clearly awful enough. Throw us a bone over here.

Secondly — and maybe this is just me — but I have a policy that I never want to be reading any sort of technical documentation and type CTRL-F ‘rape’ and find any results.

(It’s a new policy, which I set immediately after reading the query above. And I’ve never actually searched for ‘rape’ in any documentation I’ve read in the past.

But I’m sure as hell going to do it now. That shit is crazy.)

And finally — greater than? With everything else wrong with this example, they couldn’t at least look for a spot with less than thirty rapes? Come, now. That’s just piling on.

So that’s what I learned today. There are some really angry, disturbed and possibly currently incarcerated people writing documentation for statistical packages.

But at least they can teach you how to query a database. Which probably won’t help much when you’re violated and buried in the crawlspace under their basement stairs. But it’s something, I guess.

Permalink  |  No Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

HomeAboutArchiveBestShopEmail © 2003-15 Charlie Hatton All Rights Reserved
Me on Film 'n' Stage:
  Drinkstorm Studios

Me on Science (silly):
  Secondhand SCIENCE

Me on Science (real):
  Meta Science News

Me on ZuG (RIP):
  Zolton's FB Pranks
  Zolton Does Amazon

Favorite Posts:
30 Facts: Alton Brown
A Commute Dreary
A Hallmark Moment
Blue's Clues Explained
Eight Your 5-Hole?
El Classo de Espanol
Good News for Goofballs
Grammar, Charlie-Style
Grammar, Revisitated
How I Feel About Hippos
How I Feel About Pinatas
How I Feel About Pirates
Life Is Like...
Life Is Also Like...
Smartass 101
Twelve Simple Rules
Unreal Reality Shows
V-Day for Dummies
Wheel of Misfortune
Zolton, Interview Demon

Me, Elsewhere

Standup Comedy Clips

Selected Clips:
  09/10/05: Com. Studio
  04/30/05: Goodfellaz
  04/09/05: Com. Studio
  01/28/05: Com. Studio
  12/11/04: Emerald Isle
  09/06/04: Connection

Boston Comedy Clubs

 My 100 Things Posts

Selected Things:
  #6: My Stitches
  #7: My Name
  #11: My Spelling Bee
  #35: My Spring Break
  #36: My Skydives
  #53: My Memory
  #55: My Quote
  #78: My Pencil
  #91: My Family
  #100: My Poor Knee

More Features:

List of Lists
33 Faces of Me
Punchline Fever
Simpsons Quotes
Quantum Terminology

...Bleeding Obvious
By Ken Levine
Defective Yeti
Divorced Dad of Two
Gallivanting Monkey
Junk Drawer
Life... Weirder
Little. Red. Boat.
Mighty Geek
Scott's Tip of the Day
Something Authorly
Unlikely Explanations

Full Archive

Category Archives:

(Stupid) Computers
A Doofus Is Me
Articles 'n' Zines
Audience Participation
Awkward Conversations
Bits About Blogging
Bitter Old Man Rants
Blasts from My Past
Cars 'n' Drivers
Dog Drivel
Foodstuff Fluff
Fun with Words!
Grooming Gaffes
Just Life
Loopy Lists
Making Fun of Jerks
Marketing Weenies
Married and a Moron
Miscellaneous Nonsense
Potty Talk / Yes, I'm a Pig
Sleep, and Lack Thereof
Tales from the Stage
Tasty Beverages
The Happy Homeowner
TV & Movies & Games, O My!
Vacations 'n' Holidays
Weird for the Sake of Weird
Whither the Weather
Wicked Pissah Bahstan
Wide World o' Sports
Work, Work, Work

Alas Smith and Jones
Berkeley Breathed
Bill Hicks
Dave Barry
Dexter's Laboratory
Douglas Adams
Evening at the Improv
Fawlty Towers
George Alec Effinger
Jake Johannsen
Married... With Children
Monty Python
Nick Bakay
Peter King
Ren and Stimpy
Rob Neyer
Sluggy Freelance
The Simpsons
The State

Plugs, Shameless
100 Best Humor Blogs | Healthy Moms Magazine



Feeds and More
Subscribe via FeedBurner


RSS 2.0
Site Hosting:
Solid Solutions

Powered by:

Title Banner Photo:
Shirley Harshenin

Creative Commons License
  This work is licensed under a
Creative Commons License

Performancing Metrics

Page copy protected against web site content infringement by Copyscape

Valid XHTML 1.0

Valid CSS!

© 2003-15 Charlie Hatton
All Rights Reserved