{"repo":"lacanoid/pgsparql","free":true,"listed":false,"github":"https://github.com/lacanoid/pgsparql","clone":"git clone https://github.com/lacanoid/pgsparql.git","description":"SPARQL utilities for PostgreSQL","language":"Shell","stars":22,"topics":["database","postgresql","postgresql-extension","rdf","semantic-web","sparql","sql"],"license":null,"category":"databases-storage","readme_excerpt":"SPARQL utilities for PostgreSQL =============================== This is an extension for PostgreSQL. It helps one query SPARQL datasources. SPARQL queries are compiled into Postgres views, so you can use them nicely in SQL. It is currently used with Virtuoso, so it is useful with sources like dbpedia. It might or might not work with other RDF backends. Installation ------------ Install needed Perl packages apt install libwww-perl libtry-tiny-perl libdatetime-perl To build and install this module: make make install make clean install installcheck or selecting a specific PostgreSQL installation: make PG CONFIG=/some/where/bin/pg config make PG CONFIG=/some/where/bin/pg config install make PG CONFIG=/some/where/bin/pg config installcheck make PGPORT=5432 PG CONFIG=/usr/lib/postgresql/10/bin/pg config clean install installcheck Make sure you set the connection parameters like PGPORT right for testing. And finally inside the database: CREATE EXTENSION sparql; Using ----- Get data on a particular dbpedia resource: To compile a SPARQL query into SQL function + view: SPARQL endpoint is queried to determine the result format for the specified query. Then function identitier() and view identifier are created. Created function queries any SPARQL endpoint and returns result as SQL table. Created view is just a convenience layer over the created function. Once created, these can be further tweaked manualy for extra functionality. Parameters: + endpoint - default SPARQL endpoint. + identif","default_branch":null,"files":null,"tree":[],"storefront":"/r/lacanoid","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/lacanoid/pgsparql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}