gwk / pithy

Python 3.7+ utility library.
Other
5 stars 1 forks source link

SQLite Schema versioning and migration #5

Open gwk opened 1 year ago

gwk commented 1 year ago

Schema objects should gain a v parameter that is incremented by the developer. This will correspond to the sql user_version pragma, which is essentially a global integer variable.

There should be a standard table created called sql_version_history that holds the complete sql create statement for each table, for every version that the table changed.