Implement a flexible cache system

[D-Brox]

Cache system should also be flexible for it's use in Pacstall's debug mode.

Database requirements

• Repo information including:
  • URL
  • Last update
  • List of packages
  • Preference order
• Pacscript information, including:
  • Name
  • Description
  • Homepage
  • Repology
  • Repository version (from last update)
  • Installed version
  • Auto/Manual
  • Dependencies (both apt's and pacstall's)
  • Optional dependencies (both apt's and pacstall's)
  • License (Requested here by @henryws)

Other requirements

• Source x Installed correlation
• Methods for safely adding and updating entries

[wizard-28]

Pacscript information

Will we have a separate table for source_pacscripts? And wil that table contain the same columns?

[D-Brox]

IIRC from what we talked, we were going to separate source_cache from installed_cache and link packages from both, so that we maintain package correlation

[wizard-28]

Okay.