(Paul Dubois) This section discusses some of the important new features that are being developed in MySQL 5.0: –Views –Stored Procedures and Functions –Triggers

(Jay Pipes) Webyog is the company behind the popular SQLyog GUI tool for managing and developing MySQL databases. They have a great history of partnership with MySQL and, recently, decided to open source part of their product line. I had a chance to interview Rohit Nadhani, co-founder of Webyog, abo

(Alejandro Gervasio) If you’re one of those avid PHP developers who wants to learn how to apply the decorator design pattern within your Web applications, then this group of articles might be quite appealing to you. Welcome to the second part of the series “Using the Decorator pattern with PHP.” Com

MySQL Cluster is now being adopted not only as a database for traditional telecom applications like, HLR (Home Locator Registry) or SLR (Subscriber Locator Registry), it is now also being widely deployed for VOIP, internet billing, session management, eCommerce sites, search engines and even traditi

(Curt Finch) Software is ultimately composed of congealed ideas, so ideas are very important in the minds of software developers. The key to market power in the software industry lies in the minds of developers. Fashion plays a role too; some ideas are fashionable and some are not. The idea, or phil

(Mike Schiff) The Open-Source movement has not been ignored by data warehouse and business intelligence vendors. While the Linux operating system and the Apache Web server have become the poster children for the open source community, the range of open-source products available today includes databa

(Paul Gillin) Open source software is certainly a wonderful evolution in computing, but even if you’re a savvy PC user with a lot of commercial software experience, the job of installing and running open source on a server can be a daunting experience. Here’s my own vignette. (R)

(Bård Farstad) This article explains how to tune a MySQL database for use with eZ publish. MySQL is a database engine used by eZ publish to store content. While other databases are supported by eZ publish (such as PostgreSQL and Oracle), for performance reasons we recommend MySQL. This article has s

(Roger Magoulas) Tableau Software is a provider of visual analysis and reporting tools. Although there are several tools available to help users efficiently and easily create pivot tables or cross-tabulations, Tableau allows you to take it one step further: visualize the cross-tabulations in real ti

(Melonfire) In SQL terms, a trigger is “procedural code that is automatically executed in response to certain events on a particular table in a database” (Wikipedia). More simply, it is a stub of code that is automatically activated when a particular database event, such as an INSERT or DELETE, occu