IntermediateAdvanced PostgreSQL

Database Migrations in Spring Boot #34

The query

SQL

-- Q: Best practices for managing PostgreSQL schema changes? (Flyway V34)
-- V34__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.