Archive for May, 2007

 

Fine Amish Food - pitty about the site

May 21, 2007 in Lame

While working on a bug at work, www.amishfinefood.com turned up in industry ranking results. Now I don’t claim to be familiar with traditional Amish cuisine, but there a few wtf’s here:

  • What’s up with the loading-splash-horse-thingy?
  • indexx.php [sic] ????
  • <marquee> tags! run!
  • Never rely on images alone for navigation: http://www.amishfinefood.com/indexx.php/? (unless, of course, you can degrade gracefully)
  • If basic gist of the Amish way is to shun technology of all forms, just wtf are these guys doing on the Internet?
  • While may have been reluctantly into the use of the Internets as a distribution channel, do the really need to take the amatuer, wtf-are-standards, totally shite ‘traditional’ approach to web development?
  • Try doing a search for a product called ‘%’… I didn’t know SQL Injection was traditional Amish fare!
  • I guess expecting SSL for credit card transactions is just pushing things too far.

Bicycle Victoria: Around the Bay in a Day

May 16, 2007 in Random

I’ve just registered for the Around the Bay In a Day ride being organised by Bicycle Victoria. While I can definitely count myself out of the 250km option, I’ll give the 210km ride a crack - just hope I’ll still be alive by the end!

6A 4B 98 65 B6 B3 84 7D 4C 17 94 37 04 0F 6B 4E

May 09, 2007 in Random

Found this via slashdot:

You Can Own an Integer Too — Get Yours Here

6A 4B 98 65 B6 B3 84 7D 4C 17 94 37 04 0F 6B 4E, is now mine.

Hands off n00bs, or I bring out the DMCA spam cannon…

Ambiguous Column Names & Postgres Joins

May 09, 2007 in PostgreSQL

Most people working with postgres have probably encountered something like this before:

SELECT
instrument,
priceband,
pounds
FROM   tbl_instruments,
tbl_prices
WHERE   tbl_instruments.priceband=tbl_prices.priceband;
ERROR:  column reference "priceband" is ambiguous

Although that’s normal behavior according to the SQL standard, and very easy to fix using ‘tbl_instruments.priceband’ in the SELECT, it kind-of doesn’t make sense given that WHERE clause: both tbl_instruments.priceband and tbl_prices.priceband will yeild the same value. I found the following in the Postgres mailing archives (imo, a much neater solution than qualifying the column names):

SELECT
instrument,
priceband,
pounds
FROM
tbl_instruments
JOIN
tbl_prices USING (priceband);

				

09 f9 11 02 9d 74 e3 5b d8 41 56 c5 63 56 88 c0

May 02, 2007 in Lame

Now, where do I collect my complimentary DMCA take-down notice?

Am I the only person with a cynical view of the limp-wristed submissive whimper ‘response’ issued by Kevin Rose on behalf of Digg?