R2DBC Demo

Databases

• H2
• PostgreSQL
• Microsoft SQL Server
• MySQL: https://github.com/mirromutth/r2dbc-mysql
• MariaDB R2DBC connector: Non-blocking MariaDB and MySQL client: https://github.com/mariadb-corporation/mariadb-connector-r2dbc

Features

• flyway to init database
• database-rider to manage dataset
• r2dbc for reactive
• BLOB/CLOB API: r2dbc/r2dbc-spi#41

R2DBC Connection URLs

R2DBC Connection URL support: r2dbc/r2dbc-spi#48

r2dbc:mysql://localhost:3306/my_database?locale=en_US
\___/ \___/\_______________/\__________/\___________/
  |     |             |          |           |
scheme  sub-scheme  authority   path       query

References

• R2DBC Home: http://r2dbc.io/
• R2DBC Specification: http://r2dbc.io/spec/1.0.0.M7/spec/html/
• Spring Data R2DBC - Reference Documentation: https://docs.spring.io/spring-data/r2dbc/docs/1.3.0/reference/html/
• Spring Data R2DBC 1.3.0 API: https://docs.spring.io/spring-data/r2dbc/docs/1.3.0/api/
• Asynchronous RDBMS access with Spring Data R2DBC: https://lankydanblog.com/2019/02/16/asynchronous-rdbms-access-with-spring-data-r2dbc/
• R2DBC MySQL: https://github.com/mirromutth/r2dbc-mysql
• Experimental Spring Boot support for R2DBC: https://github.com/spring-projects-experimental/spring-boot-r2dbc
• Accessing data with R2DBC: https://spring.io/guides/gs/accessing-data-r2dbc/
• What is JDBC? https://www.marcobehler.com/guides/jdbc