tracker3-sql - Use SQL to query the Tracker databases.
Contents
Description
This command allows probing of the current database. When using commands like tracker3sparql, 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.
Examples
Show first 10 "nfo:Document" entries where the TOC is not NULL
$ tracker3 sql -q 'SELECT * FROM "nfo:Document" WHERE "nfo:tableOfContents" NOT NULL LIMIT 10;'
Name
tracker3-sql - Use SQL to query the Tracker databases.
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.
See Also
tracker3-sparql(1), tracker3-info(1). http://en.wikipedia.org/wiki/SQL 3.3.0 03/21/2022 TRACKER3-SQL(1)
Synopsis
tracker3 sql -q <sql> | -f <file>
