Offer Accepted

Well, we had an offer accepted on a house yesterday which is very exciting! This morning we instructed a solicitor, he will do all the legal stuff for us. I’ve also spoken with the mortgage provider and we’re off to see them on Saturday morning. We have to provide a load of paperwork like payslips, bank statements, ID and proof of address so something tells me that tomorrow night will be a frantic root through the flat to find all the relevant documents!

All in all I’m quite excited but trying not to be too excited as there is plenty of scope for it all to fall through! It will be really great to have a place of our own though – all our stuff is in storage at the moment and I can’t even remember what furniture we really have. One thing is for sure, its going to look quite lost in the new house as all our stuff was bought for a small, modern 2-bedroom terraced house. Now we’ve got a 1930s 3-bed semi and its on quite a different scale!

Arranging a Mortgage

Well, we’ve taken the first step and been to see a few banks about getting a mortgage. I have to admit that we did stick to the big names – Halifax, HSBC and Yorkshire Building Society. My partner is a contractor with short-term contracts, which on paper makes him look quite unemployed! Yorkshire Building Society said they couldn’t recognise his income which ruled them out but the other two were very helpful.

An appointment at HSBC later [1] and we’ve got an agreement in principle for way more than we intend to borrow and its off to the estate agents.

We’ve now seen a house we like but its a bit (very) dilapidated inside so we’re just thinking of a number now and will be offering later today or tomorrow.

edit: update! see offer accepted

1 That was 29th August, 2006, for reference. We might want dates when its all over!

Crochet Love-Knot Wrap

You might think that I’ve been a bit quiet on the crochet front recently … and you’d be right. What’s actually happening is that I have been working on a surprise project for my sister’s birthday and didn’t want to post about it until I had given her the present1!

So here goes. I made for my little sister’s 21st birthday last month a wrap. Its rectangular, the dimensions of one of those pashmina scarves. The stitch is a “lover’s knot” which is much easier than it looks. I had a hard time getting started with it but once you learn the stitch its quite easy. The hard part was easily keeping all the loopy stitches the same amount of “loopiness” so the grid stayed the same size. Here’s a closeup:

The pattern was originally for a triangular shawl, it starts from a point and grows out diagonally, but it worked perfectly well to put corners in and work it that way instead. The result is much more versatile too – here it is folded in half:

For the trimmings, some basic beads with tassels. I chose irregularly shaped and non-matching beads which worked really well. The wrap itself is cotton DK plus a fluffy 4ply mohair type yarn together and the slightly mismatched beads stop it from looking too tidy:

Any questions please just add a comment and I’ll reply as best I can.

Diet Oracle – working with Oracle eXpress Edition

I’m a big oracle fan, which might seem a bit strange in a world dominated with the LAMP stack and its exclusive use of MySQL or, at a push, Postgresql. That’s not the entire world obviously, that’s my world and it is definitely MySQL-orientated. In the world of work however, I’ve had extensive exposure to Oracle and think its great, so I was very excited when I saw the free mini-Oracle be released earlier this year. These are my first experiences of working with it.

Installing Oracle XE on Windows.

OK so I’m not actually going to use this on windows really but when I tried to install this on Linux I had a major problem right at the outset. There is a choice of either a .rpm or a .deb file to install from and since I had sent my sysadmin to the supermarket, I had no idea which I needed! The windows installer promised to be point-and-click and since I’m actually running Windows on one machine at the moment (grr wireless drivers grr) I was tempted by the idiot-proof windows installer so I grabbed that.

Well, idiot-proof was a gross understatement! I ran the installer, it asked me where I’d like the files put and then to input a root password, and the next thing I know its all done and inviting me to log in. I’ve installed Oracle many times on Windows and believe me, its not supposed tobe this easy. Anyway it works, I’ve been chattering to it on command line and everything is cool. The next step is to get it installed under Linux – it turns out that our Ubuntu server would like the .deb file best, so I’ll try that out and keep updating here.

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