(Xaprb) It’s been a while since I released an update to the innotop InnoDB and MySQL monitor, but I have not been idle. I’m currently working hard to add major new features and functionality.

(Alejandro Gervasio) If you’re a PHP programmer who’s searching for a comprehensive tutorial on how to create adapter classes with PHP 5, them look no further. Welcome to the final installment of the series “Implementing adapter objects with PHP.” Made up of two parts, this series teaches you how to

(Robin Schumacher) One thing I learned fairly early in my DBA career was that if I was ever going to excel in managing the databases under my care, I needed to do one thing: smartly automate as much of my job as I could. This became particularly important in my last full-time DBA spot where one othe

(Peter Zaitsev) Today I was working with application which uses Innodb and foreign keys and got into locking problems possibly due to foreign keys, so I did a little investigation on that matter.

(Alejandro Gervasio) Are you one of those PHP developers looking for a tight and powerful RDBMS, other than MySQL, in order to build your next database-driven website? Then hopefully your search is finished. Welcome to the second installment of the series “Using SQLite with PHP 5.” Comprised of thre

(Roland Bouman) A popular myth holds that the MySQL Database Server strips the comments from stored procedures, functions, triggers, views and events. This is not true. Or at least, it is only somewhat true.

(Xaprb) Here are some common SQL problems, all of which have related solutions: how do I find the most recent log entry for each program? How do I find the most popular item from each category? How do I find the top score for each player? In general, these types of “select the extreme from each grou

(Sean Michael Kerner) After more than a year of active development, the open source PostgreSQL 8.2 database is now available.

(Alejandro Gervasio) If you use PHP 5 to build web-based applications that access a database, you might want to consider SQLite. A “lighter” option than MySQL, this database may still suit your purposes if you don’t need all of MySQL’s bells and whistles. This three-part series covers many of SQLite

(xaprb) I wrote before about a generic, cross-platform way to simulate the SQL ROW_NUMBER() function in any RDBMS. There is a much more efficient way to do this on MySQL with user variables.