Support schema change on all branches?

[MrSEKIRO]

Is it possible to apply schema changes to all branches?

I'm considering using Dolt solely for data version control in my application. If a new feature requires schema modifications, can those changes be applied consistently across all branches?

[timsehn]

This is something we can certainly consider.

Right now, the way we recommend do this is using a schema branch and merges in the application. When you are using a non-schema branch in the application, inspect the dolt_schema_diff function between your current branch and the schema branch to see if there is a schema change in the schema branch. If so, do a merge.

Let us discuss an interface for making schema changes (and maybe all types of changes) to all heads.

[zachmu]

There are a few different ways we might implement this.

When you say "applied consistently", do you mean you expect all branches modified to update as one atomic unit? Or is it acceptable for each branch to get updated separately, in its own atomic commit?

[MrSEKIRO]

There are a few different ways we might implement this.

When you say "applied consistently", do you mean you expect all branches modified to update as one atomic unit? Or is it acceptable for each branch to get updated separately, in its own atomic commit?

One approach would be to disable schema version control through specific configurations. This would allow all branches to use the same schema, enabling atomic updates.

However, this approach wouldn't be suitable for normal cases where schema changes are tracked. In such scenarios, separate updates to each branch might be necessary for certain non-atomic operations.