View Single Post
Old 12-13-05, 10:47 PM   #9 (permalink)
betaboy
Aximsite Rookie
 
betaboy's Avatar
DAP Freshman
 
Join Date: Aug 2005
Posts: 73
Thanked 0 Times in 0 Posts
I'll let the users at Aximsite in on a secret... We are working on our new Database within The Core Pocket Media Player.

Without making it a 6 page white paper post... i'll break it down in very simple terms:

Our DB is called 'CoreTheque' it has a frontend and a backend DB.. the frontend DB is managed by TCPMP and asks to be updated when you start/close or insert TCPMP into your device (TCPMP now has an autorun feature that allows you to 'carry' not only TCPMP.. but your DB along with you. No matter what the device, PDA, Palm and soon Symbian... TRUE PORTABILITY!)

There is naturally more to the Db then that... but the bigger thing is that... we have created a unique scrollable management GUI..... it is unlike any other 'hardware' based media player and is the FIRST software media player to manage media like this.

And to that point and why I am posting here is that... it also includes 'RATINGS' integrated into the DB... and yes there is also the possibilty of syncing to iTUNEs for your 'personal' ratings ;-)

Heres a code peak....

Code:
static struct CT_TableList ct_table_list[] =
{
	{"CTContent",       "ContentID  INTEGER PRIMARY KEY AUTOINCREMENT"},
	{"CTSubContent",    "ContentID  INTEGER PRIMARY KEY, ParentID INTEGER, ContentOrder INTEGER(2)"}, /* a SubContent is a Content with a parent */
	{"CTContentSet",    "ContentID  INTEGER PRIMARY KEY, Level INTEGER(1), Year INTEGER(2), Rating INTEGER(1)"},
	{"CTName",          "ContentID  INTEGER PRIMARY KEY, Name TEXT"},
	{"CTLocation",      "ContentID  INTEGER PRIMARY KEY, Location TEXT UNIQUE"},
	{"CTArtists",       "ArtistID   INTEGER PRIMARY KEY AUTOINCREMENT, Artist TEXT UNIQUE"},
	{"CTContentArtist", "ContentID  INTEGER, ArtistID INTEGER"},
	{"CTFormats",       "FormatID   INTEGER PRIMARY KEY AUTOINCREMENT, Format TEXT UNIQUE"},
	{"CTContentFormat", "ContentID  INTEGER PRIMARY KEY, FormatID INTEGER"},
	{"CTGenres",        "GenreID    INTEGER PRIMARY KEY AUTOINCREMENT, Genre TEXT UNIQUE"},
	{"CTContentGenre",  "ContentID  INTEGER, GenreID INTEGER"},
	{"CTVersion",       "ContentID  INTEGER PRIMARY KEY, Version TEXT UNIQUE"},
	{"CTComment",       "ContentID  INTEGER PRIMARY KEY, Comment TEXT UNIQUE"},
};

/*! strings to define elements of the DB */
#define CT_STRING_CONTENT      "Content"
#define CT_STRING_ARTIST       "Artist"
#define CT_STRING_ALBUM        "Album"
#define CT_STRING_GENRE        "Genre"
#define CT_STRING_YEAR         "Year"
#define CT_STRING_URL          "Location"
#define CT_STRING_DISPLAYNAME  "Name"
#define CT_STRING_VERSIONNAME  "Version"
#define CT_STRING_COMMENT      "Comment"
#define CT_STRING_RATING       "Rating"

static int ct_table_found(void* cookie,int num,char** key, char**value)
{
betaboy is offline   Reply With Quote