Typesafe’s Slick is Not About SQL

We have stumbled upon an interesting thread on the Typesafe SLICK user group where Slick was compared to jOOQ. In that thread, Christopher Vogt has made a couple of interesting statements. But let us have a look at the broader context, first. Unifying Stuff Ever since the proclamation of UDDI or RUP, we may think that … Continue reading Typesafe’s Slick is Not About SQL

jOOQ Newsletter: December 30, 2013. Happy New Year!

subscribe to the newsletter here Tweet of the Day We would like to contribute this new section of the newsletter to our followers, users, and customers. Here's Andy Van Den Heuvel, who appreciates jOOQ's and MyBatis' (both being "post-JPA" frameworks) return to SQL. https://twitter.com/andyvdh7/status/416685921288093696 2013 from jOOQ's perspective 2013 was a very exciting year for jOOQ and jOOQ customers. … Continue reading jOOQ Newsletter: December 30, 2013. Happy New Year!

MySQL Bad Idea #666

MySQL... We've blogged about MySQL before. Many times. We've shown bad ideas implemented in MySQL here: MySQL Bad Idea #384 MySQL Bad Idea #573 But this beats everything. Check out this Stack Overflow question. It reads: "Why Oracle does not support 'group by 1,2,3'?". At first, I thought this user might have been confused because … Continue reading MySQL Bad Idea #666

The Great SQL Implementation Comparison Page

Fortunately, we have SQL standards. Or do we? It's a well-known secret (or cynical joke) that the SQL standard is yet another SQL dialect among peers. On this blog, we have pointed out so many differences between SQL dialects, it is hard to believe that anyone would even consider writing SQL strings rather than using … Continue reading The Great SQL Implementation Comparison Page

Ecto a Slick Query DSL for the Elixir Language

Elixir? What on earth is Elixir? It is a programming language that somewhat reminds me of Ruby. Here is some example Elixir code: defmodule Hello do IO.puts "Defining the function world" def world do IO.puts "Hello World" end IO.puts "Function world defined" end And it has a Stack Overflow community with around 50 tagged questions … Continue reading Ecto a Slick Query DSL for the Elixir Language

MyBatis’ Alternative Transaction Management

On the jOOQ user group, we're often being asked how to perform transaction management with jOOQ. And we have an easy answer ready: You don't do that with jOOQ. You choose your favourite transaction management API, be it: JDBC Spring JEE JTA (e.g. as supported by Weblogic) Bitronix TM Hibernate And the above list is far … Continue reading MyBatis’ Alternative Transaction Management

A Bit of SQL History

SQL has been around for a while. Just recently, I've read this refreshing article about Codd's Relational Vision - Has NoSQL Come Full Circle? SQL is one of those awesome technologies that was invented almost two generations ago, and we're still using it in production and for new projects. It is both legacy and state-of-the-art. The … Continue reading A Bit of SQL History

Simplernate. A Query DSL for Hibernate, Inspired by jOOQ

"Simplernate" ! The name is very compelling. And so is the idea - we think. Specifically, because we get most credit for this new project in the following short readme: https://gist.github.com/thermz/eb1b12b2146168a08e68 It reads: Simplernate is (will be) an Hibernate wrapper that help developer to query the database using Hibernate ORM. To do this, Simplernate offers a … Continue reading Simplernate. A Query DSL for Hibernate, Inspired by jOOQ

MongoDB “Lightning Fast Aggregation” Challenged with Oracle

What does "Scale" even mean in the context of databases? When talking about scaling, people have jumped to the vendor-induced conclusion that: SQL doesn't scale NoSQL scales It is very obvious that NoSQL vendors make such claims. It has also been interesting that many NoSQL consumers made such claims, even if they probably confused SQL … Continue reading MongoDB “Lightning Fast Aggregation” Challenged with Oracle

The Crystal Ball. Or, Oops, Michael Stonebraker did it Again

Michael Stonebraker's opinions and claims are always refreshing to read. He's done a lot for our industry and for how we do data processing. Some of his claims are certainly right as well. Here's an interview with him, telling us about his 5 predictions on the future of databases. Of course, him being a software … Continue reading The Crystal Ball. Or, Oops, Michael Stonebraker did it Again