Track Database Version for Compatibility with API Service

[Patowhiz]

Summary:
Climsoft will have different services (PWA, API, and Database), each with potentially different version numbers due to updates happening at different times. To prevent runtime issues caused by database updates, I propose tracking the database version.

Proposal:
Upon every restart, the API service will check the database version to ensure compatibility. If an incompatibility is detected, the API will determine whether it needs to perform steps to upgrade the database.

Benefits:

• Avoids runtime bugs caused by mismatched versions between services.
• Ensures seamless coordination between API and Database during updates.

Action Items:

• Implement version tracking for the database.
• Add a mechanism in the API service to check and compare database version on startup.
• Define the steps to upgrade the database if incompatibility is found.