R2 Project Log – It’s Alive!

I spent Thursday & Friday evenings wiring up enough of the board to flash some LEDs, then set out to program it… Without success :(

After ripping apart the board, replacing the uC, and checking every single connection with a 10x Loupe, i turned to google, and found that the atmega128 is programmed differently to the other AVRs i’ve used, it has it’s own PDI and PDO pins connected to the first USART for uploading the program.

I wish someone had told me that before i bought the board!

Luckily, i had brought the USART pins out to their own header on the board, so after wiring up a programming adaptor, i was finally able to get some life!

Watch this!

Here is my new watch, bought duty free in jamaica. Its a Seiko SKA235 Kinetic Watch, Has a sexeh window in the back to view the mechanism, and should hopefully never need a replacement battery!

Heres some pics:

wrist.jpg

front.jpg

back.jpg

SQL Fun

Had a bit of fun today, trying to pick out only singleton entries from a database table, finding the lowest unique bid for the reverse auction app i’m doing at work. this is what i came up with:

SELECT *
FROM bids
WHERE auction_id =1
GROUP BY value
HAVING ( COUNT( value ) =1 )
ORDER BY value ASC
LIMIT 1;