Congratulations – you've landed your first big enterprise client. Now you need to do what you said you'd do, and make everyone happy in the process. This article will show you how to use techniques for visibility and verification to do most things – setting up processes and systems, doing QA …

When we speak of storing images or binary data in a database many will assume we wish to use the data in a production environment such as a web based application in conjunction with PHP or other language.There can be no argument that when speed of access is paramount, image and …

The first part of this article gave a theoretical overview and reviewed ways of optimizing data structures. In this part we will deal with runtime parameters and optimizing queries.With SQL common problems can be solved in many ways. Everybody has a different style and approach. Depending on the kind of application …

While this is a Java marketing phrase it is also a key feature of PHP.Many business models dependon operating system independence to ensure that products can be sold to a wide range of customers. So why lock yourself in with a specific database vendor? Database abstraction layers allow you to develop …

When talking about database development and database administration, performance tuning isan essential topic. PostgreSQL is one of the most widespread Open Source databases available and it provides a rich set of advanced features as well as options for efficient tuning.This is the first part of an article about tuning PostgreSQL. We …

Tip #1 – Your Storage Engine is Your FriendI used to almost use InnoDB exclusively prior to working for MySQL. I benefited from transactions and ACID compliance, but largely I hadn’t discovered something important—different problems, different solutions. Efficiencies are gained in making trade-offs. There are subtleties between the various storage engines …

IntroductionMySQL Cluster has seen a very positive response and fairly rapid uptake (especially in the telecom sector) since it was first made available in MySQL 4.1. It was, after all, one of the first serious attempts to make high-availability relational data storage accessible to anyone able to get their hands on …

Quietly and with little ado, PHP 5 has brought the power and strengths of PHP to the command line, making PHP a tool of choice for Web developers and system administrators alike.What is PHP CLI?Since you are reading this article you are probably familiar with PHP and the impact that it …