From XiphWiki
Jump to navigation Jump to search


I've put a few things that I've been thinking about on this wiki page.
If you would like to comment, please make a note.


Here is a simple structure with explanations.

Database: On a server or sqlite, doesnt matter.

data- table; houses file data.
path- path of file on the file system.
genre- genre example: Rock
artist- artist example: Misfits
title- title example: Hybrid Moments
album- album example: Static Age
playlists- table; definition on databases, scheduling, defined in web-app.
name- playlist name.
description- description of playlist
position- position in playlist, so that play is not started over from beginning. Incremented when track begins.
day- scheduling, a string of days to play??? numbers 1-7.
time- scheduling, a dictionary of times to play based with day (1-7) as key.
current- designates the currently running playlist, value is 1 or 0.
playlist- table, name of table is playlist? maybe incorporated in playlists table?