1TRACKER3-SQL(1)                 Tracker manual                 TRACKER3-SQL(1)
2
3
4

NAME

6       tracker3-sql - Use SQL to query the Tracker databases.
7

SYNOPSIS

9       tracker3 sql -q <sql> | -f <file>
10

DESCRIPTION

12       This command allows probing of the current database. When using
13       commands like tracker3 sparql, the SPARQL used is translated into SQL
14       before being run on the database. This allows direct use of the
15       database using SQL avoiding the SPARQL engine entirely.
16
17       The caller can run a query two ways, either by providing a file with
18       the query or by providing a string with the sql query.
19
20       The file argument can be either a local path or a URI. It also does not
21       have to be an absolute path.
22

OPTIONS

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

EXAMPLES

35       Show first 10 "nfo:Document" entries where the TOC is not NULL
36
37               $ tracker3 sql -q 'SELECT * FROM "nfo:Document" WHERE "nfo:tableOfContents" NOT NULL LIMIT 10;'
38

SEE ALSO

40       tracker3-sparql(1), tracker3-info(1).
41
42       http://en.wikipedia.org/wiki/SQL
43
44
45
46  3.0.4                           04/03/2021                   TRACKER3-SQL(1)