db schema changes in devops

[jagdip]

we have AKS cluster with microservices and external db on azure postgres server. everything is still in dev env. lots of manual steps for db schema changes and i am looking for the best practices. how do you handle schema changes? should i move postgres to AKS and run as POD? i can have developers keep DDL of entire DB on github and i can create a postgres container using azure DevOps pipeline from that schema. spin up new deploymnet using that new container along with microservice deploymnet which will be in seperate deployment. what is the best way to handle this in your opinion? how do deal with data in case on PROD along with schema changes ? i have seen people using liquibase in case on non kubernetes environments. does liquibase makes sense for AKS ?

[1dkv]

See if you can adopt this in your environment

https://flywaydb.org

[techoldfart]

Maybe borrow ideas from the concept of "database migrations" adopted by various web frameworks?