Help - Search - Members - Calendar
Full Version: Statement Driven Playlists
Hydrogenaudio Forums > Hosted Forums > foobar2000 > 3rd Party Plugins - (fb2k)
SuperPhly
OK, I tried posting this before but it got shot down. I'm an avid believer that this could be a good thing for playlist generation. So here goes:

Playlists are not static, but dynamic lists that are generated each time they are viewed (as well as a 30 minute timer or something) by the use of a statement that is SIMILAR to this:

SELECT * FROM DB_NAME WHERE TYPE=MP3 and BITRATE<=128 and ARTIST="bjork"

I don't care if my sql statement makes any sense or not so read between the lines and get my idea. I had 70% of the replies to my previous post correcting my SQL statement.

So, you could generate playlists that were statements instead of lists of files. Plus you can have 100 play lists, and never have to update them by hand. I'm sure you guys have other ways to do what I'm talking about, but this seems the best way for myself to do it.

If you need more info let me know. OUT.
Aero
QUOTE(SuperPhly @ Sep 15 2004, 04:20 PM)
Playlists are not static, but dynamic lists that are generated each time they are viewed (as well as a 30 minute timer or something) by the use of a statement that is SIMILAR to this:

SELECT * FROM DB_NAME WHERE TYPE=MP3 and BITRATE<=128 and ARTIST="bjork"

I don't care if my sql statement makes any sense or not so read between the lines and get my idea. I had 70% of the replies to my previous post correcting my SQL statement.

So, you could generate playlists that were statements instead of lists of files. Plus you can have 100 play lists, and never have to update them by hand. I'm sure you guys have other ways to do what I'm talking about, but this seems the best way for myself to do it.

This is very similar to how smart playlists are generated on the iPod. Otto42 has written a bunch of code (for the iPodDB library) that emulates the very complex rules that are interpreted on the iPod in order to generate a playlist. With minor modifications, it could be the base for your Foobar component...
jsheridan
QUOTE(SuperPhly @ Sep 15 2004, 02:20 PM)
OK, I tried posting this before but it got shot down. I'm an avid believer that this could be a good thing for playlist generation. So here goes:

Playlists are not static, but dynamic lists that are generated each time they are viewed (as well as a 30 minute timer or something) by the use of a statement that is SIMILAR to this:

SELECT * FROM DB_NAME WHERE TYPE=MP3 and BITRATE<=128 and ARTIST="bjork"

I don't care if my sql statement makes any sense or not so read between the lines and get my idea. I had 70% of the replies to my previous post correcting my SQL statement.

So, you could generate playlists that were statements instead of lists of files. Plus you can have 100 play lists, and never have to update them by hand. I'm sure you guys have other ways to do what I'm talking about, but this seems the best way for myself to do it.

If you need more info let me know. OUT.
*




If it can simulate the auto-playlist idea from Windows Media Player 10, it will be a great plugin imho
Phi
QUOTE(SuperPhly @ Sep 16 2004, 08:20 AM)
OK, I tried posting this before but it got shot down. I'm an avid believer that this could be a good thing for playlist generation.
<snip>
I don't care if my sql statement makes any sense or not so read between the lines and get my idea. I had 70% of the replies to my previous post correcting my SQL statement.
*


The real reason your idea got shot down in your previous post is because this isn't really a new idea. The playlist generation aspect of your idea is implemented in the extended playlist generator component. The thing you can't do currently is automatically update these generated playlists whenever you view them.

This feature could be added to the extended playlist generator component, but it probably wouldn't work too well with foobar0.8 and the default user interface (there would be a delay before bringing the auto-generated playlst into focus). foo_playlistgen_ex in combination with the Columns UI might work better. In any case, you might have more luck posting in the foo_playlistgen_ex thread to request this feature.
Go2Null
Check out the Extended Playlist Generator thread.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.