[
Date Prev][
Date Next][
Thread Prev][Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [rdf4j-dev] SQL sail connection
|
- From: jerven Bolleman <jerven.bolleman@sib.swiss>
- Date: Fri, 30 Jun 2023 09:24:55 +0200
- Arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=sib.swiss; dmarc=pass action=none header.from=sib.swiss; dkim=pass header.d=sib.swiss; arc=none
- Arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=5sLTZwxwwXrN+MeOg6E0o2kMpmbADuDoYsTnP+2oDwc=; b=AEUDfiyaicWiSSEGT81+vckgia7jYG678lJB1op0PYhIvWX69qkQPEnHoAaRknw2ghapPCgCeoh4i0CiPjUUG3P+0iyh2wo64hJ13fuwapCHDJdSRP6abVtu06AMFYR02KPO0v9P8xe/H6IzED8bTxWM4RiGUpdqoOnb7LG5rOoK0oPHhhIulOUpAOQ1sNRkVlNUEZ30YlVreoqEsAAJ1Iw+vHChGAEc7n+j7iX9IuJZORdpbe2ewa5fUC+UpQ3FowPoxg95/9cT/W/OTuSvsyxr/lxKe4zGCo/ydpad0Cn3cXrVHY4ueL5rlm/P6KIxoK2aFa307upCkx7WNoh5aA==
- Arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=f7+ENW/pfINoDZ2KgVKTmaOl0sA+ZNpUprTKaz3/BjHskpCnufvzN1QJS8GTB2ko+JtdvoI1C7ludqEdCoUjoZnEfnyfeLZJcKxDk16dYgyphQjJmry9sXBBVIWDNDYnlCZrZGGltUs7oM3dJ8hUctI2KHVa0oqwxyApNh/yTp5LhCIdOQKV9DVYlWiuRHAw3RzZiR9Zko+VA2IBkgOPHmefoi5vQEnwcUoFCQ/6Ev3AwYMSfuTiMW2p823gtp1mhLRgvkgjDUlPNkju4F6cc+ZM7IHdDqZBDrR134aW7z2Dnj01lnoRQ8/XZmj1KErhQ48VGm4OTzJb3X6FMtTwxA==
- Delivered-to: rdf4j-dev@xxxxxxxxxxx
- List-archive: <https://www.eclipse.org/mailman/private/rdf4j-dev/>
- List-help: <mailto:rdf4j-dev-request@eclipse.org?subject=help>
- List-subscribe: <https://www.eclipse.org/mailman/listinfo/rdf4j-dev>, <mailto:rdf4j-dev-request@eclipse.org?subject=subscribe>
- List-unsubscribe: <https://www.eclipse.org/mailman/options/rdf4j-dev>, <mailto:rdf4j-dev-request@eclipse.org?subject=unsubscribe>
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.12.0
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