Bakeng sa PostgreSQL Keketso ea AGE (AgensGraph-Extension) e nang le ts'ebetsong ea puo ea potso bakeng sa ho laola lihlopha tsa data tse hokahaneng tsa maemo a holimo tse etsang kerafo. Ho e-na le litšiea le mela, li-database tse shebaneng le kerafo li sebelisa sebopeho se tšoanang le marang-rang-li-node, thepa ea tsona, le likamano pakeng tsa li-node li hlalositsoe. LILEMO e nang le laesense tlas'a laesense ea Apache 2.0, e tlisitsoeng tlas'a motheo oa Apache Foundation ke Bitnine, 'me hajoale e lutse ho Apache Incubator.
Morero o ntse o tsoela pele ntlafatso ea DBMS e leng ke phetoho e fetotsoeng ea PostgreSQL bakeng sa ts'ebetso ea graph. Phapang ea bohlokoa ke ts'ebetsong ea AGE ka mokhoa oa tlatsetso ea bokahohle e sebetsang e le tlatsetso holim'a litokollo tse tloaelehileng tsa PostgreSQL. Khatiso e hatisitsoeng haufinyane e tšehetsa PostgreSQL 11.
Boemong ba hajoale AGE likarolo tse joalo tsa puo ea potso ea Cypher joalo ka ho sebelisa polelo ea "CREATE" ho hlalosa li-node le lihokela, polelo ea "MATCH" ho batla data ho graph ho latela maemo a boletsoeng (KAE), ka tatellano e boletsoeng (ORDER BY) le ka beha lithibelo (SKIP, LIMIT) . Sephetho se khutlisitsoeng ke potso se khethoa ho sebelisoa lentsoe "RETURN". Polelo ea "WITH" e fumaneha ho kopanya likopo tse ngata hammoho.
Hoa khoneha ho etsa li-database tsa mefuta e mengata tse kopanyang mehlala ea ho boloka thepa ea hierarchical ka sebōpeho sa kerafo, mohlala oa likamano le mohlala oa ho boloka litokomane ka mokhoa oa JSON. E ts'ehetsa ho etsoa ha lipotso tse kopaneng tse kenyelletsang likarolo tsa lipuo tsa SQL le Cypher.
Hoa khoneha ho theha li-index bakeng sa thepa ea li-vertices le likarolo tsa graph.
Sete e atolositsoeng ea mefuta ea Agtype e reriloe hore e sebelisoe, ho kenyeletsoa mefuta ea mathōko, lithapo le litsela tse graph. Lipolelo tse kopaneng ha li so kengoa tšebetsong. Mesebetsi e khethehileng e fumanehang e kenyelletsa id, start_id, end_id, type, properties, head, last, length, size, startNode, endNode, timestamp, toBoolean, toFloat, toInteger, le coalesce.
Source: opennet.ru