jrgemignani commented on issue #29: URL: https://github.com/apache/incubator-age/issues/29#issuecomment-800466853
AGE is based on openCypher implemented in PostgreSQL (version 11 atm) as an extension. This makes it more flexible to use, for example, in a current PostgreSQL environment/shop. However, due to it being an extension, it has some limitations (due to limitations common to all extensions) as to how well it can integrate into PostgreSQL. An example of this is the lack of hooks for modifying the grammar, you can see this in the form of the openCypher commands. AgensGraph is based on Cypher (it wasn't openCypher at the time of implementation) implemented in PostgreSQL (version 9) as a fork. This anchors it in a very specific version of PostgreSQL and makes it difficult to migrate both the code and the data. However, due to being more integrated, it has the advantages of modifying whatever needs to be modified. An example of this is the grammar, which is nicely integrated along the side of SQL. Which is better depends on what you value more. Both are implementations of Cypher in PostgreSQL. AGE is still in the alpha stage so, not all functionality has been implemented as of yet. As implementations of Cypher, they are both focused specifically on representing and querying graphs. As for the AGE (agtype) data type, it is based off of a PostgreSQL data type and is built into the PostgreSQL system. You can look at the code to see how, if you like. I'm not going to comment much on the "debate" or "merit" of a using SQL commands to create a "similar" functionality. Sure, you can contort many other tools to work for a particular purpose that they may not have been intended for. However, I have always found it best (less cumbersome, less confusing) to use the most appropriate tool for the job. Cypher is a language for representing and querying a graph. I hope this is helpful. John On Tue, Mar 16, 2021 at 8:49 AM Anh Tu Nguyen ***@***.***> wrote: > I'm also want to ask about the compliance between bitnine-oss AgenGraph > and AGE, are they using the same core components or somewhat different? And > is there any good reason not using bitnine-oss at the start? > > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub > <https://github.com/apache/incubator-age/issues/29#issuecomment-800380067>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/AALPO4G6VVNXPITSB35TGGLTD54ZBANCNFSM4YN7BKZA> > . > ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org
