Have you ever wondered how you could express a predicate that "feels" like the following, in SQL: WHERE Var1 OR Var2 IN (1, 2, 3) /u/CyBerg90 has, on reddit. The idea was to create a predicate that yields true whenever both values Var1 and Var2 yield either 1, 2, or 3. The canonical solution The … Continue reading INTERSECT – the Underestimated Two-Way IN Predicate
Java 8’s Method References Put Further Restrictions on Overloading
Method overloading has always been a topic with mixed feelings. We've blogged about it and the caveats that it introduces a couple of times: You Will Regret Applying Overloading with Lambdas! Keeping things DRY: Method overloading Why Everyone Hates Operator Overloading API Designers, be Careful There are two main reasons why overloading is useful: To … Continue reading Java 8’s Method References Put Further Restrictions on Overloading
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 SQL?" and most of the existing answers went on about citing C.J. Date or Tony Hoare and unanimously declared NULL as "evil". So, everyone rants about NULL all the time. Let me counter-rant. Academics Of … Continue reading NULL is Not The Billion Dollar Mistake. A Counter-Rant
What the sun.misc.Unsafe Misery Teaches Us
Oracle will remove the internal sun.misc.Unsafe class in Java 9. While most people are probably rather indifferent regarding this change, some other people - mostly library developers - are not. There had been a couple of recent articles in the blogosphere painting a dark picture of what this change will imply: Dripstat's Removal of sun.misc.Unsafe … Continue reading What the sun.misc.Unsafe Misery Teaches Us
What’s Even Harder Than Dates and Timezones? Dates and Timezones in SQL / JDBC!
(Notice, this post has been written a while ago. jOOQ now supports JSR 310 data types) There was an interesting discussion recently on the jOOQ mailing list about jOOQ's current lack of out-of-the-box support for TIMESTAMP WITH TIME ZONE data types. No one said that date, time and timezones are easy! There's an amusing piece … Continue reading What’s Even Harder Than Dates and Timezones? Dates and Timezones in SQL / JDBC!
How to Debug Your Maven Build with Eclipse
When running a Maven build with many plugins (e.g. the jOOQ or Flyway plugins), you may want to have a closer look under the hood to see what's going on internally in those plugins, or in your extensions of those plugins. This may not appear obvious when you're running Maven from the command line, e.g. … Continue reading How to Debug Your Maven Build with Eclipse
Implementing Client-Side Row-Level Security with jOOQ
Before you read on, please note that since jOOQ 3.19, policies are supported out of the box, to implement the same functionality in a much simpler way than what this article suggests! Some time ago, we've promised to follow up on our Constraints on Views article with a sequel showing how to implement client-side row-level … Continue reading Implementing Client-Side Row-Level Security with jOOQ
Querying Your Database from Millions of Fibers (Rather than Thousands of Threads)
jOOQ is a great way to do SQL in Java and Quasar fibers bring a much improved concurrency We're excited to announce another very interesting guest post on the jOOQ Blog by Fabio Tudone from Parallel Universe. Parallel Universe develops an open-source stack that allows developers to easily code extremly concurrent application on the JVM. … Continue reading Querying Your Database from Millions of Fibers (Rather than Thousands of Threads)
jOOQ Tuesdays: Axel Fontaine Predicts Exciting Times as our Industry is Maturing
Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month where we interview someone we find exciting in our industry from a jOOQ perspective. This includes people who work with SQL, Java, Open Source, and a variety of other related topics. We have the pleasure … Continue reading jOOQ Tuesdays: Axel Fontaine Predicts Exciting Times as our Industry is Maturing
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?