06-04-2014, 04:56 AM
Thanks for the reply, zuberman. I eventually fixed things up by working with the database. Exported the database. Sq lite odbc to access. Renamed unknown to undefined in all albums, and the associated table. Created queries to inset missing album songs (speaking from memory, so might have the wrong table) and remove redundant ones - I saw instances of both.
to be constructively critical, the design of the schema could be changed to remove redundant information, I.e. to remove files or tables that can be derived from others unless there is a performance reason not to do so. This would reduce the risk of inconsistencies. We can chat if you're interested.
Regardless, this is a great program. Keep up the good work!
Sent from my SM-T900 using Tapatalk
to be constructively critical, the design of the schema could be changed to remove redundant information, I.e. to remove files or tables that can be derived from others unless there is a performance reason not to do so. This would reduce the risk of inconsistencies. We can chat if you're interested.
Regardless, this is a great program. Keep up the good work!
Sent from my SM-T900 using Tapatalk