5 ms·
I know that several RDF data stores use PostgreSQL as a backend data store. With new features like better XML support, as well as older features for storing hie
by mark_l_watson 10y ago
I know that several RDF data stores use PostgreSQL as a backend data store. With new features like better XML support, as well as older features for storing hierarchical data, I am wishing for a plugin or extension for handling RDF with limited (not RDFS or OWL) SPARQL query support. I almost always have PostgreSQL available, and for RDF applications it would be very nice to not have to run a separate service.
I tend to view PostgreSQL as a "Swiss Army knife" and having native RDF support would reinforce that.
- anarazel 10y agoAs one of the people regularly working on postgres, I'm honestly a bit doubtful that it's realistic to add SPARQL frontend. Doing that well is a considerable amount of work, and there's relatively little overlap in experience between the communities. I suspect that focusing on other areas will have a bigger ROI. But that's just my personal opinion, and other contributors and companies might very well disagree.
- oever 10y agoCan you say which RDF data stores these are? Are they generic or special purpose?
- frik 10y agoWhich RDF data store uses Postgres as DB backend? And can one import WikiData? (does it scale) (I would rather avoid these old school RDF special case stores from SematicWeb days 10 years ago.)
- kuschku 10y agohttps://github.com/cayleygraph/cayley https://github.com/cayleygraph/cayley is currently on the frontpage of HN, and it does use PGSQL as backend.
- jerven 10y agoDoes it scale is a very valid question for Cayley. Running sparql.uniprot.org I know virtuoso scales easily to 27 billion triples. Best benchmark I have seen for Cayley is 21 million RDF triples. RDF and relational are similar but free form RDF is hard to put into a pure relational schema, as schema is derived from the data in RDF. There are ways to recover relational schema's from RDF but these are not yet in production state.
- osi 10y agoi helped build a triple store on top of postgresql back in '06-'08. company is gone so i don't know where the IP ended up, but it was a good foundation. we were competitive with the other players at the time.