Just wanted to share some of my favourite lesser-known web sites and blogs with you. They are all web development related one way or another. Feel free to add your own suggestions to the comments.
Planet Web Security
This site takes in the feeds from various high profile web security and hacking sources and presents them to you for easy access. There are usually a stack of new posts every day, and they're nearly all extremely useful or invaluable reading one way or another. For example I've recently learnt about
SQL Server Truncation Attacks (which is more serious than you'd think),
Firefox httpOnly vulnerabilities,
hacking with Yahoo Pipes, and a superb article on
XSRF.
http://planet-websecurity.org/
A lot of the articles come from www.0x000000.com, the Hacker Webzine, which despite going for that 'jet black matrix' style design effect we fondly waved goodbye to in the 1990s, is still a goldmine of information. Don't hide behind your filterInput extension or framework of choice and feel that a number of these security concerns shouldn't worry you - the alarming rate at which they are discovered proves this isn't a safe option. Subscribing to their feed at the very least will keep you updated about what the current attacks are, even if you can't protect against them immediately.
MySQL Performance Blog
Think you know MySQL inside out? Think again. These guys REALLY know MySQL, and thankfully for us they blog about it on a regular basis. I've learnt an awful lot from their wisdom, everything from
Innodb Recovery to the excellent article
Large Result Sets and Summary Tables in PHP. They also run a forum, but the visitor count is pretty low which means you won't get a particularly rapid response, although it's nearly always a quality one.
http://www.mysqlperformanceblog.com
ProgrammableWeb
This is a much more main-stream web site, but one well worth visiting. Think of them as an index to all of the public APIs out there. From YouTube to flickr to some you'd probably never even think of (WebPurifys Profanity filtering service API for example!). They also list and track mash-ups, API vendor news and have a decent "How To" list.
http://www.programmableweb.com
Ajaxian
If ProgrammableWeb is all things API, Ajaxian is all things ajax and javascript. Given the Web 2.0 hyperbole currently flooding the tubes the "ajax" world is a rapidly updating one, and Ajaxian offer a great means for you to tap into that pulse of change. They cover all JS frameworks (mootools, prototype, etc), all languages, have podcasts and showcases of work, and a great tag-line ("Trying to generate more hype than Rails")

A superb resource, because let's face it - we can't really ignore what is going on in this neck of the woods. Unless you are (un?)lucky enough to be stuck maintaining decidedly ancient web apps for the rest of your life.
http://ajaxian.com
Deziner Folio
I may be a programmer first, but I love graphics and always have done. Deziner Folio is the home of Navdeep and Naveen, two very graphically talented brothers. Their blog often shares great Photoshop resources such as styles, PSD kits, wallpaper effects and actions. If you have an eye for the visual and like to tinker with Adobes beast then I urge you to consider adding this to your feedreader of choice. Go back through the archives for some great downloads.
http://www.dezinerfolio.com