Tag Archives: database design

The Master of the Schema

“The database … should be the master of the schema”. It’s not often I see an application developer talk about the importance of the database, or at least that the database (and data) are very important to the success of … Continue reading

Posted in Editorial | Tagged , | Comments Off on The Master of the Schema

Who Likes NULL?

The title says it all: who Likes NULL values in their tables? I have tended to allow NULLs in quite a few places in my design, often because I view the world as messy and incomplete. I also find that … Continue reading

Posted in Editorial | Tagged | 2 Comments

Where’s the schema?

Across the last few years, I’ve read many articles and listened to quite a few talks that discuss the advantages of NoSQL databases. I’ll admit that I’m often skeptical of the advantages of other datastores overcoming the disadvantages with a … Continue reading

Posted in Editorial | Tagged | Comments Off on Where’s the schema?

Singular or Plural

There are all sorts of interesting debates that developers will have about programming. One of those I’ve written about in the past is Spaces v Tabs. There’s a lot of discussion about that one, and certainly no share of strong opinions. … Continue reading

Posted in Editorial | Tagged , | Comments Off on Singular or Plural