February 4th, 2005


userinfo senji
2005/02/04 12:39:00 - Grrrrrr.
Here at work we have something that on good days I deign to call a database. One of the procedures involving this database involves importing a file listing from a CD.

File listings are produced using ls -l. For those of you reading in black-and-white the output of ls -l on Linux usually looks something like this:
-rw-rw-r--  1 jdamery  jdamery   7322 Dec 21 16:53 alice.txt
-rw-rw-r--  1 jdamery  jdamery  17661 Sep 28  2001 apple.jpg
Now, the database, being a pile of utter shite, expects lines of the former variety, and this has unfortunately become entwined in that bit of the code to the extent that one can't simply modify fix this bug (which is really a bug in the original specification -- using ls -l listings was a stupid idea in the first place).

This hasn't been a problem in my living memory (as maintainer of this code); then in the last three days three different cow-orkers (out of four) have tripped over it.

To complete the set, a few weeks ago steph had a problem which took a plausibe amount of tracking down because his LANG settings were causing ls -l to produce an output more like this:
-rw-rw-r--  1 jdamery  jdamery   7322 2004-12-21 16:53 alice.txt
-rw-rw-r--  1 jdamery  jdamery  17661 2001-09-28 14:37 apple.jpg

Current Mood: [mood icon] irritated
Entry Tags: geeky, rant, work

< | 2 glosses | comment | > )

userinfo womble2
[userpic]
2005/02/04 21:52:32
The latter ought to be easier to use since the SQL standard says dates should be written in ISO 8601 format. Unfortunately the two most popular RDBMS vendors don't seem to pay much attention to said standard.
reply | thread )
userinfo senji
[userpic]
2005/02/04 21:55:46
SQL?

Hahahahahahahahaha.

No such luck...
reply | parent | thread )

< | 2 glosses | comment | > )

Grrrrrr. - Squaring the circle...

> log in
> recent entries
> fiends
> archive
> toothywiki page
> profile
> new entry
> recent comments


> go to top