<?sphp $this->text('pagetitle') ?>
 
Home of the Squeezebox™ & Transporter® network music players.

Database Query plugin

From SqueezeboxWiki

Revision as of 06:40, 23 June 2010 by Soulkeeper (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

Overview

This plugin makes it possible for end users to run different kind of queries towards the SqueezeCenter(formerly known as SlimServer) database. The purpose of these queries is either to check consistency or other things in the SqueezeCenter database or to export parts of the SqueezeCenter 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 SqueezeCenter database
  • Check for some various inconsistency problems that can occur in the SqueezeCenter database

Installation

  1. Remove any previous version of Database Query from the SqueezeCenter Plugins directory if you have manually installed it earlier (this is not needed if you have installed it through Extension Downloader)
  2. Goto SqueezeCenter Settings/Advanced/Extension Downloader and select to install Database Query. You might need to add Erland's repository to see it, see here for more information regarding this: SqueezeCenter_Repositories. If you don't want to install it through Extension Downloader, you can also download it from the download page and manually unzip the new version in the SqueezeCenter Plugins directory
  3. 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

If you are using SlimServer 6.5 or earlier, you may want to use the old guide instead.

Bugs and new features

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

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

http://erland.isaksson.info/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 of SqueezeCenter.
  • 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.