Update cookies preferences

E-book: Beginning jOOQ: Learn to Write Efficient and Effective Java-Based SQL Database Operations

  • Format: PDF+DRM
  • Pub. Date: 27-Oct-2021
  • Publisher: APress
  • Language: eng
  • ISBN-13: 9781484274316
  • Format - PDF+DRM
  • Price: 55,56 €*
  • * the price is final i.e. no additional discount will apply
  • Add to basket
  • Add to Wishlist
  • This ebook is for personal use only. E-Books are non-refundable.
  • Format: PDF+DRM
  • Pub. Date: 27-Oct-2021
  • Publisher: APress
  • Language: eng
  • ISBN-13: 9781484274316

DRM restrictions

  • Copying (copy/paste):

    not allowed

  • Printing:

    not allowed

  • Usage:

    Digital Rights Management (DRM)
    The publisher has supplied this book in encrypted form, which means that you need to install free software in order to unlock and read it.  To read this e-book you have to create Adobe ID More info here. Ebook can be read and downloaded up to 6 devices (single user with the same Adobe ID).

    Required software
    To read this ebook on a mobile device (phone or tablet) you'll need to install this free app: PocketBook Reader (iOS / Android)

    To download and read this eBook on a PC or Mac you need Adobe Digital Editions (This is a free app specially developed for eBooks. It's not the same as Adobe Reader, which you probably already have on your computer.)

    You can't read this ebook with Amazon Kindle

Learn to use the jOOQ library to manage SQL database operations in Java and JVM applications. This book walks you through what JOOQ is, how to install and get started with it, and then gets you working with it.





Practical examples and case studies demonstrate how jOOQ offers a more efficient and versatile alternative to Object-Relational Mapping frameworks like Hibernate and JPA, while providing a natural, native-SQL feeling for the developer. You'll see how to maximize the full potential of your SQL database with advanced query syntax and functions with this lightweight, SQL-friendly framework. Come see how you can use high performance approaches like reactive, data streaming and cloud-native programming to get data from SQL tables.





Never write another incorrect SQL statement again and protect your application from SQL injection with the strong typing and inbuilt controls in jOOQ. Learn how to add jOOQ to your existing Hibernate, Spring Boot or Quarkus applications.





When youve completed this book, you will be able to take the knowledge youve gained, along with the freely available source code, and directly apply them to your own work.





What You Will Learn













Comparing equivalent features between Hibernate, JPA and jOOQ Unlock the power of your SQL database with high performing, flexible and typesafe SQL queries Seamlessly work with many different SQL database vendors without changing your code Effortlessly generate Java code based on the content of your database Write reactive SQL database access code with R2DBC Integrating jOOQ into popular frameworks and platforms like Hibernate, Spring boot and Quarkus tools like IDEs Testing jOOQ-based code with modern integration testing frameworks like TestContainers and Docker Learn how to safely handle data access code within frameworks like the Java Persistence API (JPA)

































































 Who This Book Is For





Intermediate Java programmers new to jOOQ. Some prior experience with SQL may be helpful but not required.
About the Author vii
About the Technical Reviewer ix
Chapter 1 Welcome to jOOQ
1(14)
Database Operations in Java: The Good Parts
2(2)
Database Operations in Java: The...Not So Good Parts
4(6)
You Have Got to Be jOOQing
9(1)
jOOQ Feature Tour
10(5)
Database Aware
11(1)
Code Generation
11(1)
Type Safety
12(1)
Domain-Specific Language
12(1)
Tooling Support
13(1)
JVM Languages
14(1)
Chapter 2 Getting Started with jOOQ
15(74)
Eden Auto Mart
19(1)
Setting Up jOOQ
20(4)
Install Dependencies for Commercial-Licensed jOOQ
22(2)
CRUD with jOOQ
24(49)
Your SQL Dialect and You
25(3)
Tools of CRUD in jOOQ
28(6)
Select Statements
34(29)
Insert Statements
63(3)
Update Statements
66(1)
Delete Statements
67(2)
Alternative Data Access Modes
69(4)
Transactions
73(5)
With Locking
76(2)
Configuration
78(11)
Connection Management
79(2)
Schema, Catalog, and Multi-tenant Deployment
81(3)
Query Management
84(2)
Query Lifecycle Integration
86(3)
Chapter 3 Working with jOOQ
89(56)
Generating Code
89(20)
Tools of jOOQ Code Generation
90(19)
Working with Generated Code
109(8)
CRUD with Generated Code
109(8)
Advanced Database Operations
117(28)
Joins
117(11)
Batch Operations
128(9)
Advanced Query Syntax
137(8)
Chapter 4 Integrating with jOOQ
145(28)
Java Persistence API with jOOQ
146(16)
Generate JPA Entities
147(4)
Generate from JPA Entities
151(2)
Generate SQL Queries
153(9)
Spring Boot and jOOQ
162(6)
Configure jOOQ in Spring Boot
163(5)
Quarkus and jOOQ
168(5)
Chapter 5 Packaging and Testing jOOQ
173(38)
Package Code with jOOQ
174(11)
When You Don't Need Code Generation
175(2)
When You Don't Have an Active Database Connection
177(1)
When Your Schema Needs to Incrementally Evolve
178(7)
Testing with jOOQ
185(26)
Tools of the (SQL) Testing Trade
187(4)
Unit Testing with jOOQ
191(7)
Integration Testing with Docker and TestContainers
198(13)
Index 211
Tayo Koleoso is the Founder and CEO of LettuceWork.io, the platform dedicated to engineering culture. He created the Better Managed Development method for building and sustaining an effective product engineering culture. He's a lifelong learner, engineer, and engineering leader committed to building people and software in a healthy, sustainable, and effective ecosystem. Outside of tech, comedy is the only thing he consumes in large quantity. King of the Hill, Peep Show and 30 Rock are his comfort telly, I tell you what.  He got his start in software engineering as a teenage database programmer with Oracle 8i. The jOOQ platform is therefore a natural fit and a return to his roots: his love affair with SQL.