summaryrefslogtreecommitdiff
path: root/topics/systems
diff options
context:
space:
mode:
authorPjotr Prins2023-08-05 17:57:29 +0200
committerPjotr Prins2023-08-05 17:58:32 +0200
commit4418e7d0152a95f0164c254918648852841e1b3e (patch)
tree5bee5c1c072eea8cd1e9f96886176738a523e08d /topics/systems
parent12d889d6360daac147e24c0db48643456a95d16c (diff)
downloadgn-gemtext-4418e7d0152a95f0164c254918648852841e1b3e.tar.gz
GNSoC
Diffstat (limited to 'topics/systems')
-rw-r--r--topics/systems/virtuoso.gmi18
1 files changed, 14 insertions, 4 deletions
diff --git a/topics/systems/virtuoso.gmi b/topics/systems/virtuoso.gmi
index 2b2526c..c6a42cf 100644
--- a/topics/systems/virtuoso.gmi
+++ b/topics/systems/virtuoso.gmi
@@ -143,7 +143,13 @@ curl -v -X PUT --digest -u 'dba:password' -T data.ttl -G http://localhost:8892/s
```
where http://genenetwork.org is the name of the graph. Note that single quoting the password is good to do especially when you have special characters in the password.
-The PUT method deletes the existing data in the graph before loading the new one. So, there is no need to manually delete old data before loading new data. However, virtuoso is slow at deleting millions of triples, resulting in an apparent freeze-up. So, it is preferable to handle such deletes manually using a lower-level SQL statement issued via the isql client.
+The PUT method deletes the existing data in the graph before loading the new one. A POST method can be used instead. There is usually no need to manually delete old data before loading new data. virtuoso is slow at deleting millions of triples, resulting in an apparent freeze-up. So, it is preferable to handle such deletes manually using a lower-level SQL statement issued via the isql client.
+
+Start isql with something like
+
+```
+guix shell --expose=verified-data=/var/lib/data virtuoso-ose -- isql -U dba -P password 8981
+```
To delete a graph:
@@ -152,10 +158,12 @@ $ isql
SQL> DELETE FROM rdf_quad WHERE g = iri_to_id('http://genenetwork.org');
```
-To add ttl files:
+To add ttl files through isql:
```
-ld_dir('/dir', '*.ttl', 'http://genenetwork.org'); rdf_loader_run();
+ld_dir('/dir', '*.ttl', 'http://genenetwork.org');
+rdf_loader_run();
+checkpoint;
```
=> http://vos.openlinksw.com/owiki/wiki/VOS/VirtTipsAndTricksGuideDeleteLargeGraphs How can I delete graphs containing large numbers of triples from the Virtuoso Quad Store?
@@ -197,6 +205,8 @@ Also, make sure that the load list is empty before registering your turtle files
DELETE FROM DB.DBA.load_list;
```
+Note that the directory may be mapped to a different location by the service. On tux02 it is `/export/data/genenetwork-virtuoso/`.
+
Use isql to register all the turtle files:
```
@@ -215,7 +225,7 @@ Check the table DB.DBA.load_list to see the list of registered files that will b
SQL> SELECT * FROM DB.DBA.load_list;
```
-Perform the bulk load of all data by running:
+Complete the actual bulk load of all data by running:
```
SQL> rdf_loader_run();