jOOQ Newsletter September 2013

Subscribe to this newsletter here

SQL Popularity and Controversy

Together, the above articles have have reached out to more than 200’000 readers on the jOOQ Blog and through our syndication partners in only one month.

This has been topped by two more, very interesting articles about Prof. Michael Stonebraker’s recent claims. In “The Traditional RDBMS Wisdom is All Wrong”, Stonebraker, who has given us nothing less than Ingres, Postgres, Vertica, Streambase, Illustra, VoltDB, SciDB shows that he is also well-known for his stirring of controversy.

Read also the follow-up article Teaching an Old Elephant New Tricks, where Stonebraker’s claims are addressed by Oracle and SQL Server.

With Stonebraker’s (and others’) efforts to bring SQL and “NewSQL” back to the market, SQL’s popularity is bound to be on the rise again. Few other languages stir so many emotions when it comes to commenting on tutorials like 10 Easy Steps to a Complete Understanding of SQL, which triggered lots of discussion both on reddit, and on hackernews.

jOOQ Public Talks and Trainings

jOOQ responds to SQL’s popularity by embracing SQL as a first-class citizen into your stack. Curious about how jOOQ works, or how it could work in your organisation? Then join any of the upcoming events:

  • The jOOQ training sessions at the /ch/open workshop days in Zurich, Switzerland (in German)
  • The jOOQ introductory session at the JUGH in Kassel, Germany (in German)

Feel free to contact us at contact@datageekery.com if you’re interested in a Training session close to you.

jOOQ Newsletter August 2013

Subscribe to this newsletter here

Overwhelming feedback from the jOOQ User Survey

jOOQ has been the leading Java Open Source SQL building tool for the last three years. Feedback on social media such as Facebook, Twitter, reddit, Stack Overflow has been very positive.

The recent user survey was well received by an increasingly growing jOOQ community. It has shown a couple of interesting facts:

  • jOOQ users are highly proficient with Java and SQL
  • jOOQ users mainly concentrate on using H2, MySQL, Oracle, PostgreSQL, and SQL Server
  • jOOQ’s maturity is mostly appreciated for mission-critical applications
  • jOOQ users are generally satisfied or very satisfied with jOOQ’s mission, support and quality

Thank you for taking the time to complete the user survey. Your valuable comments will help jOOQ to take the right direction in the future, providing you with even more value.

SQL popularity still high

In recent years, many NoSQL vendors have surfaced to sell their alternative data stores and query languages. Some of them aim to solve entirely different problems than relational data stores. But as in pre-ANSI-SQL times, there is a huge amount of incompatible proprietary query languages and techniques.

SQL is standardised by ANSI / ISO and its vendors can still grow their market shares as the Big Data buzz is increasing. A clear sign of SQL’s popularity is the success that these Top 10 Mistakes articles had, recently, on DZone:

jOOQ 3.2 feature outlook

New jOOQ users have contributed new awesome ideas to the community. These include:

A new SPI to hook into query rendering and variable binding

This SPI will allow jOOQ users to perform arbitrary SQL transformations based on query rendering and variable binding events. A very common use-case is to listen for a given set of well-known tables and generate additional filtering predicates in the SQL WHERE clause, centrally restricting access to data.

This not only allows for adding an additional, transparent security layer to your SQL code generation, it will also allow for implementing multi-tenancy in shared-schema environments.

A new SPI to hook into CRUD operations

Many users profit from jOOQ’s ActiveRecord-style CRUD API. This API will be enhanced with a powerful SPI that allows to hook into store(), insert(), update(), delete(), refresh() operations.

A common use-case for this is data initialisation prior to inserts, or ID-generation.