(Scott Noyes) I have been working with a spreadsheet that records student performance. I have improved this spreadsheet to the point where I would like to create software. I was advised to learn Microsoft Access and then transfer created files from Excel. Considering the limitations of Access, I sho

(Alejandro Gervasio) If you’re looking for brand new material to help you expand your background in using design patterns with PHP 5, then hopefully this article will suit your needs. Welcome to the final installment of the series “Introducing Visitor Objects in PHP 5.” Composed of three chapters, t

(Groshan Fabiola) The success and the longevity of any prominent business nowadays depend on powerful application infrastructures and effective, reliable management and development solutions.

(Guy Harrison and Steven Feuerstein) Over the past decade, MySQL has become the dominant open source database, and along with Linux and PHP, is at the heart of millions of applications. Now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power

(Giuseppe Maxia) One of the most exciting features introduced in MySQL 5 is the federated engine. The ability to access data from a remote server without the constraints of replication tickles every programmer’s fancy.

(Carol Hildebrand) Ernie Ball Inc. is certainly not the norm when it comes to software use. The San Luis Obispo, Calif.-based company switched completely to open source software after a surprise audit by the Business Software Alliance produced a hefty fine for using unlicensed software. (R)

(Paul Dubois) When you are trying to optimize your queries to run quickly and efficiently, you may encounter queries that really should run faster. That’s where EXPLAIN comes in handy. This article shows you how to use EXPLAIN in query analysis.

(Kathleen Richards) The final release of open-source AJAX4jsf framework 1.0 is now available. The project, sponsored by Exadel and hosted on java.net, extends the benefits of Asynchronous JavaScript and XML (AJAX) functionality to component framework JavaServer Faces (JSF), which supports UI develop

(Tony Patton) The open source software community has had a huge impact on the software industry. The quality and type of applications available via open source licenses are impressive.

(Paul Dubois) This chapter discusses general principles that are useful for optimizing queries to run more efficiently.