(Peter Zaitsev) This is interesting question which I thought it would be good to write about. There are obviously benefits and drawbacks for each of methods.

Are you experiencing current performance bottlenecks? Designing a new application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries? Then this free web presentation is for you! Yo

(Paul DuBois) A growing number of applications today use data represented in the form of XML documents. XML use is on the rise because it is a simple ASCII format that has a well-defined yet extensible structure. As a result, many standardized XML processing tools has been written. What is the impac

(Jacques Noah) In this second part of a three-part series on blogging with PHP and MySQL, we will be looking at the actual blog. The blog will be simplicity itself. I have created a style sheet that will help in making the blog look clean and neat. The blog will be based purely on a open blog system

(China Martens) Developers at open source player MySQL are hard at work on a project code-named “Merlin” designed to make it easier for customers to manage and maintain their company’s database software, according to a source close to MySQL.

(MiMi Yeh) Why are you paying so much in licensing costs and annual maintenance when you could use PostgreSQL for free, and get community support and upgrades for free as well? This is the question that Neil Matthew and Richard Stones pose to smaller companies regarding their less critical applicati

(Melonfire) If you’re running a Web application using MySQL, chances are good that it has passwords or other sensitive data stored somewhere within it. Securing this data from hackers or snoopers is a critical concern, both to avoid unauthorized use or damage to your application and to retain your c

(Alejandro Gervasio) Trying to expand beyond the boundaries of your existing background by learning how to code and use static methods and properties inside your PHP 5 classes? Then look no further. Welcome to the last part of the series “Using static members and methods in PHP 5.” Made up of two in

(sheikhsa) This tutorial describes how to set up MySQL master-master replication. We need to replicate MySQL servers to achieve high-availability (HA). In my case I need two masters that are synchronized with each other so that if one of them drops down, other could take over and no data is lost. Si

(Julie C. Meloni) In this second of three installation-related chapters, you will install the Apache web server and familiarize yourself with its main components, including log and configuration files.