Martijn Voncken wrote: > Dischi wrote: > >>So you have one table for a file and one for the attributes? Isn't >>that slow? How do you get a list of all files in a dir? > > select fileid from file where url="file:\\mnt\data\my-mp3-dir" > X=fileid > select * from file where dirid = X
OK, that I understand. And were is the attribute 'foo' from my foo
plugin stored? This is the attr table, right?
> It's actually quite simular to the current mediadb.
> All attributes needed for immediate display are stored in the file table.
> Only fields/attributes that all files and directory's share are stored
> in the file table.
> (perhaps "cover"/"extra_cover" should be added)
So the height of a file is not needed and in an extra table. While
Freevo can already display the directory, the attributes like width
and height can be loaded in the background because they are only
needed for the current item selected right now. Sounds like a good way
to go.
Dischi
--
I am a friend of the working man, and I would rather be his friend
than be one.
-- Clarence Darrow
pgpMyr35C6qhd.pgp
Description: PGP signature
