My Brush With RSI

RSI (Repetitive Strain Injury) is the bogeyman of software developers’ worst nightmares. I think everyone knows someone, or of someone, who was once a great programmer and is now a primary teacher, porter or some such, and all because of this RSI thing. So here’s my experience, because it came true and happened to me.

My experience

I have typed for in excess of ten hours a day, for weeks at a time, at a number of times in my life. Since graduating three years ago I’ve worked exclusively in development of different kinds. Since long before that I have been able to touch type and took jobs as a temporary secretary and typist during my university holidays. So I’ve had a fair amount of exposure to serious typing requirements in the past and no problems.

I first noticed a problem about three months after starting a new job, I had aches and tingles in my fourth and little fingers in both hands. This turned into a feeling of having my hands attached to my arms wrongly – I kept trying to “click” my wrist joints into place all the time and it was getting quite painful. We do have funny furniture at work since the company’s main business is manufacturing furniture, unfortunately not for offices1, and I just couldn’t make it fit me.

I requested a review of my workstation and over the next few weeks a series of people came and measured the space, prodded me and my chair around, fidgeted with my keyboard and generally wrung their hands in despair. It took five weeks for any modification to be made to my desk and by that time I was on some very strong anti-inflammatory medication following a diagnosis of tendonitis and eventually had to call in sick for a few days as my hands were so painful I couldn’t even put the mon the keyboard. I’d like to point out at this stage that I am not in any way criticising my employer, my work area is hard to modify and it is a large organisation which by definition means that it takes time for the bureaucracy to get its internal cogs turning.

When I went to see the doctor I had pains in my fingers, wrists, elbows and also kind of between the two bones in my arm (like what you get after playing badminton when you haven’t for ages). I also lost all grip in my hands, I couldn’t get the top of a bottle of milk or squash or hold anything heavy (like a pan of water). It was horrible but he assured me that I was unlikely to suffer lasting damage and prescribed anti-inflammatories and as much rest as was possible. By this time I wasn’t posting to this site, working on any of my other coding projects, or even doing any crochet. Even holding a book to read was quite painful!

After my desk had been modified, my hands immediately became much less painful although discomfort remains today (two months later). My employer had me see their doctor and he advised that the damage to the tendons was likely to take some time to recover and I might expect some discomfort for a couple of months. In fact this is the case and I am now finding that an ordinary wrist support helps quite a bit, but my hands are painful after a few days of typing. Coding and sql-querying are much worse than straightforward prose, such as this article, I think because the keyboard is laid out to make words easy and punctuation not necessarily so!

At home I use the laptop and sit wherever I like – usually on my feet, sounds daft but I’ve coded for years curled into a ball and it seems to work! I use an external shallow action keyboard (like a laptop one, the keys don’t go down very far) placed on my knee on a cushion which seems to bring it to a comfortable height. I use Opera which can be controlled pretty much entirely from the keyboard, its got plenty of keyboard shortcuts and also spatial link navigation where you just hold down shift and press the arrow keys to navigate a page’s links. Its great and means I don’t have to use a mouse – I don’t think its the mouse that’s the problem but switching between the two certainly provokes a twinge.

In Conclusion

Well I’ll update this article as things improve but for now I think its enough to say that I’m still programming and feel that I can continue to do so as a full-time occupation. I am still suffering the same pains but I was warned it might take time to heal so fingers crossed (I can still do that!) that’s all it is. I wanted to write about this as its a big issue for programmers and other keyboard-users and I really felt I benefitted from their stories and honesty. I almost feel like the whole thing was a bad dream, and hopefully that’s all it will be in the future – just a dream.

1 Actually we make kitchens, bedrooms and bathrooms, so the offices are miscellaneous drawers with a kitchen worktop on top – it works a lot better than it sounds!

A Tale of Two Jobs

Well, not an actual tale, exactly, but some general anecdotes.

