Details
-
Improvement
-
Resolution: Unresolved
-
Major
-
4.2
-
None
-
General
-
Confident
Description
The current handling of database structure update uses the 'schemaversions' table to handle a versioning of each table of the datamodel, coupled to a programmatic system that is expected to upgrade the database on startup.
That code clutters the business code, and should be replaced by SQL scripts. In many companies and administrations, database upgrades are only performed by databas eadministartors that bear responsibility for data integrity and tehrefore will never accept any sort of automatic upgrades handled by the code. This is the case at BnF.
On top of this, it seems quite an overkill to independently version every datamodel table, a global version would suffice, and should simply be the main release version number.
