Loading…
This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
The first ever VOXXED Days Vienna event will run on 6th February, 2015, at CINEPLEXX WIENERBERG. This developer conference will bring together popular speakers, core developers of popular open source technologies and professionals willing to share their knowledge and experiences.
Voxxed Days Vienna is part of the Voxxed Days - a series of one day tech events organised by local community groups and supported by the Voxxed team. Sharing the Devoxx philosophy that content comes first, these events will bring together internationally renowned speakers at an even wider range of locations around the world. 
View analytic
Friday, February 6 • 14:20 - 15:10
Get Back in Control of Your SQL with jOOQ

Sign up or log in to save this to your schedule and see who's attending!

SQL is a powerful and highly expressive language for queries against relational databases. SQL is established, standardised and hardly challenged by alternative querying languages. Nonetheless, in the Java ecosystem, there had been few relevant steps forward since JDBC to better integrate SQL into Java. All attention was given to object-relational mapping and language abstractions on a higher level, such as OQL, HQL, JPQL, CriteriaQuery. In the mean time, these abstractions have become almost as complex as SQL itself, regardless of the headaches they're giving to DBAs who can no longer patch the generated SQL.

jOOQ is a dual-licensed Open Source product filling this gap. It implements SQL itself as an internal domain-specific language in Java, allowing for the typesafe construction and execution of SQL statements of arbitrary complexity. This includes nested selects, derived tables, joins, semi-joins, anti-joins, self-joins, aliasing, as well as many vendor-specific extensions such as stored procedures, arrays, user-defined types, recursive SQL, grouping sets, pivot tables, window functions and many other OLAP features. jOOQ also includes a source code generator allowing you to compile queries in modern IDEs such as Eclipse very efficiently.

jOOQ is a good choice in a Java application where SQL and the specific relational database are important. It is an alternative when JPA / Hibernate abstract too much, JDBC too little. It shows, how a modern domain-specific language can greatly increase developer productivity, internalising SQL into Java.

Speakers
avatar for Lukas Eder

Lukas Eder

Founder and CEO, Data Geekery GmbH
I am the founder and CEO of Data Geekery GmbH, located in Zurich, Switzerland. With our company we have been selling database products and services around Java and SQL since 2013. Ever since my Master's studies at EPFL in 2006, I have been fascinated by the interaction of Java and SQL. Most of this experience I have obtained in the Swiss E-Banking field through various variants (JDBC, Hibernate, mostly with Oracle). I am happy to share this... Read More →


Friday February 6, 2015 14:20 - 15:10
Room 08

Attendees (6)