IntermediateAdvanced PostgreSQL

Database Migrations in Spring Boot #21

The query

SQL

-- Q: Best practices for managing PostgreSQL schema changes? (Flyway V21)
-- V21__Add_new_table.sql
CREATE TABLE new_feature (
  id UUID PRIMARY KEY,
  created_at TIMESTAMP
);

Tested against PostgreSQL 16

Note

“Never use spring.jpa.hibernate.ddl-auto = update in production! Always use Flyway or Liquibase.