Search
-
Recent Posts
- London Cycle Hire 3D Visualisation in Google Earth
- Armchair Auditor interview with Henry Kelly on BBC Radio Berkshire
- How to deal with #Twifakes
- Sutton pedestrian crossings proposed for removal by TfL
- Armchair Auditor interview with Eddie Mair on BBC Radio 4 PM
- Boris Bikes — A gift to the city
- Some more facts about SpotlightOnSpend for FullFact.org
- Digital simulacra and the iPad human interface guidelines
- Philippa Stroud’s statement regarding The Observer’s story
- How to lie with statistics, Liberal Democrat style
Categories
- Architecture (1)
- Armchair Auditor (2)
- Citizenship (6)
- Design theory (10)
- Graphic design (1)
- Media Appearances (2)
- open data (4)
- Planning (3)
- Politics (9)
- Product design (9)
- Simplicity (8)
- Software design (7)
- Sutton (19)
- Uncategorized (12)
- Urban design (6)
- Urbanism (3)
- Usability (8)
- Web design (24)
@AdrianShort
- My review of Sutton's new animal sculptures (scroll down to comment 11): http://bit.ly/9LndxI #art #criticism 1 day ago
- My carbon monoxide alarm doesn't let you close the battery drawer without batteries in it. A kind of poka-yoke? http://bit.ly/9ixECv 1 day ago
- Bike basket satnav: Interesting promo shot for Samsung Galaxy Tab Android 2.2 tablet: http://bit.ly/af3ZgV 1 day ago
- RT @cyclehireapp: Coming up on v4 of Cycle Hire App - An innovative viz of the # of bikes in each docking station: http://twitpic.com/2kgs3u 1 day ago
- . @phiali For a good dose of urban/computing follow/read Sydney resident @cityofsound http://bit.ly/cG7iP6 in reply to phiali 1 day ago
- More updates...
Meta
Tag Archives: mysql
Building a local news mashup with Twitter, TwitterFeed, Delicious, Yahoo! Pipes, Ruby and RSS
(Click on the image to download the PDF, 19KB, opens in new window/tab.) Like this? Follow me on Twitter: http://twitter.com/adrianshort I’m a self-confessed and unashamed news junkie and this is how I’m starting to mash up news in my local … Continue reading
Posted in Software design, Sutton
Tagged apis, atom, Delicious, Hpricot, mashups, mysql, news, Paul Burstow, rss, Ruby, Stonecot Hill News, Sutton Council, Sutton Guardian, Twitter, TwitterFeed, Yahoo! Pipes
19 Comments
Some URLs are longer than 255 characters
This isn’t going to come as news to any web developer who thinks about it for more than a second. But ask yourself – how many URL fields are there in your applications’ databases that are defined as VARCHAR(255) or … Continue reading