Don PostgreSQL AGE (AgensGraph-Extension) ƙari tare da aiwatar da harshen tambaya don sarrafa saitin bayanai masu alaƙa masu alaƙa waɗanda ke samar da jadawali. Maimakon ginshiƙai da layuka, ma'ajin bayanai masu dacewa da jadawali suna amfani da tsari mai kama da hanyar sadarwa - nodes, kaddarorin su, da alaƙa tsakanin nodes an ƙayyade. SHEKARA mai lasisi a ƙarƙashin lasisin Apache 2.0, wanda Bitnine ya kawo ƙarƙashin kulawar Gidauniyar Apache, kuma a halin yanzu yana zaune a cikin Apache Incubator.
Aikin yana ci gaba da haɓaka DBMS wacce shine gyara na PostgreSQL don sarrafa hoto. Bambanci mai mahimmanci shine aiwatar da AGE a cikin nau'i na add-on duniya wanda ke aiki a matsayin ƙarawa akan daidaitattun sakin PostgreSQL. Batun da aka buga kwanan nan yana goyan bayan PostgreSQL 11.
A halin yanzu AGE irin waɗannan fasalulluka na harshen tambayar Cypher kamar yin amfani da kalmar "CREATE" don ayyana nodes da haɗin kai, kalmar "MATCH" don bincika bayanai a cikin jadawali bisa ga ƙayyadadden yanayi (INA), a cikin ƙayyadadden tsari (ORDER BY) kuma tare da saita ƙuntatawa (TSALLAKA, LIMIT) . Saitin sakamakon da tambayar ta dawo ana ƙaddara ta amfani da kalmar "DAwo". Ana samun kalmar "WITH" don sarkar buƙatun da yawa tare.
Yana yiwuwa a ƙirƙira bayanan ƙididdiga masu yawa waɗanda ke haɗa samfura don ajiyar matsayi na kaddarorin a cikin nau'in jadawali, ƙirar alaƙa da ƙirar don adana takardu a tsarin JSON. Yana goyan bayan aiwatar da haɗaɗɗiyar tambayoyin da suka haɗa da abubuwan SQL da harsunan Cypher.
Yana yiwuwa a ƙirƙira fihirisa don kaddarorin madaidaitan da gefuna na jadawali.
An ba da shawarar ƙarin saitin nau'ikan Agtype don amfani, gami da nau'ikan gefuna, madaidaitan da hanyoyi a cikin jadawali. Har yanzu ba a aiwatar da jimlar maganganun ba. Akwai ayyuka na musamman sun haɗa da id, start_id, end_id, nau'in, kaddarorin, kai, na ƙarshe, tsayi, girman, startNode, endNode, timestamp, toBoolean, toFloat, toInteger, da coalesce.
source: budenet.ru