{"id":104730,"date":"2022-07-29T15:37:11","date_gmt":"2022-07-29T13:37:12","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/vypusk-relyaczionno-grafovoj-subd-edgedb-2-0"},"modified":"2022-07-29T15:37:11","modified_gmt":"2022-07-29T13:37:12","slug":"vypusk-relyaczionno-grafovoj-subd-edgedb-2-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-relyaczionno-grafovoj-subd-edgedb-2-0","title":{"rendered":"L\u00ebshimi i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave relacional-grafike EdgeDB 2.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

U lansimin e EdgeDB 2.0, nj\u00eb sistem menaxhimi t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave q\u00eb implementon nj\u00eb model t\u00eb dh\u00ebnash relacional-grafik dhe gjuh\u00ebn e pyetjeve EdgeQL, t\u00eb optimizuar p\u00ebr pun\u00eb me t\u00eb dh\u00ebna komplekse hierarkike. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebt Python dhe Rust (parseri dhe pjes\u00ebt kritike p\u00ebr performanc\u00ebn) dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn Apache 2.0. Projekti zhvillohet si nj\u00eb shtes\u00eb mbi PostgreSQL. Bibliotekat klient jan\u00eb p\u00ebrgatitur p\u00ebr gjuh\u00ebt Python, Go, Rust dhe TypeScript\/Javascript. Ofron nj\u00eb mjet komand\u00eb p\u00ebr administrimin e SGBD-s\u00eb dhe ekzekutimin interaktiv t\u00eb pyetjeve (REPL). <\/p>\n

N\u00eb EdgeDB, n\u00eb vend t\u00eb modelit t\u00eb t\u00eb dh\u00ebnave t\u00eb bazuara n\u00eb tabela, p\u00ebrdoret nj\u00eb sistem deklarativ i bazuar n\u00eb tipa objektesh. N\u00eb vend t\u00eb \u00e7el\u00ebsave t\u00eb jasht\u00ebm (foreign key) p\u00ebr t\u00eb p\u00ebrkufizuar lidhjet mes tipave, \u00ebsht\u00eb e mundur t\u00eb lidhen p\u00ebrmes lidhjeve (nj\u00eb objekt mund t\u00eb p\u00ebrdoret si nj\u00eb pron\u00eb e nj\u00eb objekti tjet\u00ebr). <\/p>\n

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 pyetjeve, mb\u00ebshtetet si gjuha e pyetjeve GraphQL ashtu edhe gjuha e vet EdgeDB, e cila \u00ebsht\u00eb nj\u00eb adaptim i SQL p\u00ebr t\u00eb dh\u00ebna hierarkike. N\u00eb vend t\u00eb listave, rezultatet e pyetjes paraqiten n\u00eb nj\u00eb format t\u00eb strukturuar, dhe n\u00eb vend t\u00eb n\u00ebnpyetjeve dhe operacioneve JOIN, ofrohet mund\u00ebsia p\u00ebr t\u00eb caktuar nj\u00eb pyetje EdgeQL si nj\u00eb shprehje brenda nj\u00eb pyetje tjet\u00ebr. Mb\u00ebshteten transaksionet dhe ciklet. <\/p>\n

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 } ); <\/p>\n

N\u00eb k\u00ebt\u00eb version t\u00eb ri: <\/p>\n