CUBRID: A Lesser-Known Korean OSS Database Gem

While RedHat and Google have been dumping MySQL for MariaDB, there's actually a third, much lesser-known option for MySQL-oriented database folks in the RDBMS market: CUBRID. One of CUBRID's main goals is also to lure MySQL users away from Oracle by offering many equivalent syntax elements that are available in either the MySQL or Oracle … Continue reading CUBRID: A Lesser-Known Korean OSS Database Gem

jOOQ Newsletter October 28, 2013

subscribe to the newsletter here jOOQ 3.2 Licensing Update Three weeks ago, we have announced and released jOOQ 3.2 under the terms of a new dual-licensing model offering jOOQ's support for commercial databases under a commercial jOOQ license. The jOOQ community has reacted intensively on the user group, most of the feedback having been very positive. The licensing … Continue reading jOOQ Newsletter October 28, 2013

Top 5 Useful Hidden Eclipse Features

Eclipse is a beast. A device whose mystery is only exceeded by its power. Some would call it a continuum transfunctioner. Others would call it a transmogrifier. Yes, it is so huge, it takes years to master. And then, your manager shows up and tells you: We're using NetBeans now. Just kidding. No one uses … Continue reading Top 5 Useful Hidden Eclipse Features

Faster SQL Pagination with jOOQ Using the Seek Method

Last week, I have blogged about why it is important to stay in control of your SQL, as writing good SQL helps keeping your operations costs down. This is true in many ways and today, we're going to look into another way to write good, high-performing SQL: Using the "Seek Method". Slow OFFSET In order … Continue reading Faster SQL Pagination with jOOQ Using the Seek Method

Why Staying in Control of Your SQL is so Important

Lots of blog posts and research papers are written about the topics of scaling up and scaling out. This interesting blog post, for instance, sheds some light on the two strategies with respect to physical maintenance costs, such as cooling and electricity consumption. Certainly non-negligible aspects for very large systems. But before solving problems at … Continue reading Why Staying in Control of Your SQL is so Important

Recursive SQL for Data Normalisation

Recursive SQL can be awesome, although a bit hard to read in its SQL standard beauty. Let's assume you have some aggregated data with dates and a number of events per date: | DATE | COUNT | |--------------------------------|-------| | October, 01 2013 00:00:00+0000 | 2 | | October, 02 2013 00:00:00+0000 | 1 | | … Continue reading Recursive SQL for Data Normalisation

Who Says “I Want to Contribute” ?

In recent posts, I've been a bit critical with Open Source. But doing Open Source is a lot of fun. The publicity of feedback is thrilling and encouraging. And then, there's the "I want to contribute" phenomenon. Those guys that are so thrilled with your wicked product that will change the world, they want to … Continue reading Who Says “I Want to Contribute” ?

On Degrading Merchandise Quality

I've just replaced 4 halogen bulbs in my appartment. When I threw the old ones into our recycling bin, I've noticed that there were already around 8 bulbs in there. From the last 5-6 months, only! This made me sad, as it shows how our consumer society works. Read on to learn how jOOQ strives to … Continue reading On Degrading Merchandise Quality

A Significant Difference Between Open Source and Commercial Software

A recent event has triggered a lot of interest in the debate about the good and the bad parts of Open Source. Oracle's attack on Open Source. For large corporations who aren't Red Hat, taking a stand on the topic is far from easy. Oracle used to sell only commercial software, but has since acquired … Continue reading A Significant Difference Between Open Source and Commercial Software

Add Some Entropy to Your JVM

Being able to generate true random numbers depends on the entropy in your system. Some claim, that this can be guaranteed by fair dice roll. Others think that replacing the OpenJDK's java.math.Random.nextInt() method with this body will help: public int nextInt() { return 14; } Source: http://www.redcode.nl/blog/2013/10/openjdk-and-xkcd-random-number/. But that's absurd. We all know that the best … Continue reading Add Some Entropy to Your JVM