Since moving “oop north” (to Leeds, West Yorkshire, UK), my partner and I have job-hunted once each. Once for me when I relocated up here, and once for him just at the moment as the fixed-term contract that brought him here in the first place has ended. In both instances, we’ve ended up with two good offers and no real way of choosing between them.

The trouble with jobs is that you can never really know how they will turn out until you’ve been there six months. This isn’t an option when you have 24 hours to make a decision that will affect your day-to-day life for the next two years or so, so how can you pick?

Criteria for choosing

This can be straightforward. If you have large credit card or mortgage payments to keep up with, or an expensive habit like an extreme sport, then probably you want the one with the biggest paycheck. If one job is a step on the ladder or uses skills for a job you want to do one day, then take it, even if its less money. If one job is an hour-long commute and the other is a walk across the park, question yourself whether any benefit from the further one can outweight the sense of self you will lose from that kind of journey. If the recruiter annoys you enough then you might allow that to help you decide (I have turned down interviews before purely because I couldn’t face talking to the recruiter again!). If one company is straight with you and calls when they say they will, then that will probably give you a good feeling that you mean what you say the rest of the time. If you just have a good feeling about one job, environment or set of people, then follow your instinct – in this case that is your best indicator.

Once you’ve made your choice, train your brain to stop wondering “what if”? Even if the job you chose doesn’t work out the way you wanted, you get there and the people who were so friendly when you were shown round seem to have had their personalities surgically removed, or the training and development policies have been allowed to mysteriously evaporate, you must never wonder what might have been. For down that path leads despair.

Difficult choices

Personally, I couldn’t really tell you why I chose the way I did this time around. The two jobs used different subsets of my skill set and neither had any obvious progression with them although both would be great stepping stones for when I grow up and decide what I want to be. I can give lots of pros and cons for either choice. Wake up in the morning, and see what you feel, then act on it immediately. After six months in this job, its working out OK, and who’s to say what would have happened if I’d chosen differently? It is our instinct to think that we might be missing out, that the grass is greener elsewhere, that’s what makes us take risks and move on to the next place at all!

I spoke to a guy in a bar last night who told me that when he left university, he’d had two job offers – one for a web company and one for a games company. The web company offered more money and he took that job, but he’s always wondered what it would have been like to make games for a living. My advice: just don’t wonder! [1]

1 Actually I told him he had made the right choice, I did work in games for a while and although it was fun, it is hard work and totally different to the “normal” software industry, I’m glad I did it but I’m also glad I’m doing something else now.

Recursive Queries in Oracle

I’ve come across a very neat trick in Oracle that I thought I’d share. Its useful for situations where you can have circular references in the data diagram, for example when the table includes a column which is a reference for another entry in the same table. Usually it would be necessary to write some function which could be called recursively and allow you to traverse this tree layout, however in Oracle there is the CONNECT BY PRIOR syntax.

The users and groups example

Sticking with my earlier example let’s say I’ve got an employees table and the employee can have a manager, which is an employee

users

ID USERNAME FIRST_NAME LAST_NAME MANAGER JOB_TITLE
1 esme Esmerelda Jones   Chief
2 rose Rose Micklethwaite 1 Queen Secretary
3 simon Simon Hirst 2 Secretary
4 tom Thomas Pockleton 1 Assistant Chief
5 miranda Miranda De Silva 4 Chief Assistant to the Assistant Chief
6 emily Emily Smith 2 Secretary
select first_name || ' ' || last_name, level
from users
connect by prior id = manager
start with id = 1

Will output the list of people followed by their reports. We can distinguish who is where in the tree using the magical column “level” which is available when we connect in this way. I’ve used the level to indent the name column by two spaces for each level down the tree the person is and to show their job title:

select lpad('  ', (level - 1) * 14) || first_name || ' ' || last_name, job_title
from users
connect by prior id = manager
start with id = 1

The Alt-Tab-while-you’re-waiting Trap

Today I’m working on a complicated database driven web page. I edit the source using vim on the main file server. In order to get the file onto the webserver, I then quit out of the file and a script checks my syntax and ftps the file into the correct location on the webserver. Once its there, my prompt returns and I know its time to refresh the web page. Which is interesting, but if you are still reading then you must be wondering what my point is.

