tracker-sql - Online Linux Manual PageSection : 1
Updated : October 2014
Source : GNU
Note : User Commands

---

NAMEtracker-sql − Use SQL to query the Tracker databases.

---

SYNOPSIStracker sql −q <sql> | −f <file>

---

DESCRIPTIONThis 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.

---

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

---

SEE ALSOtracker-sparql(1), tracker-store(1), tracker-info(1). http://en.wikipedia.org/wiki/SQL 0

---

Johanes Gumabo

---

Data Size   :   5,927 byte
man-tracker-sql.1Build   :   2024-12-05, 20:55   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   2 / 238,352
Visitor ID   :     :  
Visitor IP   :   18.117.184.125   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   1000   :  
Provider City   :   Columbus   :  
Provider Province   :   Ohio ,   :   ,
Provider Country   :   United States   :  
Provider Continent   :   North America   :  
Visitor Recorder   :   Version   :  
Visitor Recorder   :   Library   :  
Online Linux Manual Page   :   Version   :   Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 24.12.05
Online Linux Manual Page   :   Library   :   lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page   :   Library   :   lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base   :   Version   :   Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base   :   Library   :   lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36

---

Very long time ago, I have the best tutor, Wenzel Svojanovsky . If someone knows the email address of Wenzel Svojanovsky , please send an email to johanes_gumabo@yahoo.co.id .

---

If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.

---

ERROR : Need New Coding :         (rof_BR|3|tracker-sql.1|38|1|.BR )         (rof_TP|38|tracker-sql.1|48|EOF|.BR http://en.wikipedia.org/wiki/SQL )    

---