Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tables global to all branches Excluded from Change Tracking #7740

Open
MrSEKIRO opened this issue Apr 15, 2024 · 1 comment
Open

Tables global to all branches Excluded from Change Tracking #7740

MrSEKIRO opened this issue Apr 15, 2024 · 1 comment

Comments

@MrSEKIRO
Copy link

Is there a way to exclude some tables from versioning so when adding data into those tables, they should be same on all branches?

There is some dolt_ignore system table, but it just could ignore that table on one branch. What is needed is some kind of .gitignore like in git which will apply on all branches.

@timsehn
Copy link
Sponsor Contributor

timsehn commented Apr 15, 2024

When building dolt_ignore we discussed this.

Basically, you want a dolt_global or maybe dolt_domain set of tables. A set of tables that is not versioned but global to all branches.

A way to work around this now would be to put the tables in a separate database. You could then join across databases and keep those un-versioned.

Another way to work around this is reference the unversioned tables on say the main branch by referring to them by their branch spec. ie select * from <db>.<branch>.<t>.

Yet another way to work around it is to copy the tables when you create a branch but this will cost storage and if the tables change, the change will not be reflected in the copied tables.

@timsehn timsehn added enhancement New feature or request version control labels Apr 15, 2024
@timsehn timsehn changed the title Exclude Tables from Change Tracking Tables global to all branches Excluded from Change Tracking Apr 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants