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 und
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
It's actually quite simular to the current mediad
Martijn Voncken wrote:
> Hi,
>
> See previous topic: "media database , smartplaylists,albumtree etc"
>
> The current schema I'm testing:
>
> create table media (mediaid integer primary key,medianame character);
> create table attr (attrid integer primary key,attrname character);
>
> create table f