Thank you for your contribution !
AFAIK, SQLite is relational DBMS which may not be so scalable. The new way of writing the query e.g. using the Sequelize is in fact very much alike the NoSQL such as MongoDB - which is scalable by its nature.
Maybe you can extract all the database logics into a separate module/class which provides the interface for querying database whether it is sqlite or sequelize - in other words, implementation - dependent.
You could also use async/await to replace your Promise syntax. The DB logging can be also handled separatedly.
How do you ensure the upgrade is safe? I would expect the unit tests that give you some confidences.
Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post, click here.
Need help? Chat with us on Discord.
RE: Stratos Communities Database Upgrade - Utopian.io