jOOQ Masterclass (Packt)
Monday, 05 September 2022

This book, subtitled "A practical guide for Java developers to write SQL queries for complex database interactions" covers jOOQ from beginner to expert level using examples for MySQL, PostgreSQL, SQL Server, and Oracle that show you how jOOQ is a mature and complete solution for implementing the persistence layer. Anghel Leonard shows how to use the jOOQ query builder framework to emulate database-specific SQL statements using a fluent, intuitive, and flexible DSL API.

<ASIN:1800566891>

The book shows how to use jOOQ in Spring Boot apps as a replacement for SpringTemplate and Spring Data JPA, and how to use jOOQ type-safe queries and CRUD operations via jOOQ's records, converters, bindings, types, mappers, multi-tenancy, logging, and testing. Later, the book shows how to use jOOQ to use SQL features such as UDTs, embeddable types and embedded keys.

Author: Anghel Leonard
Publisher: Packt Publishing
Date: August 2022
Pages: 764
ISBN: 978-1800566897
Print: 1800566891
Kindle: B09XHTBDJY
Audience: Java and database developers
Level: Intermediate
Category: Database and Java

 

  • Enable the jOOQ Code Generator in any combination of Java and Kotlin, Maven and Gradle
  • Generate jOOQ artifacts directly from database schema, or without touching the real database
  • Use jOOQ DSL to write and execute a wide range of queries for different databases
  • Understand jOOQ type-safe queries, CRUD operations, converters, bindings, and mappers
  • Implement advanced SQL concepts such as stored procedures, derived tables, CTEs, window functions, and database views
  • Implement jOOQ multi-tenancy, tuning, jOOQ SPI, logging, and testing

 

 

For recommendations of Java books see Java Books For Beginners, Java Books For Going Further and Advanced Java - Books Outside the Core in our Programmer's Bookshelf section.

 

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.

 

 

Banner
 


Driving Value With Sprint Goals

Author: Maarten Dalmijn
Publisher: Addison-Wesley
Pages: 256
ISBN: 9780137381920
Print: 0137381921
Kindle:B0C7ZJR7N2
Audience: Scrum developers
Rating: 5
Reviewer: Kay Ewbank

Over the years I've read a lot of books about agile development and Scrum, and most concentrate on the methodology rather tha [ ... ]



SQL Query Design Patterns and Best Practices

Author: Steve Hughes et al
Publisher: Packt Publishing
Pages: 270
ISBN: 978-1837633289
Print: 1837633282
Kindle: B0BWRD7HQ7
Audience: Query writers
Rating: 2.5
Reviewer: Ian Stirk

This book aims to improve your SQL queries using design patterns, how does it fare? 


More Reviews