SqueezeCenter SQLPlayList

This plugin for slimserver makes it possible to create smart playlists based on SQL queries.
Combined with the TrackStat plugin this makes it possible to create playlists such as:
- Top rated songs
- Not rated songs
- Songs not played in last month

It requires that the DynamicPlayList plugin is installed

See my Wiki for information about SQL Playlist and my other plugins.

See here for more information about the slimserver and SqueezeBox.

Click here if you want to support future development by purchasing a license for this software

Note that full functionality is only available after purchasing a license

To browse the source code, click here

The current wish list for new features and open bugs in SQLPlayList can be found here

Install through Extension Downloader

2.6.272		2017-07-20		SQLPlayList-2.6.272.zip
2.5.3859		2013-03-02		SQLPlayList-2.5.3859.zip
2.5.3762		2011-12-21		SQLPlayList-2.5.3762.zip
2.5.3741		2011-12-06		SQLPlayList-2.5.3741.zip
2.5.3667		2011-11-06		SQLPlayList-2.5.3667.zip
2.5.3648		2011-11-01		SQLPlayList-2.5.3648.zip
2.5.3577		2011-10-25		SQLPlayList-2.5.3577.zip
2.5.3555		2011-10-07		SQLPlayList-2.5.3555.zip
2.5.3487		2011-09-24		SQLPlayList-2.5.3487.zip
2.5.3465		2011-09-21		SQLPlayList-2.5.3465.zip    Beta version with License Manager support, requires License Manager plugin to work Corrected problem with decade related playlist types in 7.6
2.5.3452		2011-09-17		SQLPlayList-2.5.3452.zip    Beta version with License Manager support, requires License Manager plugin to work
2.5.3359		2011-07-07		SQLPlayList-2.5.3359.zip
2.5.3224		2010-07-10		SQLPlayList-2.5.3224.zip
2.5		2009-09-29		SQLPlayList-2.5.zip
2.5pre3		2009-08-02		SQLPlayList-2.5pre3.zip
2.5pre2		2009-07-18		SQLPlayList-2.5pre2.zip    *** THIS IS A BETA VERSION *** Corrected some playlist templates with random sorting
2.5pre1		2009-07-13		SQLPlayList-2.5pre1.zip    *** THIS IS A BETA VERSION *** Added support for SQLite version of Squeezebox Server 7.4
2.4		2009-01-27		SQLPlayList-2.4.zip    Added support for SqueezeCenter 7.4 Added support for requesting parameters from random albums playlist templates Added predefined playlists for playing a random album in a genre, decade, artist, playlist or year Corrected some small bugs
2.3.1		2008-12-31		SQLPlayList-2.3.1.zip    Corrected problem with browse menus in classic player interface Corrected so track repeating option works in Random from selection playlist template
2.3		2008-12-31		SQLPlayList-2.3.zip    Added support for SQL Playlist mixer to create SQL Playlists based on selections in browse menus
2.2		2008-11-18		SQLPlayList-2.2.zip    Added "Only never played songs" parameter to advanced playlist types Added support for requesting decade as parameter in Random songs playlist type Added "Random playlist songs" template Added "Top rated for decade" playlist template Added support for launching custom selectable parameters through mixers (Decade menu from Custom Browse is an example) Added "Request from user" support to advanced playlist templates Added support for including only unrated tracks in advanced with rating template Improved handling of synchronized players (only avoid repeating tracks played on the same player) Corrected some small bugs Added official support for 7.3
2.1		2008-07-03		SQLPlayList-2.1.zip    Corrected "Test" button so it works. Added support for user selectable parameters in all random playlist templates. Added built-in playlists for random playlist mixers through Dynamic Playlist plugin.
2.0.beta04		2008-04-15		SQLPlayList-2.0.beta04.zip    Partly untested beta version for SqueezeCenter/SlimServer 7.0. Will NOT work on SlimServer 6.5 and earlier. Added support for download/publish functionality. Added support for SqueezeCenter 7.1.
2.0.beta03		2007-11-12		SQLPlayList-2.0.beta03.zip    Partly untested beta version for SqueezeCenter/SlimServer 7.0. Will NOT work on SlimServer 6.5 and earlier. Corrected problem with & characters Added settings validation
2.0.beta02		2007-10-07		SQLPlayList-2.0.beta02.zip    Partly untested beta version for SqueezeCenter/SlimServer 7.0. Will NOT work on SlimServer 6.5 and earlier. Corrected loading of playlists from other plugins Corrected bug in playlist caching Corrected collision with Custom Browse plugin in web interface
2.0.beta01		2007-10-05		SQLPlayList-2.0.beta01.zip    Partly untested beta version for SqueezeCenter/SlimServer 7.0. Will NOT work on SlimServer 6.5 and earlier.
1.21		2007-09-23		SQLPlayList-1.21.zip    Corrected som small problem Added option to topratedfor* playlist templates to select in what order the tracks should be played Added support for caching playlist templates to avoid the need to download latest playlists after installation of a new release Added danish translation (Thanks to Kim Molgaard) Updated so empty listboxes aren't shown in the configuration interface Improved performance of configuration interface for templates with large listboxes Added support for playlists that takes a track as user selectable parameter (Requires Dynamic Playlist 1.14 or later)
1.14		2007-09-23		SQLPlayList-1.14.zip    DynamicPlayList-1.14.zip    Added basic support for creating your own playlist templates, you can configure the template directory in the settings page. This version has only been tested against slimserver 6.5, it will probably not work with slimserver 6.2 or 6.3.
1.20.2		2007-08-12		SQLPlayList-1.20.2.zip    Corrected problem with quotation and backslash characters in values
1.20.1		2007-08-05		SQLPlayList-1.20.1.zip    Corrected so default values are displayed correctly in configuration dialogs Corrected some different problems with non ascii characters Corrected so line feeds aren't duplicated when saving a customized playlist on Windows. Corrected so a playlist can be played directly after creation without a browser warning message
1.20		2007-07-09		SQLPlayList-1.20.zip    Corrected a problem with non ascii characters Added option to "Ignore songs played recently" to all relevant playlist templates Corrected problem where more tracks than neccesary sometimes where added to current playlist
1.19.1		2007-05-20		SQLPlayList-1.19.1.zip    Corrected so large configurations can be saved, caused a browser error in previous releases.
1.19		2007-05-19		SQLPlayList-1.19.zip    Corrected som small problems Added support for publish/download over web proxy
1.18.1		2007-05-14		SQLPlayList-1.18.1.zip    Corrected some errors related to non ascii characters
1.18		2007-05-13		SQLPlayList-1.18.zip    Huge internal changes of administration interface, may contain bugs. Note that the CLI interface has been changed so the id is based on the file name instead of playlist name.
1.17		2007-02-03		SQLPlayList-1.17.zip    Added support for using numerical buttons when navigating in playlists that requests parameters Added support for 'PlaylistActiveLibrary' keyword which will be replaced with active library in Multi Library plugin Added support for limit playlists to active or a selected library in Multi Library plugin Added support for playlist actions that are executed at start/stop of a playlist Added support for connecting a Custom Skip filter to all playlist templates Note! This verison requires Dynamic Playlist 1.12 or later Note! If you are using Custom Skip, you will need version 1.3 or later for the Custom Skip filter parameter to work
1.16		2007-01-11		SQLPlayList-1.16.zip    Added support to start SQL with ( making it possible to use unions Added compatibility check when downloading playlists This version has only been tested against slimserver 6.5, it will probably not work with slimserver 6.2 or 6.3.
1.15		2006-12-20		SQLPlayList-1.15.zip    Added support for downloading playlists from other users Added support for publishing playlists for other users to use This version has only been tested against slimserver 6.5, it will probably not work with slimserver 6.2 or 6.3.
1.13		2006-11-23		SQLPlayList-1.13.zip    Added possibility to implement playlist templates in separate plugins (Used by TrackStat 1.32) Added new playlist options - ContentType: Makes it possible to create playlists that instead of tracks returns albums, artists, genres, playlists or years - NoOfTracks: When ContentType is used, this makes it possible to limit number of tracks per album/artist/genre/playlist/year - DontRepeatTracks: When ContentType is used, this makes it possible to make sure already played tracks in playlist isn't played again This version has only been tested against slimserver 6.5, it will probably not work with slimserver 6.2 or 6.3.
1.12		2006-11-13		SQLPlayList-1.12.zip    Totally redesign of playlist creating web interface: - Playlist settings can be changed after the playlist has been created without editing the SQL manually. - The user no longer need to see the SQL if he only uses predefined playlist types. Some random playlists included by default Support for playlist option "Unlimited" making it possible to make playlists that returns more tracks than specifed by DynamicPlayList settings, for example returning all tracks on an album. Support for builtin playlist parameters PlaylistLimit and PlaylistOffset Added support for creating playlists based on custom tags scanned with Custom Scan plugin. This version has only been tested against slimserver 6.5, it will probably not work with slimserver 6.2 or 6.3.
1.11		2006-10-10		SQLPlayList-1.11.zip    Added support for creating playlists based on COMMENT tags Corrected some small problems This version has only been tested against slimserver 6.5, it still might work with slimserver 6.2 and 6.3 but this has not been tested.
1.10.1		2006-09-25		SQLPlayList-1.10.1.zip    Corrected so it works with latest 6.5
1.10		2006-06-22		SQLPlayList-1.10.zip    Adding support for specifying parameters that should be requested from the user (Requires DynamicPlayList 1.5 or later) Removed SqueezeBox interface (The DynamicPlayList menu should be used instead) Added support for launching playlists when browsing on SqueezeBox by holding play down for a while
1.9		2006-06-17		SQLPlayList-1.9.zip    Added support for groups in DynamicPlayList plugin
1.8.1		2006-06-14		SQLPlayList-1.8.1.zip    Corrected crash with Test button when TrackStat wasn't installed
1.8		2006-06-09		SQLPlayList-1.8.zip    Added new options when creating new playlists for: - Min year - Max year - Min track length - Max track length - Do not repeat tracks within playlist
1.7		2006-06-06		SQLPlayList-1.7.zip    Added support for url links in DynamicPlayList plugin This version requires DynamicPlayList 1.3 or later (all playlist logic has been moved from SQLPlayList to DynamicPlayList plugin)
1.6.3		2006-06-04		SQLPlayList-1.6.3.zip    Updated so it works with slimserver 6.5 nightly after 23/5 (when split scanner was introduced)
1.6.2		2006-05-11		SQLPlayList-1.6.2.zip    Corrected layout problem in slimserver 6.5 fishbone skin Corrected SQL templates which didn't work (incorrect SQL syntax)
1.6.1		2006-04-03		SQLPlayList-1.6.1.zip    Corrected problem which made it crash immediately when start playing playlist
1.6		2006-04-02		SQLPlayList-1.6.zip    Updated with exclude templates for SQLite Updated with templates for excluding/including artists Added test button to make it possible to verify the SQL in a playlist
1.5		2006-03-05		SQLPlayList-1.5.zip    Added support for the DynamicPlayList plugin
1.4		2006-03-04		SQLPlayList-1.4.zip    Added simple wizard in web interface for generating different playlists. Added web interface for editing, adding, deleting playlists.
1.3.1		2006-02-11		SQLPlayList-1.3.1.zip    Corrected so it works with ' in the name of playlists
1.3		2006-02-11		SQLPlayList-1.3.zip    Added simple web interface for changing playlists. Corrected so slimserver does not crash if an incorrect SQL query is used. Made it possible to have line breaks in SQL queries. Added information in README about SQLite difference. Added possibility to stop adding tracks to playlist.
1.2		2006-02-05		SQLPlayList-1.2.zip    Updated so it supports both slimserver 6.2 and 6.5. Changed so it is possible to restart a playlist.
1.1		2006-01-29		SQLPlayList-1.1.zip    Added documentation, no code changes
1.0		2006-01-28		SQLPlayList-1.0.zip    First official version