Archive for Databaseswithout synopsis

Database Design - are you Novice, Ninja or Nincompoop?

When you design your database for your PHP application are you aware that some of your design decisions can have a detrimental effect when it comes to writing the code to access that database? I have been designing databases, and building the applications which use them, for several decades, and I have learned over the years that there are some design decisions which help the developer while others do nothing more than hinder. This article lists 18 of these “hindrances”.

Published: 23 September 2012

Creating an SQL Server driver for RADICORE

This article shows how a database driver for the SQL Server database was developed for the RADICORE framework.

Published: 01 January 2011

Creating an Oracle driver for RADICORE

This article shows how a database driver for the Oracle database was developed for the RADICORE framework.

Published: 15 January 2007

Creating a PostgreSQL driver for RADICORE

This article shows how a database driver for the PostgreSQL database was developed for the RADICORE framework.

Published: 10 September 2005

The Relational Data Model, Normalisation and effective Database Design

This discusses the workings of a relational databases, about keys, relationships, joins and dependencies. It explains what normalisation is and how to do it, as when denormalisation is OK. It explains what an Entity-Relationship Diagram (ERD) is, and gives a few personal guidelines.

Published: 30 September 2004

Technical Keys - Their Uses and Abuses

There are two ways of using technical keys - intelligently and indiscriminately. The indiscriminate use of technical keys shows a distinct lack of intelligence.

Published: 01 January 2004