jOOQ Newsletter: November 28, 2014 – Black Friday jOOQ Sale – Only Today!

Subscribe to this newsletter here Tweet of the Day and Webinar with Arun Gupta from Red Hat Today, we have a very special Tweet of the Day by Oliver Hubaut who expresses what we believe is a general feeling in the industry. He says: https://twitter.com/ohubaut/status/531783784023465984 There is a lot of truth in his statement, albeit … Continue reading jOOQ Newsletter: November 28, 2014 – Black Friday jOOQ Sale – Only Today!

Use MySQL’s Strict Mode on all new Projects!

MySQL is a database that has been bending the SQL standard in ways that make it hard to move off MySQL. What may appear to be a clever technique for vendor lockin (or maybe just oversight of the standard) can be quite annoying in understanding the real meaning of the SQL language. One such example … Continue reading Use MySQL’s Strict Mode on all new Projects!

Don’t Migrate to MariaDB just yet. MySQL is Back!

Now that I have your attention, I'd like to invite you to a critical review of where we're at in the MySQL vs. MariaDB debate. Around one month ago, I visited Oracle Open World 2014, and I've met with Morgan Tocker, the MySQL community manager at Oracle to learn about where MySQL is heading. Who … Continue reading Don’t Migrate to MariaDB just yet. MySQL is Back!

Have You Ever Wondered About the Difference Between NOT NULL and DEFAULT?

When writing DDL in SQL, you can specify a couple of constraints on columns, like NOT NULL or DEFAULT constraints. Some people might wonder, if the two constraints are actually redundant, i.e. is it still necessary to specify a NOT NULL constraint, if there is already a DEFAULT clause? The answer is: Yes! Yes, you … Continue reading Have You Ever Wondered About the Difference Between NOT NULL and DEFAULT?

Don’t Miss out on Awesome SQL Power with FIRST_VALUE(), LAST_VALUE(), LEAD(), and LAG()

If you're using a commercial database or PostgreSQL / Firebird / CUBRID, you will be able to take advantage of the full power of window functions. We've blogged about window functions' awesomeness a couple of times, in particular about ROW_NUMBER(), RANK(), DENSE_RANK(). Today, we're going to look into some awesome window functions that produce values … Continue reading Don’t Miss out on Awesome SQL Power with FIRST_VALUE(), LAST_VALUE(), LEAD(), and LAG()

Painless Access from Java to PL/SQL Procedures with jOOQ

A procedural language combined with SQL can do miracles in terms of productiveness, performance and expressivity. In this article, we'll see later on, how we can achieve the same with SQL (and PL/SQL) in Java, using jOOQ. But first, a little bit of history... Accessing PL/SQL from Java One of the biggest reasons why Java … Continue reading Painless Access from Java to PL/SQL Procedures with jOOQ

10 Things You Didn’t Know About Java

So, you've been working with Java since the very beginning? Remember the days when it was called "Oak", when OO was still a hot topic, when C++ folks thought that Java had no chance, when Applets were still a thing? I bet that you didn't know at least half of the following things. Let's start … Continue reading 10 Things You Didn’t Know About Java