I have made a new plugin called Database Query which makes it possible to define and run database queries towards the SlimServer database. The idea is to be able to display or export information stored in the database.
After a query has been executed the result can be displayed in the following ways: * Directly in the web browser * Saved as a semicolon separated file (CSV) * Saved as a XML file By default the plugin provides a number of built in queries for: * Listing artists * Listing genres * Listing albums * Listing number of different kinds of objects in the SlimServer database * Check for some various inconsistency problems that can occur in the SlimServer database Queries can also be published and shared between users in the same way as several of my other plugins makes it possible to share information. I'm still not sure if this plugin is actually useful for anything, the reason I wrote it is just because I thought there would be a good idea to have some way where users can be instructed to run SQL statements to check things in their database when they have problems. Since it makes it possible to export information as XML there it might be possible to use for people that like to create simple reports of the information in the SlimServer database. Statistics and inconsistency reports for the Custom Scan and TrackStat information stored in the SlimServer database will be part of the next Custom Scan and TrackStat releases. They will then show up in the Database Query plugin user interface together with the other queries. NOTE! - It only works on slimserver 6.5.* - I've only tested it on Linux, but I'm pretty sure it should work on Windows too. - At the moment my intention is not to develop this plugin any more besides bug fixes and my own needs. So, if anyone finds it useful for something, please let me know and I will reconsider if I should enhance it with more features. You will find the plugin at my 'download page' (http://erland.homeip.net/download) as usual. The current wish/todo list for new features in comming Multi Library releases can be found here: http://erland.homeip.net/issuetracking/do/guest/home?application=slimserver-databasequery If anyone tests this plugin I would appreciate some feedback about how it works and wishes for new features and improvement of existing features. -- erland Erland Isaksson 'My homepage' (http://erland.homeip.net) 'My download page' (http://erland.homeip.net/download) (Developer of 'TrackStat, SQLPlayList, DynamicPlayList, Custom Browse, Custom Scan, Custom Skip, Multi Library and RandomPlayList plugins' (http://wiki.erland.homeip.net/index.php/Category:SlimServer)) ------------------------------------------------------------------------ erland's Profile: http://forums.slimdevices.com/member.php?userid=3124 View this thread: http://forums.slimdevices.com/showthread.php?t=37633 _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/plugins
