{"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\/hu\/blog\/news\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb","title":{"rendered":"Az EdgeDB els\u0151 stabil kiad\u00e1sa, rel\u00e1ci\u00f3s-grafikus DBMS","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p>Megjelent az EdgeDB els\u0151 stabil kiad\u00e1sa, amely a PostgreSQL f\u00f6l\u00f6tt egy rel\u00e1ci\u00f3s-gr\u00e1f adatm\u00f3delt \u00e9s az EdgeQL lek\u00e9rdez\u00e9si nyelvet val\u00f3s\u00edt meg, optimaliz\u00e1lva a bonyolult hierarchikus adatok kezel\u00e9s\u00e9re. A k\u00f3d Python \u00e9s Rust nyelveken \u00edr\u00f3dott, \u00e9s az Apache 2.0 licenc alatt terjesztik. \u00dcgyf\u00e9llibr\u00e1rik k\u00e9sz\u00fcltek Python, Go, Rust \u00e9s TypeScript\/Javascript nyelvekhez. Parancssori eszk\u00f6zk\u00e9szlet \u00e1ll rendelkez\u00e9sre az adatb\u00e1zis kezel\u00e9s\u00e9re \u00e9s interakt\u00edv lek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1s\u00e1ra (REPL).      <\/p>\n<p>Az EdgeDB nem t\u00e1bl\u00e1zat alap\u00fa adatm\u00f3dellje deklarat\u00edv rendszert alkalmaz objektumt\u00edpusok alapj\u00e1n. A t\u00edpusok k\u00f6z\u00f6tti kapcsolatok meghat\u00e1roz\u00e1s\u00e1hoz a k\u00fcls\u0151 kulcsok helyett hivatkoz\u00e1sok k\u00f6t\u00e9sek\u00e9nt val\u00f3 \u00f6sszekapcsol\u00e1st haszn\u00e1lnak (egy objektum haszn\u00e1lhat\u00f3 egy m\u00e1sik objektum tulajdons\u00e1gak\u00e9nt).        type Person {       required property name -&gt; str;     }     type Movie {       required property title -&gt; str;       multi link actors -&gt; Person;     }      <\/p>\n<p>A lek\u00e9rdez\u00e9sek feldolgoz\u00e1s\u00e1nak felgyors\u00edt\u00e1s\u00e1ra indexek alkalmazhat\u00f3k. Tov\u00e1bb\u00e1 t\u00e1mogatottak a szigor\u00fa t\u00edpusellen\u0151rz\u00e9s, a jellemz\u0151k \u00e9rt\u00e9keinek korl\u00e1toz\u00e1sa, a sz\u00e1m\u00edtott jellemz\u0151k \u00e9s a t\u00e1rolt elj\u00e1r\u00e1sok. Az EdgeDB objektum-t\u00e1rol\u00e1si s\u00e9m\u00e1j\u00e1ban, amely hasonl\u00edt az ORM-re, kiemelkedik a s\u00e9m\u00e1k kever\u00e9s\u00e9nek, k\u00fcl\u00f6nb\u00f6z\u0151 objektumok jellemz\u0151inek \u00f6sszekapcsol\u00e1s\u00e1nak \u00e9s a JSON integr\u00e1lt t\u00e1mogat\u00e1s\u00e1nak lehet\u0151s\u00e9ge.     <\/p>\n<p>Bels\u0151 eszk\u00f6z\u00f6ket biztos\u00edtunk a t\u00e1rol\u00e1si s\u00e9ma migr\u00e1l\u00e1s\u00e1hoz \u2014 a k\u00fcl\u00f6n esdl f\u00e1jlban meghat\u00e1rozott s\u00e9ma megv\u00e1ltoztat\u00e1sa ut\u00e1n elegend\u0151 v\u00e9grehajtani a \u201eedgedb migration create\u201d parancsot, \u00e9s az adatb\u00e1zis-kezel\u0151 rendszere elemzi a s\u00e9ma k\u00f6z\u00f6tti elt\u00e9r\u00e9seket, \u00e9s interakt\u00edv m\u00f3dban gener\u00e1lja a szkriptet az \u00faj s\u00e9ma alkalmaz\u00e1s\u00e1hoz. Automatikusan nyomon k\u00f6vetj\u00fck a s\u00e9ma v\u00e1ltoztat\u00e1s\u00e1nak t\u00f6rt\u00e9net\u00e9t.    <\/p>\n<p>A lek\u00e9rdez\u00e9sek kialak\u00edt\u00e1s\u00e1hoz mind a GraphQL lek\u00e9rdez\u00e9si nyelv, mind a saj\u00e1t EdgeDB nyelv t\u00e1mogatott, amely az SQL hierarchikus adatokhoz val\u00f3 alkalmaz\u00e1sa. A list\u00e1k helyett a lek\u00e9rdez\u00e9s eredm\u00e9nyeit struktur\u00e1lt form\u00e1ban jelen\u00edtik meg, \u00e9s az al-lek\u00e9rdez\u00e9sek \u00e9s JOIN m\u0171veletek helyett lehet\u0151s\u00e9g van arra, hogy egy EdgeQL lek\u00e9rdez\u00e9st kifejez\u00e9sk\u00e9nt haszn\u00e1ljanak egy m\u00e1sik lek\u00e9rdez\u00e9sben. T\u00e1mogatottak a tranzakci\u00f3k \u00e9s ciklusok.         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 }     );<br \/>\n<br \/>Forr\u00e1s: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=56682\">opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\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 [&hellip;]<\/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<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/hu\/blog\/news\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\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\" \/>\n\t\t<meta property=\"og:description\" content=\"\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.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hu\/blog\/news\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2022-02-12T01:36:45+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2022-02-12T01:36:45+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Az EdgeDB els\u0151 stabil kiad\u00e1sa rel\u00e1ci\u00f3s-gr\u00e1f adatb\u00e1zis | ProHoster","description":"Megjelent az EdgeDB els\u0151 stabil kiad\u00e1sa, amely a PostgreSQL f\u00f6l\u00f6tt egy rel\u00e1ci\u00f3s-gr\u00e1f adatm\u00f3delt \u00e9s az EdgeQL lek\u00e9rdez\u00e9si nyelvet val\u00f3s\u00edt meg, optimaliz\u00e1lva a bonyolult.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/pervyj-stabilnyj-reliz-relyaczionno-grafovoj-subd-edgedb","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/103302","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=103302"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/103302\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=103302"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=103302"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=103302"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}