[pgAdmin4][Patch]: Ensure any changes to the config database arebackward compatible - Mailing list pgadmin-hackers

From Surinder Kumar
Subject [pgAdmin4][Patch]: Ensure any changes to the config database arebackward compatible
Date
Msg-id CAM5-9D-kWS14uaYNc28qzu+XHesHsQXZiBjOb2pCRo23UpgiQw@mail.gmail.com
Whole thread Raw
Responses Re: [pgAdmin4][Patch]: Ensure any changes to the config database arebackward compatible  (Surinder Kumar <surinder.kumar@enterprisedb.com>)
List pgadmin-hackers
​Hi,​

We will use config variable `SCHEMA_VERSION` to keep track of SQLite database changes. Whenever there is any change is performed in the database, the count of schema version will be incremented by 1 and the same will be updated in SQLite table `version`.

So, these changes make sure the database migration is not performed on the older version of pgAdmin4 and this way the same database will work irrespective of pgAdmin4 version.

Also, this will only work for future pgAdmin4 versions.

Please find attached patch and review.

Thanks,
Surinder
Attachment

pgadmin-hackers by date:

Previous
From: Murtuza Zabuawala
Date:
Subject: Re: [pgAdmin4][Patch]: Allow user to provide custom SSL certificatesand provide .pgpass file
Next
From: Surinder Kumar
Date:
Subject: Re: [pgAdmin4][Patch]: Ensure any changes to the config database arebackward compatible