On 2009/04/14 15:38, Sébastien Houzé <sebastien.ho...@gmail.com> wrote: > Ok, but I run many mpd processes, this implies running many mpdscribble > too... is a playlog_file option in mpd.conf better ? > Think about some analogy with Apache accesslog and errorlog. Logging can be > optionnal this way, and why not loggin format configurable (data, IP, song) > like in Apache.
Hmm, I'm not comfortable with that idea, because this is a very specific feature request which can be solved with a client. Might be more difficult for you because you're running multiple MPD instances, but you can use the same init script for starting one mpdscribble per MPD instance. Any other opinions on the mailing list? > I don't have benchmarked at the moment. Basically I was thinking that sqlite > had poor performance (big file lock) if many mpd processes were running > concurrent SELECT against it. It seems not, according to sqlite > website. sqlite is quite fast, in some use cases even faster than traditional database servers. Even if it's slower for us, I don't think it's too important. MPD isn't pushing a lot of pressure on the database. sqlite is great because it doesn't require any special setup, PostgreSQL or MySQL would be too much work for most MPD users. > I even found some interesting feature : > http://www.sqlite.org/sharedcache.html > What do you think of using sqlite3_enable_shared_cache() in mpd ? > This doesn't make multiple mpd processes perform better, but a single one > yes. No, not at all, because MPD doesn't open the sticker database more than once at a time. > > 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, > > > You think about storage plugins like, e.g. : flat file, sqlite, bdb, xml ? > If so, I think some dsn syntax sould be used in mpd.conf. > > For example > sticker_file "/somepath/somesqlitedb.db" > should be instead > sticker "sqlite:///somepath/somesqlitedb.db" More like: sticker { plugin "gda" uri "sqlite:///....." } Or: sticker { plugin "sqlite" file "/var/lib/mpd/stickers.sqlite" } > > we can extend that interface to > > store the whole MPD music database. > > > > You mean ID3 tag cache too ? Yes. 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