Its this, the file check and write takes too long. Its not ages, its like, seven seconds. But its long enough for me to jump to the other window (or in this case, tab) and read the next headline in my feedreader, or the message in my chat window … and you can guess what happens next! I read the article, or reply to the message, or whatever. About three minutes later (if I’m lucky), I’ll remember to refresh the page, check my changes and go on with the task in hand.

This is why all programmers need fast hardware and efficient tools to develop with. My waiting attention span just isn’t long enough to wait more than about three seconds for compile/upload/reload/whatever else is needed. I think I can multitask but actually I end up distracting myself completely!

Speaking of which, my upload is finished ….

Compulsive Multitasker

Do you know someone who seems innately unable to focus on one thing? They can only complete a task when there are twenty others vying for attention and even then they’re flitting between them like a lizard.

You know the person I mean, you call them to ask if they want to go to the cinema, they don’t answer the call so you leave a message. They return the call from the car dashing between a meeting and the supermarket and explain they would love to go to the cinema with you, and can schedule a 2 hour slot on Thursday, between evening class and preparing for a dinner party the next day. This sliver of time means the choice of films is reduced, and while waiting in line to buy tickets, the person is checking their diary and calling their mother. By the time you wave them goodbye, you’re exhausted and wondering how they ever get anything big done when they can’t make space in their lives for one thing at a time. Well here’s the revelation:

I am that person. The only way to get me to do something is to present me with 20 harder and equally urgent tasks. There’s no need to shuffle my priorities to facilitate task switching, I will just switch. Somehow I am the embodiment of that famous phrase or saying “If you want something doing, ask a busy woman”. Give me one thing to do and no deadline, and it will probably never get done. Show me an impossible task list and I can do easily ninety percent of it. Here’s another revelation:

I like new paragraphs in the pauses I would use when speaking …. no! That’s not what I’m supposed to be saying! My next revelation is that I don’t understand why this is the case. I’m an energetic and organised person, why isn’t my throughput of tasks constant? The resources available to me are more or less constant, I’m the same person all the time, but somehow unless I’m being stretched either by workload or task complexity, I just can’t seem to keep the volume of activity up for long.

Perhaps its to do with momentum. The harder or longer your to-do list is, the more it weighs and the faster you have to go to get through everything. So once you get moving you just roll and roll. That’s my theory.

Regular Expressions in Oracle

I need to operate on a big table with lots of records, but only on rows where the primary key starts with a number. Because obviously its a good idea to differentiate types of records in this way …. only joking! Its just one of those little tasks that crops up from time to time.

The Fast and Dirty Way

select code
from products
where substr(code,1,1) in (0,1,2,3,4,5,6,7,8,9)

Oracle Regular Expression Method

select code
from products
where regexp_like(code,'^[[:digit:]]')

Further Resources

I got this from this article on technology and also the definition of some of the character classes from this very helpful resource on psoug

Good Advice for Life at the Office

I came across this when reading an article on Mike’s site yesterday:

_“The best advice I ever received from a manager is that it is easier to get forgiveness than permission.”

The article is at Top 3 Ways to Fight Bureaucratic Inertia in IT and it makes for interesting reading. More than once I’ve had projects cancelled or stalled indefinitely because of two superiors’ inability to agree on the requirements and Mike’s article has given me some ideas on how to manage this type of situation in the workplace.

How Has Netball Changed Your Life?

Recently, an email went around the netballing fraternity asking for stories of how netball has changed your life. I put together something to send back to them and thought I’d share it here too.

This is going to be a long story … netball has accompanied most of the major changes in my life so far, and I’m only 25!

I’ve played netball on a regular basis since going to secondary school at the age of eleven. As I was a good 6 inches taller than pretty much everyone else, I was put at goal shooter. I wasn’t any good at it but I was very keen and after a couple of years of my mum cringing on the sideline at my hopeless efforts, the penny dropped and I actually got quite good. That’s lesson one, most things can be learned with enough perseverance.

