Lukas Eder, jOOQ - Type Safe Domain Specific SQL Construction and Execution

Hi everyone!

We're very pleased & grateful to announce that another Java Champion is presenting us in Dublin, the self titled "Minister of Bringing Sanity Back to Java", Lukas Eder.

Lukas will be joining us in the second week of October to present & talk about j00Q (http://www.jooq.org/) - a popular, multifaceted &lightweight orm / sql interaction library.

Lukas Eder

Lukas is the CEO of Data Geekery (http://www.datageekery.com/), a service offering open source products and APIs based on Java Object Oriented Querying (jOOQ) (http://www.jooq.org/). He has been the main contributor to the open source jOOQ project for many years. Lukas is also a consultant and a trainer on SQL and Java 8. He writes about topics related to jOOQ, SQL and Java on the blog http://blog.jooq.org

Lukas is a member of the board of the Java User Group Switzerland (JUG.ch), where he brings popular speakers to conferences in Zurich, Bern, Lucerne, and Basel. He is involved with the program committee of Voxxed Zurich and other Java conferences. Lukas has been a speaker at many Java conferences such as Geekout, Geecon, and Devoxx for many years. Follow him at @lukaseder (http://twitter.com/lukaseder)

Talk: Get Back in Control of Your SQL with jOOQ

Java does not provide an API to directly support the expressiveness and power of SQL. All attention is given to object-relational mapping and abstractions on a higher level, such as OQL, HQL, JPQL, CriteriaQuery.

jOOQ is a dual-licensed Open Source product filling this gap. It implements SQL itself as a type safe domain-specific language in Java.

jOOQ is a good choice in a Java application where SQL and its proprietary features of the database in use are important. It shows, how a modern domain-specific language can greatly increase developer productivity, internalising SQL into Java.

Call for Speakers & Presenters

I'd like to re-iterate our call for people to give talks, we've had some folks reach out but could always use more, we will be able to host more great meetups!

We're looking for members to give short, informal 10-20 minute talks, about anything related to Java or the JVM, please reach out if you're interested.

Agenda

• 7pm Networking & pizza

• 7:15pm + Lukas Eder - Get Back in Control of Your SQL with jOOQ

SQL Masterclass
We do want to let ye know about a separate training event Lukas is giving at the AOL Building, in the same building as the meetup event, if any of you are interested -

A deep dive SQL masterclass delivered by a true expert in the field, Lukas Eder, creator of the powerful Jooq library.

https://ti.to/instil/sql-masterclass

Outline

DAY 1 - SQL Functionality

• Introduction to the course databases and revision of core SQL constructs

• Techniques for writing SQL to maximise performance

• Advanced constructs, such as row value expressions and hierarchical SQL

• Applying window functions for complex calculations within the database

• Modern use of DML (e.g. using MERGE instead of INSERT and UPDATE)

• Using esoteric data types ( json, hstore, arrays, composite types, ranges etc…)

DAY 2 - SQL Performance

• The inner workings of an index

• The cost-based optimizer

• Why constraints are so important for performance

• Writing performant predicates

• Faster DMLAntipatterns, myths, and best practices

Please go to https://ti.to/instil/sql-masterclass for more details on this course