(David HM Spector) Being a good technologist you probably even have Linux machines in your house that you use to keep your skills up to date. You see lots of potential, you’ve waited patiently for management to wake up and smell the open source coffee, and you even can think of some great test deplo

(Jon Stephens and Chad Russell) In the previous chapter, you saw how MySQL’s date and time datatypes can save storage space—50% or more over storing dates as strings—but that’s not the only reason for using them. One aspect of applications programming that’s often troublesome is working with dates.

(Vance McCarthy) First results are in for the Department of Homeland Security’s vulnerability survey of some 40 Open Source projects. Early findings, released by Stamford University and source code analysis software vendor Coverity reveal that the LAMP stack has a higher-than-average code quality, w

(Charles Babcock) Red Hat’s $350 million purchase of JBoss, the open-source application server company has the potential to create a new open source code powerhouse, since it moves Red Hat from being just an operating system distributor to a provider of a larger software stack, particularly in middl

(Dru Lavigne) The BSD family of operating systems isn’t the only BSD licensed software whose roots originate from the University of California at Berkeley. While many are familiar with Berkeley’s contributions to Unix, fewer are aware of the role it played in the formation of modern database systems

(Mike Hillyer) Is there a way to write a SQL statement that will override (set to null) all foreign keys? I want to use this when loading a test development MySQL database. (R)

(China Martens) MySQL AB has signed a multiyear agreement with Oracle to renew its licensing of the InnoDB database storage engine, according to a MySQL executive. The move resolves confusion in the market about the likely effect on MySQL of Oracle’s purchase last year of the maker of InnoDB, Innoba

(Mark Brunelli) A recent interview has DBAs talking about the merits of the open source PostgreSQL database management system (DBMS) as compared to Oracle – and their opinions truly run the gamut. (R)

(Jon Stephens and Chad Russell) We are now going to look at a number of MySQL functions. Again, the focus here is on the central premise of this chapter: replacing programming logic with SQL logic is a key optimization skill, and it is almost always the best course of action to make the database per

(Greg Beaver) UPDATE 2: Thanks to Chris Shiflett, who provided a link to a real answer in his comment. Clearly, the way to do this within the environment where you have one host and lots of ~users is to use .htaccess. Each user would define in their own /home/user/public_html/.htaccess two environme