(Gevik Babakhani) As a developer I often come across SQL statements that are hardwired into the source code regardless of the programming language they are used in. It makes the code messy and unreadable when sometimes seeing large SQL statements chopped and concatenated in several string constants.

(Michael Kofler) The first stage in any database application is the design of the database. The design will have a great influence on the efficiency of the application, the degree of simplicity or difficulty in programming and maintenance, and the flexibility in making changes in the design. Errors

MySQL has started a MaxDB series on its corporate blog aggregator. Since the beginning of Februar the MaxDB team tries to write one MaxDB article per week for you. The articles get published on our english language web site http://www.planetmysql.org. All articles together will make a complete MaxDB

(Jon Stephens and Chad Russell) In this chapter, we’re going to explore the central premise of this book: It is almost always the best course of action to make the database perform as much work as possible, thus minimizing the amount of filtering and manipulating data that you do in your programming

A MySQL table is completely different than the normal table that you eat dinner on. In MySQL and other database systems, the goal is to store information in an orderly fashion. The table gets this done by making the table up of columns and rows.

(Tom Dyson) I’m been feeling mildly guilty about not publishing the work I did with John Gray last year on XPath support in PostgreSQL, but the interest in Jon Udell’s ‘SQL and XPath’ post has goaded me into action: here’s a brief outline of the four production-ready XPath functions which represent

(Falko Timme) This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package that provides heartbeat (for checking if t

(MiMi Yeh) Your company doesn’t have to pay big bucks for a big database. If your apps are not completely chained to Microsoft, then you’ve got a chance to save money and get enterprise-level scalability, functionality and ease of use with open source PostgreSQL, say Robert Treat and Jason Gilmore,

(MiMi Yeh) Some people think PostgreSQL 8.0 is just a backend database for Web sites. They’re as well informed as people who think the moon is made of cheese, according to Robert Treat and Jason Gilmore, co-authors of Apress’ Beginning PHP and PostgreSQL 8: From Novice to Professional. (R)

(Adam Plocher) SQL injections are a major security risk in many PHP applications. Injections are caused when a web developer allows the end-user to manipulate a variable that is being inserted into a database query string, generally through the $_GET, $_POST or $_SESSION superglobals. When a value i