Tag Archives: database design

The Relational Database is the Default

Posted on December 7, 2017 by way0utwest

It seems that I regularly meet people in the SQL community that are asked about moving their datastore to a NoSQL type of database. In a mature system, that might be a conversation worth having, especially if there are issues … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Relational Database is the Default

A Database Design Test

Posted on June 30, 2017 by way0utwest

I was watching a presentation recently on database design and the speaker talked about how he hires developers. These are full stack developers, for whom the database is a portion of their responsibility. One of the tasks he gives them … Continue reading →

Posted in Editorial | Tagged , | 6 Comments

Null Defaults

Posted on March 3, 2017 by way0utwest

One of the things that becomes important in a distributed, team environment is the interface that you present to other systems. In a Devops environment, we really need to have an API for every system, including the database. This means a … Continue reading →

Posted in Editorial | Tagged | 1 Comment

Making Complex Table Changes

Posted on August 8, 2016 by way0utwest

Tables are a problem for anyone trying to grow and modify software. Views, stored procedures, functions, all of these objects are easy to modify, but when we start to deal with actual data, where we need to maintain state, we … Continue reading →

Posted in Editorial | Tagged | Comments Off on Making Complex Table Changes