Declarative database schema migrations – yay or nay?

Share This Post

Two issues I observed with typical migration as a separate new SQL file approach:

* Views don’t have alter, so have to be fully redefined. Any change to a view obscures actually changed parts of a view, since you have to fully redefine it.

* Duplicate change tracking with git and migration history. Can’t we just use git for history?

E.g. https://atlasgo.io/. Totally non affiliated with them. Just had a shower idea, but saw it already being implemented (yay).


Comments URL: https://news.ycombinator.com/item?id=45719578

Points: 1

# Comments: 0

Source: news.ycombinator.com

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore

Windows Securitym Hackers Feeds

Recent Rust Changes

Article URL: https://www.ncameron.org/blog/recent-rust-changes/ Comments URL: https://news.ycombinator.com/item?id=45726358 Points: 1 # Comments: 0 Source: www.ncameron.org

Do You Want To Boost Your Business?

drop us a line and keep in touch

We are here to help

One of our technicians will be with you shortly.