News for hackers. Stuff that matters.
Re:What Every Competent Graph DBMS Should Do by revskill on Thursday January 12, 2023 @04:33PM (#34360539)
In the match clause, i don't see the foreign key, how those tables get to know each other to join ?
Re:What Every Competent Graph DBMS Should Do by xkcd99 on Thursday January 12, 2023 @04:45PM (#34360703)
in gdbms, there is the concept of "predefined joins" where you define a relationship edge that directly connects 2 nodes, i don't know how these guys do it, but at least in neo4j that's the concept

edit: just saw their blog, they ask you to define a "rel table" and that has to define all the joins and they load it from there

Re:What Every Competent Graph DBMS Should Do by semihsalihoglu on Thursday January 12, 2023 @04:59PM (#34360842)
When you insert the Transfer records in my example, you indicate that they are "edges/relationships" between "Account" node records. The system interprets the values in those records implicitly as foreign keys to the Account records. This is what I mean by "predefined joins" in my example. When you ingest your relationship records, you predefine a join to the system and the GDBMS uses those Transfer records to join node records.

Hope this helps.