SQL Hegemony and Document Databases

A surpassingly strange question is this: "How do I get the data out of MongoDB into a spreadsheet?"
The variation is "How can we load the MongoDB data into a relational database?"
I'm always perplexed by this question. It has a subtext that I find baffling. The subtext is this …
more ...

SQL Hegemony -- the "Pivot Table" problem

As far as I can tell, the Pivot Table Problem™ only exists for people who have actively put on blinders so that they can only see data one way.
This leads to the following.
The context appears to be millions of rows of data. Hundreds of columns. It appears that …
more ...

SQL Hegemony -- a sad state of affairs

It appears that there are people who don't recognize SQL as a tradeoff.

Here's a complex two-part question that can only come from folks who firmly believe in the magic of SQL.

The sentence that got my attention was "Python has basically made SQL obsolete as a language for data …

more ...





Escaping the Relational Schema Trap

We're struggling with our Relational Schema. We're not alone, of course, everyone struggles with the relational model. The technology imposes difficult limitations and we work around them.

There's kind of a 4-step process through which the relational schema erodes into irrelevance. The concept of a schema is not irrelevant. It's …

more ...