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

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 security with jOOQ. What is row-level security? Some databases like Oracle or the upcoming PostgreSQL 9.5 provide native support for row-level security, which is awesome - but not every database has this … 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)

JavaEE or Spring? Neither! We Call Out For a Fresh Competitor!

If you've been following some key Java people on Twitter or reading the "news" on Reddit, you could not have missed the hilarious quarrel between some Spring and JavaEE evangelists. First, Jürgen Höller's provocative article: "Happy second birthday, Java EE 7! How is it going in production?" Then, Reza Rahman's response: "The Ghosts of Java … Continue reading JavaEE or Spring? Neither! We Call Out For a Fresh Competitor!

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?