Pat Gunn (dachte) wrote,
Pat Gunn
dachte

PostGrateFUL

I just spent about two hours tracing a bug in this old scheduling thing my research group uses to manage some local resources. Given that it's an entirely private internal resource, and there are endless bits of technical cruft that I've been working on, replacing it has been a low priority. Recently it's stopped allowing repeated reservations though, meaning scheduling all tuesdays at 4:30 for four weeks week requires people in my group to do that multiple times. The thing is written in PHP, and so like most PHP programs it's an ugly hack written by people who probably can't really program. It eventually traced to the software not being careful with its SQL and trying to insert an empty string into an integer field. At some point in the past, PostgreSQL silently converted that to an integer, and an upgrade fixed that behaviour, which unfortunately broke the scheduler (and revealed its utter lack of error checking). Just like some weird pointer bugs in C I've tracked down over the years, I have to repeat to myself that debugging builds character... even in PHP. At least now I can go back to programming interesting things in pleasant languages.. or working with brains.

I'm still hoping to hear back from some people who want to go see VNV Nation, Pirates of Penzance, and all that.

I have a growing hankering to eat at Abay again. Mmm... Ethiopean..

Tags: tech
Subscribe

  • Still alive

    Been feeling a bit nostalgic. Not about to return to LiveJournal - their new ownership is unfortunate, but I wanted to briefly note what's been up…

  • Unplugging LJ

    It's about time I pulled the plug on the LJ version of my blog: 1) I'm much more active on G+ than I am with general blogging. I post many times a…

  • Mutual Trust

    I don't know which should be considered more remarkable: That a cat should trust a member of a far larger and stronger species that it can't…

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments