[AutoGen Studio] Add database versioning to manage schema compatibility

microsoft / autogen

A programming framework for agentic AI 🤖

https://microsoft.github.io/autogen/

Creative Commons Attribution 4.0 International

30.77k stars 4.48k forks source link

Open gagb opened 7 months ago

gagb commented 7 months ago

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

victordibia commented 7 months ago

@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)