Database Query plugin

Overview

This plugin makes it possible for end users to run different kind of queries towards the SlimServer database. The purpose of these queries is either to check consistency or other things in the SlimServer database or to export parts of the SlimServer database to some external report tool.

The Database Query plugin provides a number of predefined queries, but you can also write your own using SQL statements.

The result of a query 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

Installation

1. Download from http://erland.homeip.net/download
2. Remove any previous version of Database Query from the Slimserver Plugins directory
3. Unzip the new version in the Slimserver Plugins directory
4. Optionally install other plugins that extends Database Query with more functionality
   • TrackStat plugin which provides "TrackStat statistics" and "TrackStat Inconsistency/Problems" queries
   • Custom Scan plugin which provides "Custom Scan statistics" and "Custom Scan Inconsistency/Problems" queries

Bugs and new features

The current list of known bugs and wishes for new features can be found here:

• http://code.google.com/p/erlandplugins/issues/list?q=label%3APlugin-DatabaseQuery&can=2

If you want to encourage future development of this plugin you should also consider making a donation

http://erland.homeip.net/donate

Downloading and sharing query definitions

Database Query plugin provides a way to download and share query definitions with other users, this is used in a number of different ways:

• The latest version of the builtin query types are always available for download, this means that instead of waiting for a new official release of Database Query you can download a new query directly after it has been corrected by the developer.
• A user can choose to publish/share a query he has made himself, after publishing this query will be available for download for all other users

When publishing/sharing a query you have the following options

• You can choose to register, the advantage with this is that other users will see that you are the author for the query so you will get some credit for it. It is also a way to make sure that no one else can modify your shared query. You register by selecting on of the "Publish" links and then selecting "Register & Login" in the Database Query web interface in your SlimServer.
• You can choose to publish a query anonymously, this way you don't need to provide any information about yourself but it also means that other persons can update and modify the shared query

The recommendation is that you register when publishing queries but its still better that you publish a query anonymously than not publish it at all.