NAME

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

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