Generate database on each startup ?
Over time, generating databases has become faster and faster due to many optimizations.
However, it has always been a confusing process for many users.
Having the database be generated on every app startup would be a good idea, however we need to :
- See if it takes a whole long time on different computers.
- Maybe implement some kind of progress bar so users can see the generation's progression
- Rework the integrity check process Right now, after you generate a new database, KM runs through your userdata tables, like viewcounts, requested songs, playlists, blacklist, whitelist, etc and makes sure every karaoke is correctly linked with the ones in the database you just created. However, this also means it deletes items which are not in your database anymore. Let's say you made a mistake and your database ends up empty for whatever reason, it means your userdata gets emptied as well. We need to rework that to amke sure karaokes which don't exist anymore are simply left there and marked as invalid somehow and won't be SELECTed anymore, but will stay inside the tables