Some people make architecture decisions purely based on the loudest consultant: https://twitter.com/gareth/status/778575385600688129 For most others, however, decisions are not as simple as this. For instance: When should we start evaluating NoSQL storage systems as an alternative to RDBMS? RDBMS as the hammer for all nails This question obviously assumes that you're starting out with an … Continue reading When to Choose SQL and When to Choose NoSQL
Tag: RDBMS
Say NO to Excessive Use of Surrogate Keys if Performance Really Matters to You
We programmers keep cargo culting these wrong ideas. Recently, we said "NO" to Venn diagrams. Today we're going to say no to surrogate keys. The surrogate keys vs. natural keys non-debate is one of the most overheated debates in data architecture, and I don't get why everyone is so emotional. Both sides claim to hold … Continue reading Say NO to Excessive Use of Surrogate Keys if Performance Really Matters to You
There is no Such Thing as Object-Relational Impedance Mismatch
Much of the ORM criticism of the last decade missed the point, being inaccurate. By the end of this article, we will conclude with the following: There is no significant difference between the relational (data) model and object oriented models How to come to this conclusion? Read on! How we came to believe in this … Continue reading There is no Such Thing as Object-Relational Impedance Mismatch
What Exactly are SQL Views?
You probably know about "ordinary views" already, but I'm sure you'll find one or two things in this article that you haven't thought about in this way yet... What exactly are SQL views? Views in SQL are a means of treating complex queries in the same way as "ordinary" tables. In fact, SQL is all … Continue reading What Exactly are SQL Views?
3 Reasons why It’s Okay to Stick with SQL
The past decade has been an extremely exciting one in all matters related to data. We have had: An ever increasing amount of data produced by social media (once called “Web 2.0”) An ever increasing amount of data produced by devices (a.k.a. the Internet of Things) An ever increasing amount of database vendors that explore … Continue reading 3 Reasons why It’s Okay to Stick with SQL
Frightening Facts about MySQL
So you might've seen Destroy all Software's talk about JavaScript: Here's a similar talk (less funny more scary) about MySQL: https://www.youtube.com/watch?v=emgJtr9tIME
Flyway and jOOQ for Unbeatable SQL Development Productivity
When performing database migrations, we at Data Geekery recommend using jOOQ with Flyway - Database Migrations Made Easy. In this post, we're going to look into a simple way to get started with the two frameworks. Philosophy There are a variety of ways how jOOQ and Flyway could interact with each other in various development … Continue reading Flyway and jOOQ for Unbeatable SQL Development Productivity
The Crystal Ball. Or, Oops, Michael Stonebraker did it Again
Michael Stonebraker's opinions and claims are always refreshing to read. He's done a lot for our industry and for how we do data processing. Some of his claims are certainly right as well. Here's an interview with him, telling us about his 5 predictions on the future of databases. Of course, him being a software … Continue reading The Crystal Ball. Or, Oops, Michael Stonebraker did it Again
A History of Databases in “No-tation”
We're heading towards very exciting times in the field of databases! At Topconf in beautiful Tallin, Estonia, Nikita Ivanov (founder and CEO of GridGain Systems) was talking about how the ever crumbling price of DRAM gets in-memory computing and thus in-memory databases within the reach of being affordable by even small and medium enterprises. Nikita … Continue reading A History of Databases in “No-tation”
CUBRID: A Lesser-Known Korean OSS Database Gem
While RedHat and Google have been dumping MySQL for MariaDB, there's actually a third, much lesser-known option for MySQL-oriented database folks in the RDBMS market: CUBRID. One of CUBRID's main goals is also to lure MySQL users away from Oracle by offering many equivalent syntax elements that are available in either the MySQL or Oracle … Continue reading CUBRID: A Lesser-Known Korean OSS Database Gem