Skip to content

[AutoGen Studio] Add database versioning to manage schema compatibility #1342

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

Closed
gagb opened this issue Jan 19, 2024 · 3 comments
Closed

[AutoGen Studio] Add database versioning to manage schema compatibility #1342

gagb opened this issue Jan 19, 2024 · 3 comments
Labels
0.2 Issues which are related to the pre 0.4 codebase help wanted Extra attention is needed proj-studio

Comments

@gagb
Copy link
Collaborator

gagb commented Jan 19, 2024

And yes, we will need some good versioning scheme to deal with database schema compatibility issues like this.
Added to the roadmap #737

Originally posted by @victordibia in #1340 (comment)

@victordibia victordibia changed the title Add versioning scheme to deal with database schema compatibility [AutoGen Studio]Add database versioning to manage schema compatibility Jan 20, 2024
@victordibia victordibia changed the title [AutoGen Studio]Add database versioning to manage schema compatibility [AutoGen Studio] Add database versioning to manage schema compatibility Jan 20, 2024
@victordibia victordibia added the help wanted Extra attention is needed label Jan 20, 2024
@victordibia
Copy link
Collaborator

@monuminu , following up on our conversation, it would be great to get some help in improving the local db for autogen at the moment.
Some thoughts.

  • Keep track of database version in a db table
  • Keep track of db version in version.py. This gets incremented each time there is a schema update
  • On db init or db load, check if the current db version matches some db version.py. If not, run throw a meaningful error message (or run a migration script)

@rysweet rysweet added 0.2 Issues which are related to the pre 0.4 codebase needs-triage labels Oct 2, 2024
@rysweet
Copy link
Collaborator

rysweet commented Oct 18, 2024

@victordibia is this still an issue?

@victordibia
Copy link
Collaborator

victordibia commented Oct 18, 2024

AutoGen Studio has a db versioning scheme based on sqlmodel.
Some additional work needs to be done for automatic migration across db versions.

But will close this for now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0.2 Issues which are related to the pre 0.4 codebase help wanted Extra attention is needed proj-studio
Projects
None yet
Development

No branches or pull requests

3 participants