[FEATURE] Internal change for the handling of external data

[EasyG0ing1]

Is your feature request related to a problem? Please describe.

No response

Describe the solution you'd like.

This is not so much a feature request as it is an idea for internally restructuring Drifty so that it no longer relies on text files for things like URL lists, download queues, or even settings (where leveraging the Java Preferences class has limitations).

Instead, I am proposing that Drifty might be a good candidate to leverage a SQLite database for the storage and retrieval of dynamic data. The database / SQL method of storing and retrieving information is well understood and is relatively easy to implement.

A core class called something like DB could be created which contains all of the methods required to interact with external data. The database could have various tables, for example, a Jobs table which contains all of the relevant data for a download job in each record, or even a Log table which can store the various logs that Drifty generates. A Settings table could be used to store things like download folders, video quality preferences, or settings for GUI themes in the future. We could even keep a table for download statistics that keeps track of download metrics such as transfer speeds for past downloads etc. which then provides metrics that might be interesting in different contexts.

This change to Drifty could be developed non-invasively at first where it would just be a class that maintains the database file where the methods are defined then once they are in place and tested and working, it would then be a matter of converting those places throughout the program where it keeps information in flat files, and convert those methods to use the DB methods.

The database methods could even be presented to other developers as sort of an interface to external data where future development might be streamlined by the presence of the DB class, but this will be highly dependent on the nature of any future development.

Screenshots

No response

Additional information

This would also remove the GSON dependency because the use of Json files would be removed from the program all together.

[github-actions]

Hello 👋! Thank you very much for raising an issue 🙌! The maintainers will get back to you soon for discussion over the issue! 🚀

Meanwhile you can also discuss about the project in our Discord Server 😀

[SaptarshiSarkar12]

Thank you for raising the issue @EasyG0ing1! It's a great improvement that can be implemented.
Would you like to work on this issue?

[SaptarshiSarkar12]

I am going to work on this issue. Self-assigning myself 😃

[Viereckig]

Hello @SaptarshiSarkar12. Are you still working on this or can i try it?

[SaptarshiSarkar12]

@Viereckig Thank you for your interest 😄.
Sorry, due to lack of time, I could not focus on this issue.
Hence, you can work on this issue. If you face any problem, you can post it here and we can discuss on this issue in our Discord Server 😃.