{"repo":"nkonev/r2dbc-migrate","free":true,"listed":false,"github":"https://github.com/nkonev/r2dbc-migrate","clone":"git clone https://github.com/nkonev/r2dbc-migrate.git","description":"R2DBC database migration library","language":"Java","stars":104,"topics":["r2dbc","spring-boot","docker","migration","migrate","postgres","postgresql","sqlserver","sql-server","database-management"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"R2DBC migration library Inspired by this announcement. R2DBC page. Supported databases PostgreSQL Microsoft SQL Server H2 MariaDB MySQL It supports user-provided dialect. You can pass implementation of SqlQueries interface to the migrate() method. If you use Spring Boot, just define a bean of type SqlQueries . Example SimplePostgresqlDialect. Features No need the dedicated JDBC params, r2dbc-migrate reuses your R2DBC ConnectionFactory provided by Spring Boot Convention-based file names, for example V3 insert to customers split,nontransactional.sql Reasonable defaults. By convention, in case Spring Boot SQL files should be placed in classpath:/db/migration/ .sql . It is configurable through r2dbc.migrate.resources-paths . Pre-migration scripts, for example V0 create schemas premigration.sql . Those scripts are invoked every time before entire migration process(e. g. before migration tables created), so you need to make them idempotent. You can use zero or negative version number(s): V-1 create schemas nontransactional,premigration.sql . See example. It waits until a database has been started, then performs test query, and validates its result. This can be useful for the initial data loading into database with docker-compose Large SQL files support: migrations files larger than -Xmx : file will be split line-by-line ( split modifier), then it will be loaded by chunks into the database. Example. It supports lock, that make you able to start number of replicas your microservice, ","default_branch":null,"files":null,"tree":[],"storefront":"/r/nkonev","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/nkonev/r2dbc-migrate/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}