I am planning to migrate from LocalStorage to SQLite for Thermal application.

Created a design of the database and relations with different tables. Need your feedback 🙏🏻 to improve the data flow and how the structure can be improved further.

Basic idea of this database design is to store the repository and it's relevant data inside the database.

SQLite database design

Don't know what Thermal is...

Thermal is free, open-source and cross-platform desktop application build using Electron & Vue.js, allowing you to manage your Git repositories at one place by providing a simple to use graphic interface with built-in features like commits, history, repository settings and more.

If you have any question or feedback, please drop them in the comment section below or share it on Thermal Discord Server.

Thanks

Yashu Mittal