Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
TINYSPARQL-SQL(1)	       TinySPARQL manual	     TINYSPARQL-SQL(1)

NAME
       tinysparql-sql -	Use SQL	to query the TinySPARQL	databases.

SYNOPSIS
       tinysparql sql -q <sql> | -f <file>

DESCRIPTION
       This command allows probing of the current database. When using
       commands	like tinysparql	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

	       $ tinysparql sql	-q 'SELECT * FROM "nfo:Document" WHERE "nfo:tableOfContents" NOT NULL LIMIT 10;'

SEE ALSO
       tinysparql-sparql(1), tinysparql-info(1).

       http://en.wikipedia.org/wiki/SQL

  3.8.2				  04/12/2025		     TINYSPARQL-SQL(1)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=tinysparql-sql&sektion=1&manpath=FreeBSD+Ports+14.3.quarterly>

home | help