Throughout my teens I played a lot of netball at a high level, representing my club, county, school and even region. I met a lot of people from different walks of life and sort of floated through my teens with fewer distractions than most. With no saturday job (because I was always on court) and no late night (always got a match the next day), the scope for getting into teenage scrapes was much diminished. At the time I thought I was missing out but now I’m not so sure that was the case. I travelled all over the country and went to different events, meeting women of many different ages along the way.

When I accepted my place at university, in with the forms was a leaflet from the AU, asking me to tick which sports I was interested in, as there were introductory sessions in Fresher’s Week. So off I toddled, at 10am on the first morning after arriving while my peers were nursing hangovers, and met the girls. Some of the girls that were there that day are still my closest friends. We laughed, cried and partied together. Involvement with the netball club at university transformed me from the schoolgirl who couldn’t hand in her homework on time (ever) to a young woman with a degree in engineering who started her own sports club and organised information systems for a large campus event. I have learned that I’m a leader, a team player, and someone who can get things done. Without the sport and the other girls in the club I feel sure that I’d have eaten better, had far fewer injuries, rung my mother more often and probably got a lot more sleep while I was at university … but I wouldn’t swap it for the world.

Now, three years out of university, I’m on to my third job, my fourth address and my third netball club as well. In every place I’ve met women and girls that have been welcoming, supportive and also a lot of fun. They all have their own reasons for playing, but together they make the club(s) what it is. I’m now starting my first full season with the new club and look forward to another thirty years of this (at least!)

About Blogging About Work

Until now, I’ve avoided blogging about work in pretty much any way. I’ve written about technical stuff that have come up at work but I haven’t written about much beyond that sphere, and even that is only so that I don’t have to hunt for the information next time I run into the same thing and so that others can find the information in the event that google ever admit to having heard of me. I am blogging under my real name (more or less) and I’ve heard enough horror stories of people getting dooced to be shy of this topic.

Until now.

In this day and age, work is a big part of our lives. When I socialise with friends, we mostly talk about who we are and what we do – our occupation is our profession and forms a big chunk of our entire identity. Certainly it is a large portion of who we are today – our selves without the bit that comes from how we got here and so mostly takes account of what we are currently making of life.

Its strange that this subject eludes discussion here, in our household we’ve had more than our fair share of employment-related excitement over the last year – including redundancy, contracting, unemployment and a 200-mile relocation. As an issue, work/jobs/employment/career has never been very far from my consciousness.

So my new resolve is to stop being hung up about this, to write in the abstract about work in relevance to our lives, and to never ever rant about any current workplace, colleagues or customers. Wish me luck!

the trouble with being tall

I’m tall. Not landmark-sized but well above the average for a woman (5’11’). My role model is Allison Janney who is taller than me again and interviews wonderfully on the subject of tall women. I’d like to outline the main points of having this personal feature.

Good Points

  • Not many people can tower over you without standing on something
  • People assume you are confident, which is useful if you wanted them to assume this (such as at a job interview), but can be a pain the rest of the time
  • It helps on a netball court
  • People don’t have to stoop to hear what you are saying

Bad Points

  • Its very hard to hide behind another girl
  • When holding an umbrella and walking in the rain, unless the rain falls vertically, your feet are still going to get wet because there’s so much space between the umbrella and the floor
  • If you wear women’s clothing, you risk looking like you are either a cross-dresser or a teenager that grew too quickly
  • If you wear men’s clothing, you will actually look like a man
  • If you go to specialist shops to get clothes to fit (rather than marginally longer leg lengths), you will spend a lot of money on clothes
  • Pretty shoes are never pretty by the time they are big enough to get your feet into
  • It is very difficult to buy ladies’ gloves to fit
  • When you are growing up, you are going to spend 5 years being 6-12 inches taller than any of your dates

The bad list is longer than the good list, but I wouldn’t swap my height for anything!