SQL
-
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 » -
Enterprise Java
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 » -
Software Development
It’s the Little Things: The PL/SQL NULL Statement, and why Every Language Should have One
Syntax is one of those topics. One of those emotional topics that lead to very very very important discussions. I…
Read More » -
Enterprise Java
How to Avoid the Dreaded Dead Lock when Pessimistic Locking – And some Awesome Java 8 Usage!
Sometimes you simply cannot avoid it: Pessimistic locking via SQL. In fact, it’s an awesome tool when you want to…
Read More »