Note: For production, don't rely on hibernate.ddl-auto (or counterparts) to export schema DDL to the database. Simply remove (disable) hibernate.ddl-auto or set it to validate. Rely on Flyway or Liquibase.
Description: This application is an example of migrating a PostgreSQL database via Flyway for the default database postgres and schema public.
Key points:
- for Maven, in
pom.xml, add the Flyway dependency - remove (disable)
spring.jpa.hibernate.ddl-autoor set it tovalidate - in
application.properties, set the JDBC URL as follows:jdbc:postgresql://localhost:5432/postgres - each SQL file containing the schema update add it in
classpath:db/migration - each SQL file name it as
V1.1__Description.sql,V1.2__Description.sql, ...
| If you need a deep dive into the performance recipes exposed in this repository then I am sure that you will love my book "Spring Boot Persistence Best Practices" | If you need a hand of tips and illustrations of 100+ Java persistence performance issues then "Java Persistence Performance Illustrated Guide" is for you. |
|
|
|
