Thank you very much. This will take a lot of time to populate :)
I wonder if VFP 9 can play an MP3 file? And if the sound quality the same as if you were to play it with Windows natively.
>pk, year, fk_song, fk_type, fk_sourcetype
>1..N pk, Song
>1..N type
>1..N sourcetype[CD, movietrack,DL...,]
>
>plus additional relations to filter
>0..N pk, groups (most 0..1],
>0..N pk, sourcetitel [most 1, perhaps several "group" sourcetitels to get rid of 0)
>0..N pk, artists (if there is an Orchestra without named artists)
>
>keep table structure as loosely as possible to allow things like
>
>
- an Orchestra without named artists,
> - single artists
> - groups with special guest artist not on every titel of CD
> - groups with changing members
> - live performances by 2 or more groups
>
>
>even if you plan on having dedicated disk, I am uncertain if ordering into folders is best: it is simple adds only minimal "brittle", but inserting PK into file name allows you reordering later / finding specific title somewhere if copied or moved. Also easier for unordered/differently structured sources coming later like downloads, files etc to integrate.
>
>Done this way you can filter much better, for instance artists appearing in multiple groups.
>Also possible to fill in artists names later, as 0..N gives you freedom
>
> You also could include metadata from sound file to be read out automatically for faster/easier selections
>
>>Hi,
>>
>>I am beginning of a project of ripping all my CDs into MP3 files (I talked about it here some time ago but never did anything).
>>I want to store the MP3 files in such fashion that I can find a song or an artist "easier". The folder structure will be as follows::
>>Artist/group - Name of the CD/Album
>>Artist/group - Name of the CD/Album
>>
>>Then, say I want to see all songs of a specific Artist/group. I would just start typing the name (e.g. Spyro for Spyro Gyra) and all songs of this artist/group would be shown.
>>The front end (the UI) will be done in VFP 9 (I don't know other computer languages better).
>>What type of structure would you recommend for the Main DBF file? The DBF that would store the Folder Names with Artist/Group, or maybe even the song (if I have the patience :))
>>
>>TIA
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham