Have you ever heard of PECL/mysql_uh? Ok, fine, maybe you have but I hadn’t until I read this blog post by…well, I’m not sure who it’s by but it was RTed by @PierreJoy so I read it. Click on through, I’ll share the super-secret URL and other goodies.

There are gargantuan amounts of data that organizations are storing thanks to the advent of really cheap storage. To cope with this, organizations end up buying bigger and bigger database servers/clusters. But maybe, just maybe, there’s a shortcut. This coming Thursday (July 22nd) Zend is having a webinar with InfoBright looking at how a columnar databases can help deal with analytical data requests on large amounts of data.

A review of the book Mastering phpMyAdmin 3.1 for Effective MySQL Management by Marc Delisle.

Get your PHP project done faster and save money by scaling it vertically with IBM Power Systems

On Oren Solomianik’s blog, he describes how to create a browser based database admin with the power of Zend_Db_Table and a few lines of code.

As a follow up to his earlier article about “fetching a single random row from MySQL”:http://www.dasprids.de/blog/2008/06/07/fetching-random-rows-of-mysql-efficiently Ben Scholzen will tell you, how you can fetch multiple random rows from a table without any hassle.

In honor of the MySQL Conference happening this week, we are happy to present the latest episode of The ZendCon Sessions podcast that is all about MySQL! This episode of The ZendCon Sessions was recorded live at ZendCon 2008 in Santa Clara, CA and features Jay Pipes giving his tutorial: “SQL Query Tuning: The Legend of Drunken Query Master”

At the MySQL Conference today, a number of announcements were made. Not the least of which were discussions about Oracle’s acquisition of Sun. But also an announcement of the preview release of MySQL 5.4

For those people who have ever used mysqldump to backup a database, you may have seen all sorts of weird comments like /*!40101 SET NAMES utf8 */; or /*!40000 ALTER TABLE `members` DISABLE KEYS */; — Ever wonder what those mean and how you might use them? Read on to find out.

A recent NETTUTS article discusses how to do pagination of data within PHP. The need to paginate datasets is a commonly occurring one in Web Development, and this tutorial goes into depth as it steps you through making a good solution.