What do people do when they run out of topics? They recycle previous topics and create top 10 lists. Here is a list of the top 10 most popular articles from the jOOQ blog:
- Top 10 Very Very VERY Important Topics to Discuss
A fun, not so serious parody on what is being discussed on reddit’s /r/programming. Hint: Bikeshedding topics are the most popular. Like this one. That was so meta!
- 10 Subtle Best Practices when Coding Java
This is a really interesting article about not-so-common advice that might be handy every once in a while.
- 10 Common Mistakes Java Developers Make when Writing SQL
A classic and must-read for all SQL developers (not only those that usually write Java)
- SQL Trick: row_number() is to SELECT what dense_rank() is to SELECT DISTINCT
We’re surprised ourselves that this is so popular. But it appears that we’re really well ranked on Google when people are looking for ROW_NUMBER() and DENSE_RANK(). And the trick is very useful, of course!
- Why You Should NOT Implement Layered Architectures
What a silly rant! And how it went up in the ranking within only two days! This is not really very serious advice. Obviuosly, you should (as always) do what fits best to your problem domain. But we wanted to make people think about the status quo and how it is often applied too rigidly, without thinking about all the options. Looks like we’ve hit a sweet spot with developers frustrated with overengineered applications…
- MIT Prof. Michael Stonebraker: “The Traditional RDBMS Wisdom is All Wrong”
Michael Stonebraker is a very controversial person per se. In this article, we’re linking to a talk by Stonebraker where he claims (again) that the RDBMS end is nigh. A year later, we can see that NoSQL is still on the rise, whereas NewSQL is still no where. See also the next article…
- The 10 Most Popular DB Engines (SQL and NoSQL)
This is an interpretation of a popular ranking of (R)DBMS, showing that even if Oracle, MySQL, and SQL Server are the most wide-spread databases, something’s about to change.
- Does Java 8 Still Need LINQ? Or is it Better than LINQ?
Again, controversy is king. Of course, LINQ is awesome and often we wish we had something like LINQ in Java. In this article, however, we’re claiming that with Java 8’s Streams API and lambda expressions, we might no longer need LINQ, as collections transformation is already sufficiently covered, and LINQ-to-SQL is not what made LINQ popular (which is where jOOQ is more useful)
- 10 More Common Mistakes Java Developers Make when Writing SQL
A follow-up article to the previous, very popular article about common SQL mistakes. Yes, there’s a lot to learn in this area.
- The Java Fluent API Designer Crash Course
From a jOOQ perspective, this is one of the most interesting articles explaining the very simple and easy-to-apply rules that we’re using to produce our API in the form of an internal domain-specific language. If you want to build jOOQ for your own query language (e.g. Cassandra’s CQL), just follow these simple rules
Thanks for reading our blog! We promise to keep you up to date with more interesting (and occasionally useless) content!