Rockbox mail archive

• Next message: Michael Graham: "Re: Database extended: statistical info"
• Previous message: devtrick at yahoo.de: "Re: archo jukebox recorder 20gb mic"
• Next in thread: Michael Graham: "Re: Database extended: statistical info"
• Reply: Michael Graham: "Re: Database extended: statistical info"
• Reply: Noah Smith: "Re: Database extended: statistical info"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

I'd like to throw another topic into the database discussion. I'd really
favor if we could design a database that allows to store statistical
usage info about the song like
- how often it was played
- how often it was skipped
(- maybe a song rating)

That could enable us to generate playlists eg of the least often played
songs on the fly. A real plus.

While it may be easy to provide space for that info it introduces a
couple of nasty problems:

- we will need to _write_ that data on the jukebox (no readonly db any
more)
- we will have to reindex the database - at least concerning these
dynamic infos.

Regarding these problems it might be worth to consider wether we want to
split the data base structure data and index files.

Phil

_______________________________________________
http://cool.haxx.se/mailman/listinfo/rockbox

• Next message: Michael Graham: "Re: Database extended: statistical info"
• Previous message: devtrick at yahoo.de: "Re: archo jukebox recorder 20gb mic"
• Next in thread: Michael Graham: "Re: Database extended: statistical info"
• Reply: Michael Graham: "Re: Database extended: statistical info"
• Reply: Noah Smith: "Re: Database extended: statistical info"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]