JOOQ, Joy of SQL
summary
jOOQ is presented as a lightweight Java DSL that keeps real SQL at the center by generating Java types from the database schema and providing compile-time safety instead of ORM magic. It integrates with JDBC or R2DBC via a code generator that connects to the database, supports Java records and Optionals, emulates dialect features (e.g. LIMIT emulation), adds JSONB operators, multiset mapping (since 3.15) and window functions. A concrete example shows a podcast search engine using a two-step query (fetch 12 ids, then join details) to improve performance and reliability in production.
AI-written summary · about
chapters (23)
- 0:00JOOQ and SQL intro
- 1:44SQL discovery importance
- 3:05SQL declarative paradigms
- 5:11JDBC/JPA limits
- 7:37ORM alternatives history
- 10:46Annotations side effects
- 14:17Back to raw SQL
- 15:01JOOQ as SQL DSL
- 16:26JOOQ code generation
- 18:55Strong typing with JOOQ
- 21:04Simple query joins
- 22:28N:M relations in JOOQ
- 23:33Advanced JOOQ features
- 26:44JOOQ robust solution
- 28:49JOOQ JPA Records
- 30:13Case study search engine
- 34:46Modern SQL evolutions
- 35:51SQL stats aggregations
- 37:55Window functions power
- 39:18JOOQ PostgreSQL extensions
- 41:44PostgreSQL versatile DB
- 42:49Why learn SQL
- 44:34Conclusion demo
related talks
50mJOOQ Data Abstractions Without Distraction
46mjOOQ as an Alternative to ORM
54mDo you really need Hibernate
43mDo You Really Need Hibernate?
49mDatabase-centric Applications with Spring Boot and jOOQ
48mCQRS in the small with Java Records and jOOQ
46mThe State of Java Relational Persistence
49mDo You Really Need Hibernate?