Beginning jOOQ : learn to write efficient and effective Java-based SQL database operations

Beginning jOOQ learn to write efficient and effective Java-based SQL database operations

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 vers...

Full description

Bibliographic Details
Other Authors: Koleoso, Tayo, author (author)
Format: eBook
Language:Inglés
Published: New York, New York : Apress [2022]
Subjects:
Microsoft Azure SQL Database.
Object-oriented databases.
Querying (Computer science)
Java (Computer program language)
See on Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009635712506719
Table of Contents:
  • Intro
  • Table of Contents
  • About the Author
  • About the Technical Reviewer
  • Chapter 1: Welcome to jOOQ
  • Database Operations in Java: The Good Parts
  • Database Operations in Java: The…Not So Good Parts
  • You Have Got to Be jOOQing
  • jOOQ Feature Tour
  • Database Aware
  • Code Generation
  • Type Safety
  • Domain-Specific Language
  • Tooling Support
  • JVM Languages
  • Chapter 2: Getting Started with jOOQ
  • Eden Auto Mart
  • Setting Up jOOQ
  • Install Dependencies for Commercial-Licensed jOOQ
  • CRUD with jOOQ
  • Your SQL Dialect and You
  • Tools of CRUD in jOOQ
  • Select Statements
  • The SELECT DSL
  • With the WHERE DSL
  • Conditions
  • Subqueries
  • Conditional Logic in Queries
  • With the… WITH Clause
  • With the GROUP BY DSL
  • With the HAVING DSL
  • With the ORDER BY DSL
  • ORDER BY CASE
  • ORDER BY NULL
  • Paginate Query Results
  • Insert Statements
  • With Multiple Rows
  • With Sequences
  • With Select
  • Update Statements
  • Delete Statements
  • Tuple Syntax
  • Alternative Data Access Modes
  • Streaming Access
  • Lazy Access
  • Transactions
  • With Locking
  • Configuration
  • Connection Management
  • Schema, Catalog, and Multi-tenant Deployment
  • Query Management
  • Query Lifecycle Integration
  • Chapter 3: Working with jOOQ
  • Generating Code
  • Tools of jOOQ Code Generation
  • Configure jOOQ for Code Generation
  • Generate Code with Maven
  • Generate Code from the Command Line
  • Generate Code Programmatically
  • Results of Code Generation
  • Tables
  • Global Artifacts
  • Add Custom Code to Generated Code
  • Working with Generated Code
  • CRUD with Generated Code
  • Enhancements from UpdatableRecord
  • Formatting
  • Optimistic Locking
  • Advanced Database Operations
  • Joins
  • Non-SQL Grouping
  • Batch Operations
  • Explicit Batching
  • Batch Import
  • Advanced Query Syntax
  • Merge and Upsert
  • Window Functions.
  • Chapter 4: Integrating with jOOQ
  • Java Persistence API with jOOQ
  • Generate JPA Entities
  • Generate from JPA Entities
  • Generate SQL Queries
  • Spring Boot and jOOQ
  • Configure jOOQ in Spring Boot
  • With Custom SQL
  • jOOQ Spring Boot Starter
  • Quarkus and jOOQ
  • Chapter 5: Packaging and Testing jOOQ
  • Package Code with jOOQ
  • When You Don't Need Code Generation
  • When You Don't Have an Active Database Connection
  • When Your Schema Needs to Incrementally Evolve
  • Recipe for a Self-Sufficient Database Project
  • Testing with jOOQ
  • Tools of the (SQL) Testing Trade
  • Unit Testing with jOOQ
  • Using Mockito
  • With SQL Parsing
  • Integration Testing with Docker and TestContainers
  • With Spring Boot
  • Index.

Similar Items