(sorry if it gets delivered twice , i added the tar file as a link now) Hi,
download tar at : http://mvoncken.sohosted.com/freevo/memdb_src.tar It's a 1st working version , it works good enough to explore the features. but nothing more, needs some more attention before i submit a real patch. There have been some discutions about the media db. I could't wait anymore and made a "database" myself. It's a list of dicts (16Mb for 10000 mp3 files) Aimed at complex query's (no optimalisation (yet) for searching on filename/dirname) a default freevo db should be optimized for file/directory query's Memdb: util/memdb.py helpers/cache_memdb.py why a list of dicts instead of a sql database? -a list of dicts has no schema/predefined fields. -querying of a list of dicts is easyer/more-dynamic/ than sql-query's. (eval/exec) (see smartplaylist code) -changing sql-schema's is hard!, i use lots of exotic mp3 tags: (replaygain*4,album_artist,date_add,last_played,first_played etc..) every user/media will have different needs. Future: maybe replace the list of dicts with a list of objects, (easyer scripting,no more gettag) Smart playlists: audio/plugins/spl_lib.py audio/plugins/memdb_smartplaylist.py Limitations:ignorant of datatypes: every tag is a string Features: *smart playlists like in iTunes *search on any tag. *merge smart-playlists/file-playlists (any/all==and/or) *gui (q&d) available Tagtree: Limitations:ignorant of datatypes: every tag is a string audio/plugins/tagtree_lib.py audio/plugins/memdb_tagtree.py A better version of albumtree ( http://freevo.sourceforge.net/cgi-bin/doc/PluginAudioAlbumTree) better configurable/speedier/less code Config : memdb_config.txt -- tack,dichi I want to start/reopen a database design dicsussion. ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel
