(→sparql_to_sql_text) |
(→Connecting directly to virtuoso) |
||
| Line 1: | Line 1: | ||
= Connecting directly to virtuoso = | = Connecting directly to virtuoso = | ||
| − | + | Virtuoso ships with an executable called <code>isql-vt</code>. Just running that executable should connect you to virtuoso. | |
| + | |||
| + | If you distribution does not provide the corresponding executable or if it doesn't work for you. Try this script - | ||
| + | <syntaxhighlight lang="bash"> | ||
| + | #!/bin/bash | ||
| + | filename=`ps aux | grep virtuoso-t | grep -v grep | sed -e 's/.*\/tmp\///;s/ini.*/ini/'` | ||
| + | port=$(grep ServerPort /tmp/$filename | sed -e 's/.*=//') | ||
| + | exec isql-vt -S $port | ||
| + | </syntaxhighlight> | ||
= List of tables = | = List of tables = | ||
Virtuoso ships with an executable called isql-vt. Just running that executable should connect you to virtuoso.
If you distribution does not provide the corresponding executable or if it doesn't work for you. Try this script -
KDE TechBase #!/bin/bash
filename=`ps aux | grep virtuoso-t | grep -v grep | sed -e 's/.*\/tmp\///;s/ini.*/ini/'`
port=$(grep ServerPort /tmp/$filename | sed -e 's/.*=//')
exec isql-vt -S $port
is a relational database and what not
All the tables in Virtuoso start with the DB.DBA. prefix.
The sparql_to_sql_text() function can be used to convert a SPARQL query directly to the SQL it would be executed as.
varchar sparql_to_sql_text
( in squery varchar );
It's very useful in debugging why many sparql queries are taking so long.
http://docs.openlinksw.com/virtuoso/fn_sparql_to_sql_text.html
