(→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 -
#!/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