Re: [Virtuoso-users] Examples of how to connect SQL from PHP (under apache)?
HI Matthew, I need to run my php app under apache for Shibboleth authentication. (If shibboleth can be done under virtuoso is something I need to ask later, as I need to just get some things done right now). Given enough incentive we may implement support for this at some point. We do already support SSO systems like OpenID, and WebID Is there an example anywhere on how to connect to a Virtuoso relational store? I presume to use generic ODBC and some port number, whatever it is? The port is listed in your virtuoso.ini file: [Parameters] ServerPort = You indeed can use ODBC to connect from your PHP application to Virtuoso. Please check out: http://docs.openlinksw.com/virtuoso/odbcimplementation.html http://www.openlinksw.com/dataspace/dav/wiki/Main/VirtuosoPHP It’s too bad there’s no PHP PDO (Portable Data Object) module for it.. because I generally prefer to use that. No biggy. There is of course pdo-odbc. Patrick
[Virtuoso-users] SPARQL Linked Data: howto configure sponger behind IRI deref for variables
Hey all,
I'm currently working on a project where I want to ask a lot "cross-border"
SPARQL-Queries like the following one:
SELECT DISTINCT ?p ?lp ?o ?lo
WHERE {
?p ?o.
OPTIONAL { ?p rdfs:label ?lp. }
OPTIONAL { ?o rdfs:label ?lo. }
}
(So I'd prefer a human readable version of potential URIs for ?p and ?o.)
Now virtuoso allows me to do so by using
DEFINE input:grab-all "yes"
DEFINE input:grab-depth 1
Nevertheless, as all drop-downs and tutorials say, the performance of this is
very bad (takes around 15 minutes, when I execute the query).
So my question is: is there any way to configure the sponger behind this to
1. cache its lookups, so don't retrieve graphs already present in the local
quad store (the DEFINE get:soft "soft" seems to be what I want, but that only
works for graphs mentioned in a FROM or FROM NAMED clause),
2. do n-fetches in parallel and/or,
3. tell me if some object turned out not to be a linked data resource, but
just an URL (e.g., in the triple: (dbpedia:Barack_Obama dbpprop:reference
) )
Perhaps someone could point me into the right direction / has some helpful
thoughts?
Cheers,
Jörn
[Virtuoso-users] Examples of how to connect SQL from PHP (under apache)?
I need to run my php app under apache for Shibboleth authentication. (If shibboleth can be done under virtuoso is something I need to ask later, as I need to just get some things done right now). Is there an example anywhere on how to connect to a Virtuoso relational store? I presume to use generic ODBC and some port number, whatever it is? It's too bad there's no PHP PDO (Portable Data Object) module for it.. because I generally prefer to use that. No biggy. Matthew C. Tedder Software Engineer Clinical and Translational Research Informatics Program (CTRIP) University of Florida 1329 SW 16th St. RM 5026 Gainesville, FL 32608 352.265.0111 Ext. 86107 (desk) 509-432-5520 (cell) UF Campus Mail: Box 100147/ICHP USPS Mail: PO Box 100177, Gainesville, FL 32610
