Help - Search - Members - Calendar
Full Version: SQL-ish Playlist Commands
Hydrogenaudio Forums > Hosted Forums > foobar2000 > 3rd Party Plugins - (fb2k)
SuperPhly
Instead of having a static list of playlists only, we should have a second type of playlist that allows you to "query" the database of music to display. So you can do something like:

CODE
select *.mp3 from dbase where artist = led zeppelin and bitrate < 128


This would effectively let you make playlists with certain genre's and artists. Allowing some realllllly cool possibilities. We're smart enough to do this sorta stuff arnt we?

Unfortunately I'm not a coder... sad.gif
kode54
You'd also have to code a SQL front-end for the database, as it's not SQL-based.
Paranoia
Doesn't Extended Playlist Generator effectively do this?

Steve
anza
As Paranoia said, foo_playlistgen_ext is just the thing you want.

CODE
(%__codec% IS MP3) AND (%artist% IS Led Zeppelin) AND (%__bitrate% GREATER 128)

Is the string you want to achieve your example.
SuperPhly
Ahh, so this will update when I make the playlist active? I want to be able to have this playlist always current with as much "led zeppelin, mp3, 128+" if you get my drift. Not just a playlist generator.
Paranoia
You need to re-generate it, automatic updating isn't availible at this time.

Steve

[EDIT]

This is simpler than I made it sound. Preset can be made, so re-entering the code isn't necessary.

[/EDIT]
anza
And it really isn't that hard to manually recreating the playlists. Just set up a keyboard shortcut for "Generate Playlist" (mine's ctrl+g) and you're 4 keypresses away from updating the playlist. Ctrl+g -> ctrl+a -> enter and all my playlists are up to date again.
rexy
QUOTE(SuperPhly @ Jul 16 2004, 08:04 PM)
CODE
select *.mp3 from dbase where artist = led zeppelin and bitrate < 128



That SQL query isn't gonna even work unless you, for some weird reason, have a column for every format that's labled as a star, a period, and the extension (which is stupid and useless). The only thing SQL queries for the databases can help wth that you can't do with the playlist generator is simply statistics and whatnot which isn't really needed. SQL queries do sound like a fun toy for foobar, but when it comes down to it, you don't really need it.
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.