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

r2dbc-demo's People

Contributors

Stargazers

Watchers

r2dbc-demo's Issues

H2 Testing with Flyway

add H2 testing

In src/main/resources/application.properties

#spring.datasource.driver-class-name=org.h2.Driver
#spring.datasource.url=jdbc:h2:mem:public;MODE=MYSQL;DATABASE_TO_UPPER=false;INIT=CREATE SCHEMA IF NOT EXISTS public
#spring.datasource.username=sa
#spring.datasource.platform=h2
#spring.flyway.locations=classpath:db/migration/h2
#spring.r2dbc.url=r2dbc:h2:mem:///public?options=DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE

Posted via CodeStream

Recommend Projects