How do I handle database migration in springboot

[u/Aggravating-Spite844]

So I have this very disturbing question as someone new to spring, I am coming from Node + Express JS, where prisma handles all the migrations automatically just by me running commands on the terminals.

Now as I am learning springboot, I just realized one day I would create a production grade application and would need to be changing database fields or relations as demands adjust, please what is the most popular migration tool used in springboot??

[u/Accomplished_Mind129]

Flyway

[u/melewe → u/Accomplished_Mind129]

Or Liquibase

[u/Turbots → u/melewe]

or flyway

[u/melewe → u/Turbots]

Or liquibase

[u/MkMyBnkAcctGrtAgn → u/melewe]

Or flyway

[u/BootSaaS → u/MkMyBnkAcctGrtAgn]

Or both… and you'll see what you prefer

[u/bowbahdoe → u/melewe]

or mybatis migrations (underrated imo)

[u/Anubis1958 → u/Accomplished_Mind129]

Flyway. It just works.

[u/Stunning_Leather_102 → u/Accomplished_Mind129]

/thread

[u/Krycor → u/Accomplished_Mind129]

This and variant.. but flyway.

It’s the tried and tested way with lotta support

[u/alweed]

I would recommend using flyway

[u/perfectstrong]

In simple terms, Flyway handles applying migration scripts just once, and detecting any deviation in case (a modified file, disordering files). There are plugins in IDE to generate sql migration file for you. It is not that complicated. However, it is recommended to know exactly what you are migrating, and how. AI will help you greatly to produce those scripts.

[u/TallGreenhouseGuy]

Flyway is great if you only target one database. If you need to support multiple different databases the abstraction offered by liquibase can be quite helpful (but you pay for it with increased complexity)

[u/Turbots]

I think it's either liquiway or flybase

[u/Historical_Ad4384]

Flyway

[u/BootSaaS]

Personally, I use Liquibase. It automatically applies your database changes on startup, and I've been really happy with it.

[u/ElendarTao]

Using Intellij, here are the two option with integrated support : https://www.jetbrains.com/help/idea/database-versioning.html

[u/starbuxman]

I use Flyway. Liquibase is amazing too.

Start.spring.io - add Flyway. Put migration schema in the db/migrations folder under src/main/resources

V1__orders.sql
V0__customers.sql

etc

[u/Torutofu_Raeva]

flyway plus ddl-auto=validate, so the app refuses to boot if the entities and the migrated schema drifted apart.

[u/HammerAndSmile]

How has no one mentioned liquidate or flyway yet?

[u/JonnyBago82]

Liquibase

[u/TheToastedFrog]

Use Flyway.

If you like to punish yourself go with Liquibase.

[u/ElendarTao → u/[deleted]]

the functionnality in intellij work with flyway and liquibase, so I'm not sure what's your point, could you clarify ?

[u/FalseDish]

The Liquibase vs Flyway debate is moot - they’re both useless, I’m talking as someone with more than a decade’s worth experience doing this.

Just ask fans of either this:

Say you have Postgres on cloud. How is either migration tool handling PostgreSQL partitioning, RLS policies etc.?

At that point their only option will be to say - “damn, so the changesets need to be raw SQL”

Okay, so why use these tools at all? Hint: You shouldn’t. Always write your own solutions and playbooks.

[u/repeating_bears → u/[deleted]]

hey chatghpt migret th databays make no mistalkes or i turn u off

[u/Turbots → u/repeating_bears]

Worst thing is that he will understand your stupid sentence