Giving up

| | Comments (2)

So the plan for the weekend (or at least part of it) was to put all my usa photos into a mysql database, and write a set of scripts to display the files in various indexes.

Yah like that was ever going to happen.

Spent the entire morning staring at my excel file trying to figure out how I'd do it. Now sure, if it were just a directory of photos I'd have no trouble. But I have my own photos, panoramas I've created, scans of my parents photos, mpg movies, as well as maps, daily routes, state routes, extra images of National Park "splash" pictures, and some images have been used more than once, while others were added in special orders at the beginning of states etc.

The more I stared at it, the more I realised how complicated it was, and how many exceptions would need to be made to get it to do what I wanted it to do.

So I thought stuff it, I'll just make 42 day index pages, and 14 state index pages. Generate the actual code in excel (where all the data is) and hardcode it into html. Sounds like a copout I know, but I could see myself never ever getting these photos online (and it was a *year* ago that we were away).

Then I thought I should probably add some more descriptive notes to some of the images, and of course that takes hours too. That's what I did most of the afternoon/evening.

So by the end of the weekend you never know, I might actually have it done.

Unless I get the urge to go through everything again putting in Google Maps references... :)


Fiona said:

that's why us mortals use prewritten, preinstalled, all I wanna do is upload and place the comment on the photo, scrpities


when/ do yo we get to see said pics?

June 12, 2005 9:48 AM


kazza said:

one day .. soon... honest!! ;)

June 12, 2005 10:52 PM


Leave a comment

Kazza's "Boring Life Of a Geek" aka BLOG

IT geek, originally from Sydney, moved to Canberra in 2007. Married to "the sweetie", aka Stu. Prolific photographer, Lego junkie and tropical fish keeper.

Kazza the Blank One home