Feature completeness of different protocols etc.

[prempiyush]

Hello @lvca @robfrank and community!

@venkatramanam and myself are from IBM and are currently evaluating ArcadeDB as a Neo4J alternative for our Graph Traversal needs.

Firstly, let me applaud you for keeping the project under Apache 2.0 license forever 🫶
Also, your speed of fixing the issues raised is commendable!

I have been scouring over the docs to understand which query language over which protocol would suit our needs the best. However, I found through the documentation that perhaps not everything might be feature complete. e.g. snippets from docs.

Particularly, ArcadeDB does only support "simple" query mode and does not support SSL!

ArcadeDB Server supports a subset of the GraphQL specification. Please open an issue or a discussion on GitHub to increase the support for GraphQL.

ArcadeDB Server supports a subset of the Redis protocol. Please open an issue or a discussion on GitHub to support more commands.

I am just looking for some guidance here as to what would be a good combination of Query Language + Protocol to begin with?

I have seen the arcadedb-usecases repository and most examples are in ArcadeDB dialect of SQL. Would that be the best choice here? Getting devs to learn yet another sql might be challenging though :)

[lvca]

Hi, and welcome aboard!

Right now the top 2 query languages are SQL and Cypher. If you are going to do traversals, I'd suggest to go with Cypher: in ArcadeDB is now native (zero conversion) and super fast. On top of that, you'll find tons of docs about Cypher and Open Cypher on Neo4j and other websites.

I suggest SQL only if you're coming from OrientDB or it you really hate Cypher syntax :-)

[prempiyush]

Thanks @lvca ..

From the wire protocols, I believe both HTTP/GRPC should be feature complete? Postgres I saw does not support SSL yet, so out of the scope for us now.

While testing Bolt protocol in an HA Kube cluster, we had hit the same issue as #4456 which is now fixed in 26.6.1..

Any preferences from performance perspective between the three wire protocols? Http/Grpc/Bolt

[robfrank]

Actually I've implemented load tests only over http and grpc. It should be easy to implement the same tests using bolt. https://github.com/ArcadeData/arcadedb/tree/main/load-tests/src/test/java/com/arcadedb/test/load

Let me open an issue to cover this and have BOLT in these tests as well

[ayunaoss]

Hi @lvca, first of all thanks for this nice work! I had used OrientDB earlier as native Java embedding and found it very useful. Of late, we are evaluating to use ArcadeDB as a drop-in replacement for Neo4j-Aura. We currently depend on APOC and GDS plugins for Neo4j. Can you please clarify if this can be achieved and what functionalities are missing currently? I'm looking for Bolt with OpenCypher with the standard neo4j client for python. Thanks again.

[lvca]

Welcome back @ayunaoss, We support tons of functions compatible with APOC: https://docs.arcadedb.com/arcadedb/reference/extended-functions#apoc-compatibility. About graph algos, we actually have more algorithms than Neo4j (GDS), take a look at: https://docs.arcadedb.com/arcadedb/reference/graph-algorithms/chapter.

[ayunaoss]

Thank you @lvca. I will have a look.