Collections in the XMMS2 music player [LWN.net]

Collections in the XMMS2 music player

Posted Jun 19, 2007 7:38 UTC (Tue) by scevey (guest, #45734)
In reply to: Collections in the XMMS2 music player by KaiRo
Parent article: Collections in the XMMS2 music player

Mh, fuzzy search could be implemented as a new collection operator, but I am not sure the current DBMS we're using (SQLite) would be appropriate and effective for such operations. Our favourite smartest bearded lead developer is investigating a new storage backend, so maybe performance will allow that in the future.

(Log in to post comments)

Collections in the XMMS2 music player

Posted Jun 21, 2007 16:51 UTC (Thu) by leandro (guest, #1460) [Link]

I am not sure the current DBMS we're using (SQLite) would be appropriate

That is the problem with DBMS-agnostic applications: the lowest common denominator. I think what Apple did, in using full-featured but yet light enough PostgreSQL everywhere, just makes more sense.

Collections in the XMMS2 music player

Posted Jun 28, 2007 14:58 UTC (Thu) by tru (guest, #30161) [Link]

Didn't apple go with sqlite too? or are we talking about leopard?

Collections in the XMMS2 music player

Posted Jul 27, 2012 21:41 UTC (Fri) by leandro (guest, #1460) [Link]

Sorry for ðe late reply. I juſt (finally) figure actually Apple uſes SQLite for its ISO compatibility, inherited from PoſtgreSQL (ƿhich is ðe reference for SQLite’s language), in ðe deſktop, and PoſtgreSQL in ðe ſerver.

Not ðat it matters much, noƿ ðat Apple effectively gave up on ſervers.

Collections in the XMMS2 music player

Posted Jul 6, 2007 17:26 UTC (Fri) by KaiRo (subscriber, #1987) [Link]

Would be cool if that would be possible, it's a feature I really miss a lot in all other such apps.

Yammi has/had used XML as the storage backend, probably loading the whole "database" into memory, which obviously might sound a bit heavy on memory but is very fast (and I never saw memory problems with it).

The fuzzy search code it used is at http://yammi.cvs.sourceforge.net/yammi/kyammi/src/fuzzsrc... and is under the GPLv2 (but I guess Oliver might be open to relicensing if you need a different license).