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

Inside the betting 'holiday' known as the sports equinox

Article URL: https://www.espn.com/espn/betting/story/_/id/46733635/sports-betting-2025-sports-equinox-nfl-nba-mlb-nhl Comments URL: https://news.ycombinator.com/item?id=45727914 Points: 1 # Comments: 0 Source: www.espn.com

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.