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 »

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 »

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 »

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 »

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 »

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 »

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 »

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 »

jOOQ Tuesdays: Vlad Mihalcea Gives Deep Insight into SQL and Hibernate

Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month…

Read More »