The Schema Czar

Common Engineering Redundancy Fails for Data

The Schema Czar — Mon, 10 Aug 2020 15:41:33 +0000

There are certainly things that put the relational database on a different planet from other forms of engineering. One of the most important is redundancy. Successful practitioners of most types of engineering may include many layers of redundancy in their designs.

The post Common Engineering Redundancy Fails for Data first appeared on The Schema Czar.

Know Thyself!

The Schema Czar — Tue, 06 Feb 2018 16:47:05 +0000

I always tend to do LEFT OUTER JOINS, and I avoid RIGHT OUTER JOINS. Sometimes that's just not right.

The post Know Thyself! first appeared on The Schema Czar.

Cloud Services Must GET REAL!!

The Schema Czar — Mon, 16 Oct 2017 00:28:35 +0000

Services like Google Drive, DropBox, Amazon, and others simply cannot treat their customers' storage as if they are just another public-facing web site that anyone can spider and scour and read at will.

The post Cloud Services Must GET REAL!! first appeared on The Schema Czar.

Error pages with stack traces???

The Schema Czar — Sat, 14 Oct 2017 16:50:43 +0000

It's 2017, people. It is completely unconscionable that a web application should ever, ever show its internals to the user in an error message.

The post Error pages with stack traces??? first appeared on The Schema Czar.

Is this new? Good? Projecting a Constraint with a Primary Key

The Schema Czar — Thu, 10 Dec 2015 04:42:27 +0000

I'm looking for some feedback on this one. I've used this technique a few times in order to add some integrity to join tables. Specifically, I am using a unique constraint that uses a table PK as a prefix. Why do I do this? When each row of the table has unique information that necessarily […]

The post Is this new? Good? Projecting a Constraint with a Primary Key first appeared on The Schema Czar.