Do you really need Hibernate?

Hibernate is often used without thinking twice. But is that the best solution in all cases? This talk shows another possibility that can lead to better performance in many cases.

Projects often use Java Persistence API (JPA) by default and, thus, mostly Hibernate. But do all applications need a comprehensive object/relational mapping (ORM) with all conceivable functions?

This talk examines the architecture of database-centric applications and discusses whether you always need an object graph for persistence.

An example application shows how pure SQL, with the help of jOOQ and (nested) Java Records, simplifies data access and how common ORM problems, such as the n+1 select problem, can be avoided. Finally, the possibility of combining jOOQ and JPA/Hibernate and thus using the best of both worlds is discussed.

Transcript

1. Do you really need Hibernate? Building data-centric applications with jOOQ Simon Martinelli @simas_ch martinelli.ch
2. About me 1972 1995 2000 2007 2009 2011 2012 2013 2021 2022 2023 COBOL JSR-352 Java Batch JSR-354 Money/Currency
3. JTAF - Track and Field - https://jtaf.ch
5. JPA vs jOOQ • Most conceptual differences between JPA and jOOQ are not technology-specific, but a matter of how you think about your database interactions • There are two approaches 1. Working with entity state transitions 2. Working with data set transformations • Neither approach is "the best" one; both approaches are better suited to certain use cases
7. Where to Start? • Example Project • https://github.com/simasch/jooq-examples • Official Documentation • https://jooq.org • jOOQ Demo • https://github.com/jOOQ/demo
8. Database First • jOOQ assumes your database already exists • But it does not assume your database follows any rules imposed by jOOQ regarding the design
9. DB jOOQ Generator Java Classes jOOQ DSL How does jOOQ work?
11. jOOQ and JPA
12. And now? Which one to use? • jOOQs superpower • Querying • Reading nested objects • Calling functions/stored procedures • Bulk updates and deletes • JPAs superpower • Entity state transition • Cascading insert, update, delete, and orphan removal
13. Thank you! Web https://martinelli.ch E-Mail simon@martinelli.ch Twitter simas_ch LinkedIn https://linkedin.com/in/simonmartinelli