GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  TRACKER-SQL (1)

NAME

tracker-sql - Use SQL to query the Tracker databases.

CONTENTS

Synopsis
Description
Options
Examples
See Also

SYNOPSIS

tracker sql -q <sql> | -f <file>

DESCRIPTION

This command allows probing of the current database. When using commands like tracker sparql, the SPARQL used is translated into SQL before being run on the database. This allows direct use of the database using SQL avoiding the SPARQL engine entirely.

The caller can run a query two ways, either by providing a file with the query or by providing a string with the sql query.

The file argument can be either a local path or a URI. It also does not have to be an absolute path.

OPTIONS

-f, --file=<file>
  Use a file with SPARQL content to query. Don’t forget to end all queries with a semicolon (;) and also to use quotes around table names. The quotes are important because most tables are named after ontology classes like "nfo:Document" and queries will fail without the quotes.
-q, --query=<sql>
  Use a sql string to query the database with.

EXAMPLES

Show first 10 "nfo:Document" entries where the TOC is not NULL:
 
$ tracker sql -q ’SELECT * FROM "nfo:Document" WHERE "nfo:tableOfContents" NOT NULL LIMIT 10;’

SEE ALSO

tracker-sparql(1), tracker-store(1), tracker-info(1).
http://en.wikipedia.org/wiki/SQL
 
Search for    or go to Top of page |  Section 1 |  Main Index


GNU TRACKER-SQL (1) October 2014

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.