In this short article I will try to introduce you to R2DBC using Spring Data R2DBC and in the world of reactive applications with Spring WebFlux.
What is R2DBC and why should you bother looking at it? First, R2DBC stands for Reactive Relational Database Connectivity. What does that mean? In simple words, R2DBC brings the possibility of non-blocking calls to our Relational Databases (SQL)!
Quoting https://r2dbc.io/, R2DBC is in a nutshell:
- Reactive Streams - R2DBC is founded on Reactive Streams providing a fully reactive non-blocking API.
- Relational Databases - R2DBC engages SQL databases with a reactive API, something not possible with the blocking nature of JDBC.
- Scalable Solutions - Reactive Streams makes it possible to move from the classic one thread per connection approach to a more powerful, more scalable approach.
- Open Specification - R2DBC is an open specification establishing a SPI that driver vendors can implement and clients can consume.
In this tutorial, we will build a simple REST API with Kotlin, Spring WebFlux and we will connect to our H2 Database using Spring Data R2DBC.
If you want to easily get started with a Springboot project I recommend always using the Spring Initializr.
The Second Best Place on the Internet @ Josh Long.
First of all, we have to configure our
build.gradle.kts and include the dependencies:
For the complete
build.gradle.kts check here:
Spring Boot comes with a handful of auto-configurations for Spring Data R2DBC out-of-the-box.
Below we are leveraging the power of Spring Boot to create a connection to the database:
Then we create a table called
Employee and we populate it with some data:
While that may not seem really safe, in our application we do not have any problems, while the database will always be created on startup and destroyed on shutdown of the application.
Ok, so we created our database and we populated it with data, now what? Let's make use of it and create a REST API!
Below we have a simple domain model called
Then, let's create our repository, which will provide some queries out-of-the-box and we will also define one of our own.
Last but not least, let's create our endpoint:
Let's execute our application with the command
The application now runs on http://localhost:8080!! Congratulations!
Spring Data R2DBC is still on experimental stage. Although it is on the official release of Spring Boot 2.2.0, I would not recommend using it on production :).
I hope you now have a better understanding of R2DBC.
You can find the repository right here:
Spring Boot R2DBC
This project aims to give an idea on how to work with the R2DBC and Spring Data R2DBC.
./gradlew bootRun, the application now runs localhost:8080.
Top comments (0)