Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [rdf4j-dev] SQL sail connection
Thanks all, we were aware of ontop, but need writes. I'll see if I can dig up the old Kiwi or SDB before starting from scratch.

On Fri, Jun 30, 2023, 02:07 Jerven Tjalling Bolleman <Jerven.Bolleman@sib.swiss> wrote:
Hi,

Another option is ontop that also provides a SAIL. But that is read-only on the SPARQL level.



Regards,
Jerven

SIB logo
 Jerven Tjalling Bolleman
Principal Software Developer
SIB | Swiss Institute of Bioinformatics
1, rue Michel Servet - CH 1211 Geneva 4 - Switzerland
t +41 22 379 58 85
Jerven.Bolleman@sib.swiss - www.sib.swiss

From: rdf4j-dev <rdf4j-dev-bounces@xxxxxxxxxxx> on behalf of Bart Hanssens (BOSA) via rdf4j-dev <rdf4j-dev@xxxxxxxxxxx>
Sent: 30 June 2023 00:39
To: rdf4j developer discussions <rdf4j-dev@xxxxxxxxxxx>
Cc: Bart Hanssens (BOSA) <bart.hanssens@xxxxxxxxxxxx>
Subject: Re: [rdf4j-dev] SQL sail connection
 
Hi,

Well, there is also Oracle Spatial...

If memory serves me well, there used to be a sail on top of postgresql (Kiwi used by Apache Marmotta),
but that project isn't maintained anymore ...


Best regards

Bart

-----Original Message-----
From: rdf4j-dev <rdf4j-dev-bounces@xxxxxxxxxxx> On Behalf Of Håvard Ottestad
Sent: donderdag 29 juni 2023 21:46
To: rdf4j developer discussions <rdf4j-dev@xxxxxxxxxxx>
Subject: Re: [rdf4j-dev] SQL sail connection

Hi,

If you want a replicated database you could try GraphDB. It’s not SQL, but it’s ACID and supports replication. RDF4J NativeStore is also ACID but doesn’t support any replication, and it’s less battle tested compared to GraphDB.

My experience with Jena SDB has been that it had terrible performance and needed to move a lot of data on the network.

I’ve implemented the ElasticsearchStore, which would allow you to have replicated ElasticSearch instances. Performance is rather terrible too. It’s useful if you are already using ElasticSearch for something and just want to store a small amount of mostly static RDF. Which is how I’m using it.

I would recommend going with a database that already supports RDF and SPARQL.

Cheers,
Håvard M. Ottestad

> On 29 Jun 2023, at 20:05, Dan S <danielms853@xxxxxxxxx> wrote:
>
> 
> Hello,
>
> I was wondering whether there was any existing SQL SAIL implementation for RDF4J (particularly targeting mysql or postgres), perhaps in the vein of Halyard.
>
> We (my team at work) and I would be interested in an Rdf4j implementation backed by a replicated store with ACID transactions (or, potentially a Jena equivalent, but RDB seems to be deprecated).
>
> I would potentially be willing to contribute an implementation.
>
> Thank you,
>
> Daniel Scanteianu
>
> _______________________________________________
> rdf4j-dev mailing list
> rdf4j-dev@xxxxxxxxxxx
> To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/rdf4j-dev
_______________________________________________
rdf4j-dev mailing list
rdf4j-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/rdf4j-dev
_______________________________________________
rdf4j-dev mailing list
rdf4j-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/rdf4j-dev
_______________________________________________
rdf4j-dev mailing list
rdf4j-dev@xxxxxxxxxxx
To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/rdf4j-dev

Back to the top