Reply To: Firefly 1.0?

#8938
fizze
Participant

Moinmoin!

@belu wrote:

Just a question in passing: Is it possible to get a list of the files actually stored in the database?
BeLu

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 😀