(Andrew Oppel) SQL functions were introduced in Chapter 4. The topics that follow describe functions that were not covered in Chapter 4 but which you will find useful. In addition to character and mathematical functions, selected date and time functions are also included. Remember that all SQL

(Barry L. Kline) The “LAMP” phenomenon has been in the spotlight for a couple of years, yet many people don’t really understand what it is. The acronym has been tossed around so much in varying contexts that its true meaning has become obscured. This month, we’ll shine some light into the murky wate

(James Niccolai) Open-source database company My SQL has acquired a small web application technology company and in the process hired its founder.

(Mark Alexander Bain) You may know how to use SQL to extract data from a table in a MySQL database, and how to run a query that combines data from more than one table. But what about multiple databases? Or even multiple databases on multiple servers?

(Andrew Stellman and Jennifer Greene) Let’s say that you’re a programmer working on a wildly successful open source project in your free time. You’ll typically go home from work and check your inbox, find that a new patch was committed to the Subversion repository for the project, and review it care

(Beat Vontobel) I just stumbled across a recently discovered security issue in MySQL when I made use of the general query log today (which is usually deactivated on our servers) to track down the behaviour of some legacy applications: If you grant access to possibly untrusted users, you shouldn’t co

There are at least three Open Source implementation of Microsoft’s Dot Net platform – Mono, DotGNU and Rotor. Though there are a few other implementations happening at some remote corners of the World Wide Web, these projects are insignificant at least at this point of time.

(wduros1) This is a sample framework that I wrote. It works basically like a poor man’s OR tool, generating VB.NET code from a database table, and using attributes to control updates and inserts.

(Chris Smith) Database indexes help speed up retrieval of data, they can significantly improve performance – the other great benefit of that is your server doesn’t have to work as hard to get the data. They are much the same as book indexes, providing the database with quick jump points on where to

(Pan Pantziarka) PHP and MySQL provide the development language and database components of the LAMP (Linux, Apache, MySQL and PHP/Perl/Python) stack that drives huge chunks of the web. Over the years they have each evolved and grown in complexity and functionality and yet they are still tied togethe