siblount / PMForDAZ

A product manager for DAZ Studio that accepts common archive structures.
Other
11 stars 2 forks source link

Database needs redesign #23

Open siblount opened 1 year ago

siblount commented 1 year ago

As of right now, a lot of information is unused or unnecessary which can be removed to help save space (and most likely performance as well).

For example, SKU is unused and is irrelevant as it can simply be considered a tag. Errored files and errored messages are unused but was planned to be used later, but now may be removed. Author can probably be removed as well. Content Folders aren't needed, since it can be calculated through the files.

ID can probably be omitted since I discovered ROWID.

Furthermore, after fixing #18, it came to my realization that the files shown were only based on the paths of the archive; not the path extracted to. Files should only show files that were extracted and the paths shown should be the path it was extracted to.

siblount commented 9 months ago

Errored messages and Errored files have been implemented but I will be removing them. It's only needed for immediate/short use not long-term use.