(Gez Lemon) PHP is a server-side scripting language and interpreter that is available on a wide range of platforms, including some versions of Apache, and Microsoft’s Internet Information Server (IIS). The original program was called Personal Home Page Tools, which is where the initials PHP come fro

(Ian Gilfillan) Last month I introduced MySQL Stored Procedures. If you have not yet read that article, you should do so first, as I continue to build upon the examples from then. This month I look at some more advanced concepts, including conditions and loops.

(Tony Marston) The software that I write is not intended for just one customer who is locked into a single RDBMS. Instead it can be used by virtually any customer using the RDBMS of their choice. How is this possible? I deliberately designed and built my infrastructure around the 3 Tier Architecture

(Nathaniel Brown) Bruce Perens, a very public Open Source advocate, and a co-founder of Software in the Public Interest, says Open Source could prove to be even more attractive in the future, as commercial software looks to protect company interests over those of the user. But, to take advantage of

The popular MySQL open-source RDBMS can handle tables containing hundreds of thousands of records without breaking a sweat. In fact, this scalability is one of the reasons it’s becoming so popular with large organizations and their massive databases.

(Ian Gilfillan) In a previous job when I was responsible for hiring PHP developers, I always used to ask questions about database abstraction in my interviews. It’s amazing how often candidates with the best-looking CV’s, and impressive looking project lists, were tripped up by their lack of knowled

(Robin Schumacher) More than at any other time, database professionals are being aggressively challenged by mushrooming volumes of data in corporate business systems. While some industry analysts project data growth at an average rate of 42% a year, that figure is conservative in some installations

It’s not a bug – it’s a gotcha. A “gotcha” is a feature or function which works as advertised – but not as expected. When working with the MySQL database server I have repeatedly encountered situations where the results of various actions have been unexpected and/or contrary to the behaviour gen

(Steven J. Vaughan-Nichols) SCO and MySQL announced Friday that the two would be working together to jointly deliver the commercial version of the MySQL database to SCO’s latest Unix release, OpenServer 6.

(Blane Warrene) The growing mainstream adoption of open source has spawned a number of more serious conversations over the last several years about business models. Particularly, what will work for creating successful companies and real dollars while adhering to an open source philosophy.