Just a question in passing: Is it possible to get a list of the files actually stored in the database?
Sure is. It wont look charming, but sqlite does the job.
select path || fname from songs;
in sqlite should do the trick. Im not perfectly sure wether fname already includes the path. in that case, just omit the “path ||”.
“||” is the concatenation operator in *SQL, for those who are DB-inclined 😀