{"id":103302,"date":"2022-02-12T03:36:45","date_gmt":"2022-02-12T01:36:45","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb"},"modified":"2022-02-12T03:36:45","modified_gmt":"2022-02-12T01:36:45","slug":"pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb","title":{"rendered":"L\u00ebshimi i par\u00eb stabil i sistemit t\u00eb menaxhimit t\u00eb t\u00eb dh\u00ebnave rrelacionale-grafike EdgeDB","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Versioni e par\u00eb stabile e SGBD-s\u00eb EdgeDB \u00ebsht\u00eb tani n\u00eb dispozicion, q\u00eb p\u00ebrfaq\u00ebson nj\u00eb shtres\u00eb mbi PostgreSQL me implementimin e nj\u00eb modeli t\u00eb dh\u00ebnash relacional-grafik dhe gjuh\u00ebs s\u00eb pyetjeve EdgeQL, t\u00eb optimizuar p\u00ebr t\u00eb punuar me t\u00eb dh\u00ebna komplekse hierarkike. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebt Python dhe Rust dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn Apache 2.0. Bibliotekat e klient\u00ebve jan\u00eb p\u00ebrgatitur p\u00ebr gjuh\u00ebt Python, Go, Rust dhe TypeScript\/Javascript. Ofron mjete komandash p\u00ebr menaxhimin e SGBD-s\u00eb dhe ekzekutimin interaktiv t\u00eb pyetjeve (REPL). <\/p>\n
N\u00eb vend t\u00eb nj\u00eb modeli t\u00eb dh\u00ebnash t\u00eb bazuar n\u00eb tabela n\u00eb EdgeDB, aplikohet nj\u00eb sistem deklarativ i bazuar n\u00eb tipet objektor. N\u00eb vend t\u00eb \u00e7el\u00ebsve t\u00eb jasht\u00ebm (foreign key) p\u00ebr p\u00ebrcaktimin e lidhjeve midis tipeve, p\u00ebrdoret lidhja me referenca (nj\u00eb objekt mund t\u00eb p\u00ebrdoret si nj\u00eb pron\u00eb e nj\u00eb objekti tjet\u00ebr). type Person { required property name -> str; } type Movie { required property title -> str; multi link actors -> Person; } <\/p>\n
Indekset mund t\u00eb p\u00ebrdoren p\u00ebr t\u00eb p\u00ebrshpejtuar p\u00ebrpunimin e k\u00ebrkesave. Mb\u00ebshteten gjithashtu mund\u00ebsi t\u00eb tilla si tipizimi i rigoroz i pronave, kufizimet e vlerave t\u00eb pronave, pronat e llogaritur dhe procedurat e ruajtura. Nj\u00eb nga ve\u00e7orit\u00eb e skem\u00ebs objektike t\u00eb ruajtjes EdgeDB, e cila ngjan disi me ORM, \u00ebsht\u00eb mund\u00ebsia e p\u00ebrzierjes s\u00eb skemave, lidhjes s\u00eb pronave nga objekte t\u00eb ndryshme dhe mb\u00ebshtetje e integruar p\u00ebr JSON. <\/p>\n
T\u00eb dh\u00ebnat e integruar p\u00ebrmenden mjetet p\u00ebr migrimin e skemave t\u00eb ruajtjes \u2014 pas ndryshimeve t\u00eb skem\u00ebs, t\u00eb cilat p\u00ebrcaktohen n\u00eb nj\u00eb skedar t\u00eb ve\u00e7ant\u00eb esdl, mjafton t\u00eb ekzekutoni komand\u00ebn «edgedb migration create» dhe SGBD do t\u00eb analizoj\u00eb ndryshimet n\u00eb skem\u00eb dhe, n\u00eb nj\u00eb m\u00ebnyr\u00eb interaktive, do t\u00eb gjeneroj\u00eb skript p\u00ebr kalimin n\u00eb skem\u00ebn e re. Historia e ndryshimeve n\u00eb skem\u00eb ndjeket automatikisht. <\/p>\n
P\u00ebr formimin e k\u00ebrkesave p\u00ebrkrahet si gjuha e k\u00ebrkesave GraphQL, ashtu dhe gjuha e vet EdgeDB, e cila p\u00ebrb\u00ebn nj\u00eb adaptim t\u00eb SQL p\u00ebr t\u00eb dh\u00ebna hierarkike. N\u00eb vend t\u00eb listave, rezultatet e k\u00ebrkes\u00ebs paraqiten n\u00eb nj\u00eb form\u00eb t\u00eb strukturuar, dhe n\u00eb vend t\u00eb n\u00ebnk\u00ebrkesave dhe operacioneve JOIN jepet mund\u00ebsia e specifikimit t\u00eb nj\u00eb k\u00ebrkese EdgeQL si nj\u00eb shprehje brenda nj\u00eb k\u00ebrkese tjet\u00ebr. P\u00ebrkrahen transaksionet dhe ciklet. select Movie { title, actors: { name } } filter .title = \"The Matrix\" insert Movie { title := \"The Matrix Resurrections\", actors := ( select Person filter .name in { 'Keanu Reeves', 'Carrie-Anne Moss', 'Laurence Fishburne' } ) } for number in {0, 1, 2, 3} union ( select { number, number + 0.5 } ); \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"