Heads up, developers: the PHP folks have announced their intention to deprecate the old MySQL database extension.

As they say, “Don’t panic.”  It’s not like MySQL-extension-based sites are suddenly going to start throwing exceptions; this is more a documentation change and a community education effort.

Going forward, the PHP team recommend two alternative extensions for new site development: pdo_mysql and mysqli, with PDO being the PHP way and main focus of future [PHP team] endeavors.

If you’re currently a Dreamweaver user or are just using the old MySQL extension out of habit, I developed a free tool in MyQuery Builder that will convert your existing code to both procedural or class-based MySQLi code, your choice.

Sign up for free and click on the Tools tab once you’re in to use the “MySQL->MySQLi Converter.”

матрациNot to be outdone by Apple’s recent launch of their HTML5 playground, Google has launched their own HTML5 Developer Resource site called HTML5Rocks.com.

The site has some useful tutorials and an interactive sandbox, but for the time-impaired, they also have an excellent presentation that shows you quickly what is new and different. As with most things Google, it’s not the prettiest site, but it gets the job done. Check it out.

Apple has just launched an effort to support more widespread adoption of HTML5 in the developer community. This page showcases a bunch of cutting-edge demos, and this page digs into the demos more deeply and provides more resources to learn how to develop features using HTML5.

Standards aren’t add-ons to the web. They are the web. And you can start using them today.

Lots going on over at my side-project, MapTechnica, lately. In addition to the US 5-Digit Zip Code Maps and US County Boundary Maps, I’ve just turned on City maps.

Looking back, I should have started with these given how cool they turned out to be.  In truth, though, I didn’t realize the data and shapefiles for the cities were in the vast Tiger/Line database since the US Census Bureau calls them “places,” not “cities.” Oh, well.

Serendipitously, the city boundaries work amazingly well with the city labels and information already embedded in the Google Map layer, so the effect is a truly additive mapping product without the need for map markers.

I’m still working on productizing the tile set and database, but that should be up in the next few days.  In the mean time, head over to the free US Cities Boundary Map Tool and play around.  As always, I’d love any feedback you might have.

If you have any dynamic sites that can display the same information through a variety of URLs (e.g. “somepage.php?category=cats&story=123″ vs. “somepage.php?story=123&category=cats”), Google has provided a way for you to avoid the duplicate content issue by providing a “preferred link.”

Basically, you add a special link tag to the head of your page:

When Google finds duplicate content, it will transfer the page ranks and index data to your preferred link.

Clap your hands and say yeah. You’re done.

Head on over to the Google Webmasters Central Blog for details on this tip.