Listicles like these do work - not only do they attract attention, if the content is also valuable (and in this case it is, trust me), the article format can be extremely entertaining. This article will bring you 10 SQL tricks that many of you might not have thought were possible. The article is a … Continue reading 10 SQL Tricks That You Didn’t Think Were Possible
Month: April 2016
The Parameterless Generic Method Antipattern
A very interesting question was posted to Stack Overflow and reddit just recently about Java generics. Consider the following method: <X extends CharSequence> X getCharSequence() { return (X) "hello"; } While the unsafe cast seems a bit wonky, and you might guess there's something wrong here, you can still go ahead and compile the following … Continue reading The Parameterless Generic Method Antipattern
jOOQ Tuesdays: Ming-Yee Iu Gives Insight into Language Integrated Querying
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: Ming-Yee Iu Gives Insight into Language Integrated Querying
Would We Still Criticise Checked Exceptions, If Java had a Better try-catch Syntax?
In the context of a previous blog post about JUnit 5, Maaartinus, one of our readers, has brought up a very interesting idea: The only problem with try-catch is its verbosity, which is something I can live with (IMHO a lone catch would do better, the implicit try would apply to all preceding code in … Continue reading Would We Still Criticise Checked Exceptions, If Java had a Better try-catch Syntax?
Using jOOQ’s ExecuteListener to Prevent Write Operations on a Connection
Security is important, especially on the data access layer. Most commercial databasese allow for fine-grained privilege control using database access grants. For instance, you would be restricting access from a user to a certain set of tables (or even better: views), via GRANT statements: GRANT SELECT ON table TO user; With this fine-grained access control, … Continue reading Using jOOQ’s ExecuteListener to Prevent Write Operations on a Connection
Using SQL to Calculate the Popularity (on Stack Overflow) of Derby, H2, and HSQLDB
Few people know about this very very awesome feature of the Stack Exchange platform. The Stack Exchange Data Explorer To be found here: http://data.stackexchange.com As you may know, much of the Stack Exchange platform runs on SQL Server (interesting architecture details here: http://stackexchange.com/performance), and the team has had the courtesy of making a lot of … Continue reading Using SQL to Calculate the Popularity (on Stack Overflow) of Derby, H2, and HSQLDB
jOOQ 4.0’s New API Will Use Annotations Only for Truly Declarative Java/SQL Programming
SQL is the only really popular and mature 4GL (Fourth Generation Programming Language). I.e. it is the only popular declarative language. At the same time, SQL has proven that turing completeness is not reserved to lesser languages like C, C++, or Java. Since SQL:1999 and its hierarchical common table expressions, SQL can be safely considered … Continue reading jOOQ 4.0’s New API Will Use Annotations Only for Truly Declarative Java/SQL Programming