R2DBC Revealed

Understand the newest trend in database programming for developers working in Java, Kotlin, Clojure, and other JVM-based languages. This book introduces Reactive Relational Database Connectivity (R2DBC), a modern way of connecting to and querying relational databases from Java and other JVM languages. The book begins by helping you understand not only what reactive programming is, but why it is necessary. Then building on those fundamentals, the book takes you into the world of databases and the newly released Reactive Relational Database Connectivity (R2DBC) specification.

Examples in the book are worked using the freely available MariaDB database along with MariaDB’s vendor-implementation of the R2DBC service-provider interface (SPI). Following along with the examples and the provided example code helps prepare you to work with any of the growing number of R2DBC implementations for popular enterprise databases such as Oracle Database and SQL Server. You’ll be well prepared for what is becoming the future of database access from Java and other languages built on the JVM.

WHAT YOU WILL LEARN

*
Understand why R2DBC was created and how it utilizes the Reactive Streams API *
Understand the components of the R2DBC service-provider interface*
Create and manage reactive database connections and connection pools using an R2DBC client*
Programmatically execute queries on a relational database using an R2DBC client*
Effectively utilize transactions using an R2DBC client*
Build relational database-driven applications that are event-driven and non-blocking


WHO THIS BOOK IS FOR

Software developers building solutions using JVM languages and the JVM ecosystem, and developers who need an introduction to the R2DBC specification and reactive programming with relational databases and want to understand what Reactive Relational Database Connectivity is and why it came about. This book includes practical examples of using the R2DBC specification with Java and MariaDB that will provide developers with the knowledge they need to create their own solutions.

ROB HEDGPETH is a professional software engineer and developer relations enthusiast residing in the bustling metropolis of Chicago, Illinois. Rob has more than 12 years of professional development experience, primarily in the application development space. Throughout the years he has contributed to the architecture and development of many apps, using a large array of languages and technologies. Now as a developer advocate and evangelist for MariaDB, Rob gets to combine his love for technology with his mission to fuel developers' curiosity and passion. Introduction

PART I. THE REACTIVE MOVEMENT AND R2DBC

1. The Case for Reactive Programming

2. Introduction to R2DBC

PART II. THE R2DBC SERVICE-PROVIDER INTERFACE

3. The Path to Implementation

4. Connections

5. Transactions

6. Statements

7. Handling Results

8. Result Metadata

9. Mapping Data Types

10. Handling Exceptions

PART III. GETTING STARTED WITH R2DBC AND MARIADB

11. Getting Stated with R2DBC

12. Managing Connections

13. Managing Data

14. Managing Transactions

15. Connection Pooling

16. Practical Applications with Spring Data and R2DBC