{"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\/news\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb","title":{"rendered":"Publikimi i par\u00eb i q\u00ebndruesh\u00ebm i DBMS-s\u00eb relacionale-grafike EdgeDB","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Disponohet versione e par\u00eb stabile e DBMS EdgeDB, e cila p\u00ebrb\u00ebn nj\u00eb shtres\u00eb mbi PostgreSQL me implementimin e nj\u00eb modeli relacional-grafik t\u00eb t\u00eb dh\u00ebnave dhe gjuh\u00ebs s\u00eb k\u00ebrkesave 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 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 nj\u00eb instrument p\u00ebr komand\u00ebn e linj\u00ebs p\u00ebr administrimin e DBMS dhe p\u00ebr ekzekutimin interaktiv t\u00eb k\u00ebrkesave (REPL). <\/p>\n

N\u00eb vend t\u00eb nj\u00eb modeli t\u00eb dh\u00ebnash t\u00eb bazuara n\u00eb tabela, EdgeDB p\u00ebrdor nj\u00eb sistem deklarativ t\u00eb bazuar n\u00eb lloje objektesh. N\u00eb vend t\u00eb ky\u00e7jeve t\u00eb jashtme (foreign key) p\u00ebr t\u00eb p\u00ebrcaktuar lidhjen midis llojeve, 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

P\u00ebr t\u00eb p\u00ebrshpejtuar p\u00ebrpunimin e pyetjeve, mund t\u00eb p\u00ebrdoren indekse. Nga k\u00ebto mund\u00ebsi, mb\u00ebshteten gjithashtu tipizimi strikt i pronave, kufizimet e vlerave t\u00eb pronave, pronat e llogaritura dhe procedurat e ruajtura. Nj\u00eb tipar i ve\u00e7ant\u00eb i skem\u00ebs objektuale t\u00eb ruajtjes n\u00eb EdgeDB, e cila p\u00ebrshtatet me ORM-n\u00eb, \u00ebsht\u00eb mund\u00ebsia p\u00ebr t\u00eb p\u00ebrzier skema, lidhjen e pronave nga objekte t\u00eb ndryshme dhe mb\u00ebshtetje e integruar p\u00ebr JSON. <\/p>\n

Mund\u00ebsohen mjete t\u00eb nd\u00ebrtuara brenda p\u00ebr migrimin e skem\u00ebs s\u00eb ruajtjes \u2014 pas ndryshimit t\u00eb skem\u00ebs, si\u00e7 p\u00ebrcaktohet n\u00eb nj\u00eb sked\u00eb t\u00eb ve\u00e7ant\u00eb esdl, mjafton t\u00eb ekzekutohet komanda \u00abedgedb migration create\u00bb dhe SGBD analizom ndryshimet n\u00eb skem\u00eb dhe n\u00eb nj\u00eb m\u00ebnyr\u00eb interaktive gjeneron nj\u00eb skenar p\u00ebr kalimin n\u00eb skem\u00ebn e re. Historia e ndryshimeve t\u00eb skem\u00ebs monitorohet automatikisht. <\/p>\n

P\u00ebr formimin e k\u00ebrkesave mb\u00ebshtetet si gjuha e k\u00ebrkesave GraphQL, ashtu edhe gjuha e vet EdgeDB, e cila \u00ebsht\u00eb nj\u00eb adaptim i SQL p\u00ebr t\u00eb dh\u00ebnat 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, ofrohet mund\u00ebsia e specifikimit t\u00eb nj\u00eb k\u00ebrkese EdgeQL si nj\u00eb shprehje brenda nj\u00eb k\u00ebrkese tjet\u00ebr. Mb\u00ebshteten transaksionet dhe ciklet. select Movie { title, actors: { name } } filter .title = \u00abThe Matrix\u00bb insert Movie { title := \u00abThe Matrix Resurrections\u00bb, actors := ( select Person filter .name in { \u2018Keanu Reeves\u2019, \u2018Carrie-Anne Moss\u2019, \u2018Laurence Fishburne\u2019 } ) } 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":"

\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 EdgeDB, \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0443\u044e \u0441\u043e\u0431\u043e\u0439 \u043d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0443 \u043d\u0430\u0434 PostgreSQL \u0441 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e-\u0433\u0440\u0430\u0444\u043e\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u044f\u0437\u044b\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 EdgeQL, \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441\u043e \u0441\u043b\u043e\u0436\u043d\u044b\u043c\u0438 \u0438\u0435\u0440\u0430\u0440\u0445\u0438\u0447\u0435\u0441\u043a\u0438\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u043c\u0438. \u041a\u043e\u0434 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0430\u0445 Python \u0438 Rust \u0438 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 Apache 2.0. \u041a\u043b\u0438\u0435\u043d\u0442\u0441\u043a\u0438\u0435 \u0431\u0438\u0431\u043b\u0438\u043e\u0442\u0435\u043a\u0438 \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043b\u0435\u043d\u044b \u0434\u043b\u044f \u044f\u0437\u044b\u043a\u043e\u0432 Python, Go, Rust \u0438 TypeScript\/Javascript. \u041f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u0440\u0438\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u043d\u043e\u0439 \u0441\u0442\u043e\u043a\u0438 \u0434\u043b\u044f […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-103302","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Versioni i par\u00eb stabil i DBMS relacional-grafik EdgeDB | ProHoster","description":"Disponohet versione e par\u00eb stabile e DBMS EdgeDB, e cila p\u00ebrb\u00ebn nj\u00eb shtres\u00eb mbi PostgreSQL me implementimin e nj\u00eb modeli relacional-grafik t\u00eb t\u00eb dh\u00ebnave dhe gjuh\u00ebs s\u00eb k\u00ebrkesave EdgeQL, t\u00eb optimizuar p\u00ebr pun\u00eb me t\u00eb dh\u00ebna komplekse.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e-\u0433\u0440\u0430\u0444\u043e\u0432\u043e\u0439 \u0421\u0423\u0411\u0414 EdgeDB | ProHoster","og:description":"\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u043f\u0435\u0440\u0432\u044b\u0439 \u0441\u0442\u0430\u0431\u0438\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u043b\u0438\u0437 \u0421\u0423\u0411\u0414 EdgeDB, \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0443\u044e \u0441\u043e\u0431\u043e\u0439 \u043d\u0430\u0434\u0441\u0442\u0440\u043e\u0439\u043a\u0443 \u043d\u0430\u0434 PostgreSQL \u0441 \u0440\u0435\u0430\u043b\u0438\u0437\u0430\u0446\u0438\u0435\u0439 \u0440\u0435\u043b\u044f\u0446\u0438\u043e\u043d\u043d\u043e-\u0433\u0440\u0430\u0444\u043e\u0432\u043e\u0439 \u043c\u043e\u0434\u0435\u043b\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438 \u044f\u0437\u044b\u043a\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 EdgeQL, \u043e\u043f\u0442\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0441\u043e \u0441\u043b\u043e\u0436\u043d\u044b\u043c\u0438.","og:url":"https:\/\/prohoster.info\/sq\/blog\/news\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2022-02-12T01:36:45+00:00","article:modified_time":"2022-02-12T01:36:45+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"103302","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2022-02-12 01:37:45","updated":"2022-09-27 16:53:21","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/103302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=103302"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/103302\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=103302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=103302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=103302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}