mpg123-mysql 0.7 review

mpg123-mysql consists of some patches to mpg123 which make it support MySQL

License: BSD License File size: 10K Developer: Dominik Brettnacher

0

mpg123-mysql consists of some patches to mpg123 which make it support MySQL. This adds some bells and whistles, including rating support and playlist support.

In addition to that, mpg123-mysql offers the following facilities:

mpg123-mysql uses setproctitle(3) to show ps(1) which title it is playing at the moment. You can use this feature with the included "np" script. Unfortunately, this works on FreeBSD only at the moment.
by sending a SIGTSTP signal to mpg123-mysql, it stops playing and closes the audio device so that another process can open it temporarily. You can try this out with "killall -TSTP mpg123", for example.

Here are some key features of "mpg123mysql":
rating support:
When a file is played completely, it gets some (e.g. 2) points. When playing is interrupted by sending the usual "INT" signal to mpg123, the song gets less points. After a while, you can build your own "Top 10" or sort out those files you don't want
to have any longer. Additionally, mpg123-mysql is able to skip titles with a bad (negative) rating

playlist support:
You can tell mpg123 to use your database as the source for your playlist. This also works in shuffle (-z) mode.

Requirements:
in order to run mpg123-mysql, you must have
the sourcecode of mpg123, version 0.59r you can get it at http://www.mpg123.de
MySQL headers and libraries (libmysqlclient.so, mysql.h, etc.) (tested: MySQL 3.22.21)
GNU patch
some UNIX skills and lots of patience
for more Information see mpg123