{"id":99375,"date":"2021-03-07T16:22:42","date_gmt":"2021-03-07T14:22:43","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git"},"modified":"2021-03-07T16:22:42","modified_gmt":"2021-03-07T14:22:43","slug":"subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","title":{"rendered":"A Dolt DB lehet\u0151s\u00e9get biztos\u00edt az adatok Git-st\u00edlus\u00fa manipul\u00e1l\u00e1s\u00e1ra.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

A Dolt projekt egy olyan DBMS-t fejleszt, amely \u00f6tv\u00f6zi az SQL t\u00e1mogat\u00e1s\u00e1t a Git-st\u00edlus\u00fa adatverzi\u00f3z\u00e1ssal. A Dolt lehet\u0151v\u00e9 teszi t\u00e1bl\u00e1k kl\u00f3noz\u00e1s\u00e1t, el\u00e1gaz\u00e1sok l\u00e9trehoz\u00e1s\u00e1t \u00e9s t\u00e1bl\u00e1k egyes\u00edt\u00e9s\u00e9t, valamint push \u00e9s pull m\u0171veletek v\u00e9grehajt\u00e1s\u00e1t, hasonl\u00f3an a git t\u00e1rol\u00f3khoz. Emellett a DBMS t\u00e1mogatja az SQL lek\u00e9rdez\u00e9seket, \u00e9s \u00fcgyf\u00e9loldali interf\u00e9szek szinten kompatibilis a MySQL-lal. A projekt k\u00f3dja Go nyelven \u00edr\u00f3dott, \u00e9s az Apache 2.0 licenc alatt terjesztik. <\/p>\n

Az adatb\u00e1zisban t\u00f6rt\u00e9n\u0151 verzi\u00f3z\u00e1s lehet\u0151s\u00e9gei lehet\u0151v\u00e9 teszik az adatok sz\u00e1rmaz\u00e1s\u00e1nak nyomon k\u00f6vet\u00e9s\u00e9t \u2014 a commitokhoz val\u00f3 k\u00f6t\u0151d\u00e9s lehet\u0151s\u00e9get ad az \u00e1llapot r\u00f6gz\u00edt\u00e9s\u00e9re, hogy azonos eredm\u00e9nyeket lehessen el\u00e9rni, b\u00e1rhol is legyenek, b\u00e1rmikor megism\u00e9telhet\u0151k legyenek m\u00e1s rendszereken. Ezenk\u00edv\u00fcl a felhaszn\u00e1l\u00f3k navig\u00e1lhatnak a t\u00f6rt\u00e9netben, nyomon k\u00f6vethetik a t\u00e1bl\u00e1kban t\u00f6rt\u00e9nt v\u00e1ltoz\u00e1sokat SQL seg\u00edts\u00e9g\u00e9vel an\u00e9lk\u00fcl, hogy biztons\u00e1gi m\u00e1solatokkal kellene \u00f6sszehasonl\u00edtani, audit\u00e1lhatj\u00e1k a v\u00e1ltoz\u00e1sokat, \u00e9s lek\u00e9rdez\u00e9seket k\u00e9sz\u00edthetnek, amelyek egy adott pillanatban l\u00e9v\u0151 adatokat \u00f6lelnek fel.

\"A<\/center> <\/p>\n

A DBMS k\u00e9t m\u0171k\u00f6d\u00e9si m\u00f3dot biztos\u00edt \u2014 Offline \u00e9s Online. Offline \u00e1llapotba l\u00e9p\u00e9se ut\u00e1n az adatb\u00e1zis tartalma el\u00e9rhet\u0151v\u00e9 v\u00e1lik, mint egy t\u00e1rol\u00f3, amellyel git-szer\u0171 parancssori eszk\u00f6zzel lehet m\u0171veleteket v\u00e9gezni. A munka sok szempontb\u00f3l hasonl\u00edt a git-re, \u00e9s f\u0151k\u00e9nt abban k\u00fcl\u00f6nb\u00f6zik, hogy a v\u00e1ltoz\u00e1sokat nem f\u00e1jlokra, hanem a t\u00e1bl\u00e1k tartalm\u00e1ra k\u00f6vetik nyomon. A felk\u00edn\u00e1lt CLI fel\u00fcleten kereszt\u00fcl az adatok import\u00e1lhat\u00f3k CSV vagy JSON form\u00e1tum\u00fa f\u00e1jlokb\u00f3l, a v\u00e1ltoz\u00e1sokkal commitok hozz\u00e1adhat\u00f3k, a verzi\u00f3k k\u00f6z\u00f6tti k\u00fcl\u00f6nbs\u00e9gek megjelen\u00edthet\u0151k, \u00e1gak l\u00e9trehozhat\u00f3k, c\u00edmk\u00e9k \u00e1ll\u00edthat\u00f3k be, push k\u00e9r\u00e9sek k\u00fcldhet\u0151k k\u00fcls\u0151 szerverekre, \u00e9s a t\u00f6bbi r\u00e9sztvev\u0151 \u00e1ltal javasolt v\u00e1ltoz\u00e1sok \u00f6sszevonhat\u00f3k. <\/p>\n

Sz\u00fcks\u00e9g eset\u00e9n az adatok a DoltHub k\u00f6nyvt\u00e1rban helyezhet\u0151k el, amely a GitHub adatmegoszt\u00e1s anal\u00f3gi\u00e1jak\u00e9nt \u00e9rtelmezhet\u0151 az adatok t\u00e1rol\u00e1s\u00e1ra \u00e9s megosztott munk\u00e1ra. A felhaszn\u00e1l\u00f3k forkot k\u00e9sz\u00edthetnek az adatokat tartalmaz\u00f3 t\u00e1rol\u00f3kr\u00f3l, javasolhatj\u00e1k saj\u00e1t m\u00f3dos\u00edt\u00e1saikat \u00e9s egyes\u00edthetik saj\u00e1t adataikat. P\u00e9ld\u00e1ul a DoltHub-on k\u00fcl\u00f6nb\u00f6z\u0151 adatb\u00e1zisokat tal\u00e1lhatunk a koronav\u00edrus statisztik\u00e1ir\u00f3l, annot\u00e1lt adathalmazokat g\u00e9pi tanul\u00e1si rendszerekhez, nyelvi lexikai adatb\u00e1zisokat, k\u00e9pkollekci\u00f3kat, objektumok oszt\u00e1lyoz\u00e1s\u00e1ra szolg\u00e1l\u00f3 k\u00e9szleteket \u00e9s a hovatartoz\u00e1sra vonatkoz\u00f3 inform\u00e1ci\u00f3kat. IP-c\u00edmek<\/a>. <\/p>\n

Az 'online' m\u00f3dban a Dolt SQL Server elindul, amely lehet\u0151v\u00e9 teszi az adatok manipul\u00e1l\u00e1s\u00e1t SQL nyelv seg\u00edts\u00e9g\u00e9vel. A biztos\u00edtott fel\u00fclet k\u00f6zel \u00e1ll a MySQL-hez, \u00e9s haszn\u00e1lhat\u00f3 MySQL kompatibilis kliensekkel vagy CLI interf\u00e9szen kereszt\u00fcl. A Dolt ink\u00e1bb az adatok kezel\u00e9s\u00e9re szolg\u00e1l\u00f3 eszk\u00f6z, mintsem lek\u00e9rdez\u00e9sek feldolgoz\u00f3 rendszere. P\u00e9ld\u00e1ul alap\u00e9rtelmez\u00e9s szerint a SQL szerver csak egy akt\u00edv felhaszn\u00e1l\u00f3i kapcsolatot tud kezelni a jelenlegi k\u00f6nyvt\u00e1rban elhelyezett t\u00e1rol\u00f3hoz (ezt a be\u00e1ll\u00edt\u00e1sokban m\u00f3dos\u00edtani lehet). Ford\u00edt\u00e1s lehets\u00e9ges. a szerver<\/a> csak olvas\u00e1si m\u00f3dba. Sz\u00e1mos verzi\u00f3kezel\u00e9ssel kapcsolatos m\u0171velet is v\u00e9grehajthat\u00f3 SQL-en kereszt\u00fcl, p\u00e9ld\u00e1ul elk\u00f6telez\u00e9sek v\u00e9grehajt\u00e1sa vagy \u00e1gak k\u00f6z\u00f6tti v\u00e1lt\u00e1s.
\n
Forr\u00e1s: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u041f\u0440\u043e\u0435\u043a\u0442 Dolt \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442 \u0421\u0423\u0411\u0414, \u0441\u043e\u0447\u0435\u0442\u0430\u044e\u0449\u0443\u044e \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0443 SQL \u0441\u043e \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430\u043c\u0438 \u0432\u0435\u0440\u0441\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0441\u0442\u0438\u043b\u0435 Git. Dolt \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043a\u043b\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u0441\u043e\u0437\u0434\u0430\u0432\u0430\u0442\u044c \u0444\u043e\u0440\u043a\u0438 \u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0441\u043b\u0438\u044f\u043d\u0438\u044f \u0442\u0430\u0431\u043b\u0438\u0446, \u0430 \u0442\u0430\u043a\u0436\u0435 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u0438 push \u0438 pull \u043f\u043e \u0430\u043d\u0430\u043b\u043e\u0433\u0438\u0438 \u0441 \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u044f\u043c\u0438 \u0432 git-\u0440\u0435\u043f\u043e\u0437\u0438\u0442\u043e\u0440\u0438\u0438. \u041f\u0440\u0438 \u044d\u0442\u043e\u043c \u0421\u0423\u0411\u0414 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 SQL-\u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0438 \u0441\u043e\u0432\u043c\u0435\u0441\u0442\u0438\u043c\u0430 \u0441 MySQL \u043d\u0430 \u0443\u0440\u043e\u0432\u043d\u0435 \u043a\u043b\u0438\u0435\u043d\u0442\u0441\u043a\u0438\u0445 \u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441\u043e\u0432. \u041a\u043e\u0434 \u043f\u0440\u043e\u0435\u043a\u0442\u0430 \u043d\u0430\u043f\u0438\u0441\u0430\u043d \u043d\u0430 \u044f\u0437\u044b\u043a\u0435 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":99376,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-99375","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\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\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47A Dolt adatb\u00e1zis-kezel\u0151 rendszer, amely lehet\u0151v\u00e9 teszi az adatok manipul\u00e1l\u00e1s\u00e1t Git-st\u00edlusban | ProHoster","description":"A Dolt projekt egy olyan adatb\u00e1zis-kezel\u0151 rendszert fejleszt, amely \u00f6tv\u00f6zi az SQL t\u00e1mogat\u00e1s\u00e1t az adatok Git-st\u00edlus\u00fa verzi\u00f3kezel\u00e9s\u00e9vel.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","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\u0421\u0423\u0411\u0414 Dolt, \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0430\u044f \u043c\u0430\u043d\u0438\u043f\u0443\u043b\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0434\u0430\u043d\u043d\u044b\u043c\u0438 \u0432 \u0441\u0442\u0438\u043b\u0435 Git | ProHoster","og:description":"\u041f\u0440\u043e\u0435\u043a\u0442 Dolt \u0440\u0430\u0437\u0432\u0438\u0432\u0430\u0435\u0442 \u0421\u0423\u0411\u0414, \u0441\u043e\u0447\u0435\u0442\u0430\u044e\u0449\u0443\u044e \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0443 SQL \u0441\u043e \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430\u043c\u0438 \u0432\u0435\u0440\u0441\u0438\u043e\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0441\u0442\u0438\u043b\u0435 Git.","og:url":"https:\/\/prohoster.info\/hu\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","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":"2021-03-07T14:22:43+00:00","article:modified_time":"2021-03-07T14:22:43+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"99375","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":null,"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":"2021-03-07 14:23:17","updated":"2026-02-22 15:29:52","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\/99375","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=99375"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/99375\/revisions"}],"predecessor-version":[{"id":162225,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/99375\/revisions\/162225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/99376"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=99375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=99375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=99375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}