Restructuring of DB and diverse improvements

[Learwin]

Just wanted to share a few ideas I have floating in my head. I'm not sure if I'll get around to implementing them in this project or if I'll try to create a new project heavily inspired by this one if the changes are too severe and need too many deep changes.

• One of my ideas is to have multiple tables in the sqlite db instead of storing everything in a single record table. This would allow for more type specific storage of values (For example specifying a range in which a lora could work).
• I thought about making poses work. Download and extract, preview nad managing.
• I would also like to put Tags into their own table.
• I want to toy with redesigning the ui. Not sure exactly how but having more type specific information definitely needs to be added. The cards are really nice and I'm currently contemplating on how to add more functionality to the cards without bloating and just having tons of small buttons on it.
• The download functionality could also deserve some love as I'd like some more fine grained control.
• Ability for different previews in cards view or as extra screen. Rotating through a list of images for example.

[Learwin]

Ok so I'm working on this and was wondering. How many actually use Firebase ? Cause otherwise I would drop support for now and if someone wants it they can submit a PR. Same goes for the Table display style. Does anyone use the Table view ?

For now I'm gonna remove support for these two to simplify my task.

As for the big Database restructuring. I worked a structure out I am happy with that supports extension for the future, but it's definitely not finalized.

I'll update this for a rough overview of what I have done so far and what I expect I still need to do

• [x] New DB structure
• [ ] New methods for SQL calls and new structure
• [ ] Reworking all UI Screens to handle new structure and data
  • [x] Civitai Import Screen
  • [ ] Edit Screen
  • [ ] Detail Screen
  • [ ] Cards
  • [ ] CSS changes
• [ ] Extend functionality to use new data
• [ ] Rework Download functionality for easier downloading (#21 and #73)
• [ ] Further implement multi image preview functionality (#94)
  • [x] Ability to assing multiple images to any given resource
  • [ ] UI changes to view these images
• [ ] Batch processing of civitai links with common values shared between them (#99)

Priority at the moment is as follows: My changes > Multi Image preview > Batch Processing > Download improvements