On 2009/04/14 06:05, Sébastien Houzé <sebastien.ho...@gmail.com> wrote: > I have some time to spare on mpd in coming weeks and have opened my > first mantis issue with a little patch : > > http://musicpd.org/mantis/view.php?id=2255
I don't think the log file should be used for anything but error analysis. We simply cannot give any guarantees on the text format. If you want to have statistics, run a client like mpdscribble. We could add statistics support to mpdscribble. > NOW, ABOUT STICKERS > > Stickers is an interesting feature, but when you have many mpd instances > sharing the same db sqlite doesn't fits well (too much concurrency). Please provide benchmark results to back that thesis. Right now, I cannot imagine this is even measurable. > So I have searched for an elegant solution to be free to choose any database > system as a sticker storage backend. > I've found very few libraries in C with database abstraction capabilities, > except libgda : > > http://www.gnome-db.org/CodeExampleGdaSelect > > With libgda stickers can be stored in MySQL, sqlite or PgSQL to name a few. > This implies, mainly : How much faster will MPD be when using MySQL or PostgreSQL? > - Renaming in mpd.conf sticker_file into sticker_dsn (values can be e.g. > *sqlite:///somepath/somefile.db* or *mysql://user:p...@host:port/db*) > - Updating configure.ac : --enable-sqlite becomes --enable-sticker (or > --enable-gda ?) > - Refactoring sticker.c,h files to use libgda > > Please tell me what do you think about it. We could make the sticker storage pluggable, so you can write a libgda backend. I'm quite happy with native sqlite support right now, and I had initially considered using BerkeleyDB instead of sqlite. When sticker storage is pluggable, we can extend that interface to store the whole MPD music database. Max ------------------------------------------------------------------------------ This SF.net email is sponsored by: High Quality Requirements in a Collaborative Environment. Download a free trial of Rational Requirements Composer Now! http://p.sf.net/sfu/www-ibm-com _______________________________________________ Musicpd-dev-team mailing list Musicpd-dev-team@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/musicpd-dev-team