Try alternative graph database

[northdpole]

Issue

What is the issue?

Gap analysis calculation takes a few hours if we run it on a beefy machine. The bottleneck is neo4j being slow.
We should investigate alternatives.
An alternative that seems promising and works with our existing database is Apache Age

Age runs on top of our current database (postgres) and allows for Cypher queries on top of postgres.
I'm being told it is faster than neo

[uMorbeck]

Hi, is this issue still available?

[northdpole]

hey, thanks for your interest in OpenCRE yes it is!
Want help getting started or are you familiar with the project already?

[uMorbeck]

Great! My friend and I are looking for some open-source projects to work on for a college subject. He actually commented on issue #295, and we're looking to solve these two issues. Our plan right now is to work on #295 first and then this one afterward.

[northdpole]

Excellent! Let me know if you need help or guidance.

…

On Wed, 3 Jul 2024, 19:44 João Pedro Morbeck, ***@***.***> wrote: Great! My friend and I are looking for some open-source projects to work on for a college subject. He actually commented on issue #295 <#295>, and we're looking to solve these two issues. Our plan right now is to work on #295 <#295> first and then this one afterward. — Reply to this email directly, view it on GitHub <#488 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAMCRHVM7A73B6474XIJ3WTZKRBB7AVCNFSM6AAAAABEC74QLKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMBWHE3TGOBVGY> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Riddhikshah21]

Hi @northdpole , Is this issue still available?

[northdpole]

Hey @Riddhikshah21 , yes, no progress was done on this since last year,