SQL
-
Software Development
NULL is Not The Billion Dollar Mistake. A Counter-Rant
A short while ago, I gave this answer on Quora. The question was “What is the significance of NULL in…
Read More » -
Software Development
The Evolution of Database Schemas using SQL + NoSQL
Part two of the two part series: Rethinking Database Design with Apache Drill In part one of this series, Drilling into…
Read More » -
Software Development
MySQL vs. MongoDB: Choosing a Data Management Solution
Table Of Contents 1. Introduction 2. The dominance of RDBM systems 3. A new era of NoSQL movement 4. Tables…
Read More » -
Core Java
What’s Even Harder Than Dates and Timezones? Dates and Timezones in SQL / JDBC!
There was an interesting discussion recently on the jOOQ mailing list about jOOQ’s current lack of out-of-the-box support for TIMESTAMP…
Read More » -
Software Development
Implementing Client-Side Row-Level Security with jOOQ
Some time ago, we’ve promised to follow up on our Constraints on Views article with a sequel showing how to…
Read More » -
Software Development
Northwind: Finding direct/transitive Reports in SQL and Neo4j’s Cypher
Every few months we run a relational to graph meetup at the Neo London office where we go through how…
Read More » -
Software Development
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…
Read More » -
Enterprise Java
Do Not Make This Mistake When Developing an SPI
Most of your code is private, internal, proprietary, and will never be exposed to public. If that’s the case, you…
Read More » -
Software Development
How SQL GROUP BY Should Have Been Designed – Like Neo4j’s Implicit GROUP BY
In the recent past, we’ve explained the syntactic implications of the SQL GROUP BY clause. If you haven’t already, you…
Read More »
