TinyMy, Quick and Dirty MySQL Shell

Stumbled across a tiny mysql shell – appropriately named ‘tinymy’ – a few months ago.

It’s quite a useful little bit of PHP code. Very lightweight and function interface and shell for MySQL. I use it whenever I need to verify the contents of a database table or test a couple of queries but don’t need a full install phpMyAdmin.

Thought I’d share.
Link

Autotrader.ca, Please Fix Your Search.

Autotrader.ca your search is not very good!

I just did a search for “all cars newer than 2000, between $2500 and $5000 excluding damaged vehicles, in descending order by Kms.” Sounds pretty complex when you write it out in English, but that should be a fairly straight-forward SQL query. Came across a couple of pretty serious problems there.

Your premium listings do not obey my sort selections, they simple appear in whatever position the advertiser has paid for. This would be somewhat forgiveable if the premium listings where displayed separately, a la Google ad words. Even though they are on a yellow background, as a first time visitor I had not yet scrolled down to notice that the regular listings are on a white background. So I assumed that your sort feature was broken, in fact I probably wasted a minute clicking the sort link until finally giving up and scrolling down. It was then that I realized exactly what was going on. I don’t know if there’s a good way to fix this from a user interface standpoint, you may just want to increase the size of the “Premium Listings” header text and/or do something else to make it stand out more clearly. In my opinion selling premium listings is pretty lame, your profit margins online have got to be much higher than in print. At the very least, drop the ordering of the premium listings, so that I’m able to apply a sort to those listings as well.

Secondly, I came across something much worse.

This 2003 Hyundai Tiburon came up in my search even though I specifically excluded vehicles with damage. I’m sure that your search engine code is fine. I’m sure the problem is a lack of data. The seller of that car probably did not provide you with data about it’s “damaged” status. But you see, thing is, if such an obviously damaged car shows up in my search, then how can I be sure than all of the other results that appear fine don’t have some less obvious damage? This oversight makes your search engine completely untrustworthy! I know how had it can be to get good data from users, but seriously, have you data entry monkeys flag adverts with photos like these.

P.S. ASP sucks, drop your Microsoft licenses and you’ll make more than enough money to drop those lame premium listings.

P.S.S. Trasparent divs with background images is a lame way to block hotlinking of images. Just block access to your image files from off-site referers in … oh wait, that’s not possible with IIS. See previous PS.