I use MPD. It's really lightweight, have a simple and straightforward concept of playlists and I can use the standard *nix tools to mutate and create playlists.

http://mpd.wikia.com