Tag Archives: Work

Abandoned code projects

One of the sad things about open source software is the process of working on some code, feeling like it’s going somewhere good and is useful to people, but then at some point having to abandon it. Normally just because … Continue reading

Posted in Programming | Tagged , , , , , , | Leave a comment

I’m redundant

This week is the first time for seven years that I’ve not had a job to go to (and not been on holiday). So of course I’m sitting at a computer working on some code, drinking a coffee. The location … Continue reading

Posted in Miscellaneous | Tagged , , , , , , | Leave a comment

What to do (in life)

I’ve been reading Quiet by Susan Cain, and her three steps (p. 218) to figuring out what one should do in life resonated with me: What you loved to do as a child; The work you gravitate to; and What you … Continue reading

Posted in Reading | Tagged , , , , | Leave a comment

Stop inventing new ways of doing things

Every so often I write this same thing. It’s Monday (any Monday) and so it’s time to write it again. The solution to very few problems is to write more code. Usually, it is better to write things in English, … Continue reading

Posted in Programming | Tagged , , , , , | Leave a comment

Today, it seems to me that the incremental construction approach is best. Don’t tear everything down and start again! That’s slow, and will never result in an improvement overall — some parts will be better, but others worse. Instead, find … Continue reading

Posted in Status updates | Tagged , , , , | Leave a comment

Stop inventing new ways of doing things

Every so often I write this same thing. It’s Monday (any Monday) and so it’s time to write it again. The solution to very few problems is to write more code. Usually, it is better to write things in English, … Continue reading

Posted in Programming | Tagged , , , | Leave a comment

Coffee

Roll in to work, settle in for half an hour or so, and then head to the tearoom to make a cup of coffee. A good way to get one’s head in for a nice morning building databases. But that’s … Continue reading

Posted in Miscellaneous | Tagged , , | Leave a comment

Preventing duplicate rows in a tabular HTML form

I am working on a bespoke issue-tracking system at the moment (not for code issue-tracking, in case anyone thinks we’re cloning Redmine; although there certainly are overlaps…) in which each issue has a list of personnel, each of whom have … Continue reading

Posted in Programming | Tagged , , , , , , , , | Leave a comment

West 86th – Paperwork Explosion

“Machines should work, people should think.” The message repeats itself several times; it’s the core of the film’s techno-utopian vision. We can imagine IBM executives and lawyers and public relations agents sitting across a table from Jim Henson telling him … Continue reading

Posted in Reading | Tagged , , , , , , | Leave a comment

Finding all date ranges (which may be open-ended) that overlap with a given range

Given a database table listing events and their date ranges: events { id, start_date, end_date, … }, where either or both of the dates can be null, how is one to find all of the events that fall within (even … Continue reading

Posted in Programming | Tagged , , , , , , , | Leave a comment