Re: [rdf4j-dev] SQL sail connection

[Håvard Ottestad <hmottestad@xxxxxxxxx>]

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