Re: [rdf4j-dev] SQL sail connection

[jerven Bolleman <jerven.bolleman@sib.swiss>]

Hi Dan,

I just thought of https://github.com/the-qa-company/qEndpoint/ that is a 
combination of read/write based around HDT files. Maybe that is a 
potential starting point for a mixed system.

Regards,
Jerven

On 30/06/2023 09:22, Dan S wrote:
> 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.
>
>     https://ontop-vkg.org/ <https://ontop-vkg.org/>
>     Ontop <https://ontop-vkg.org/>
>     A Virtual Knowledge Graph System
>     ontop-vkg.org <http://ontop-vkg.org>
>
>
>
>     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
>     <mailto:rdf4j-dev-bounces@xxxxxxxxxxx>> on behalf of Bart Hanssens
>     (BOSA) via rdf4j-dev <rdf4j-dev@xxxxxxxxxxx
>     <mailto:rdf4j-dev@xxxxxxxxxxx>>
>     *Sent:* 30 June 2023 00:39
>     *To:* rdf4j developer discussions <rdf4j-dev@xxxxxxxxxxx
>     <mailto:rdf4j-dev@xxxxxxxxxxx>>
>     *Cc:* Bart Hanssens (BOSA) <bart.hanssens@xxxxxxxxxxxx
>     <mailto: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
>     <mailto:rdf4j-dev-bounces@xxxxxxxxxxx>> On Behalf Of Håvard Ottestad
>     Sent: donderdag 29 juni 2023 21:46
>     To: rdf4j developer discussions <rdf4j-dev@xxxxxxxxxxx
>     <mailto: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 <mailto: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 <mailto:rdf4j-dev@xxxxxxxxxxx>
>     > To unsubscribe from this list, visit https://www.eclipse.org/mailman/listinfo/rdf4j-dev
>     <https://www.eclipse.org/mailman/listinfo/rdf4j-dev>
>     _______________________________________________
>     rdf4j-dev mailing list
>     rdf4j-dev@xxxxxxxxxxx <mailto:rdf4j-dev@xxxxxxxxxxx>
>     To unsubscribe from this list, visit
>     https://www.eclipse.org/mailman/listinfo/rdf4j-dev
>     <https://www.eclipse.org/mailman/listinfo/rdf4j-dev>
>     _______________________________________________
>     rdf4j-dev mailing list
>     rdf4j-dev@xxxxxxxxxxx <mailto:rdf4j-dev@xxxxxxxxxxx>
>     To unsubscribe from this list, visit
>     https://www.eclipse.org/mailman/listinfo/rdf4j-dev
>     <https://www.eclipse.org/mailman/listinfo/rdf4j-dev>
>     _______________________________________________
>     rdf4j-dev mailing list
>     rdf4j-dev@xxxxxxxxxxx <mailto:rdf4j-dev@xxxxxxxxxxx>
>     To unsubscribe from this list, visit
>     https://www.eclipse.org/mailman/listinfo/rdf4j-dev
>     <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

--

	*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