Quote Originally Posted by Triode View Post
2) The current code support incremental scanning - this is definately a user
requirement, but it leads to complexity to get a consitent database and has
been the cause of a number of bugs - we ended up resolving an inconsitent
contributor_album tables by recreating it after each scan for instance.
I seem to recall, way back when, suggesting the contributor_album table. In hindsight it wasn't a very good idea, as the relationships can (or should be) derivable from contributor_track and the tracks to albums relationships. Trying to keep data consistent when there are such redundancies in the database can be a handful. The Years table is another example.