{"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\/sk\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","title":{"rendered":"DBMS Dolt, ktor\u00fd umo\u017e\u0148uje manipul\u00e1ciu s \u00fadajmi v \u0161t\u00fdle Git","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Projekt Dolt vyv\u00edja SDB, ktor\u00e1 kombinuje podporu SQL s prostriedkami verzionovania d\u00e1t v \u0161t\u00fdle Git. Dolt umo\u017e\u0148uje klonovanie tabuliek, vytv\u00e1ranie forks a vykon\u00e1vanie zl\u00fa\u010den\u00ed tabuliek, ako aj vykon\u00e1vanie oper\u00e1ci\u00ed push a pull podobne ako v git-repozit\u00e1ri. SDB pritom podporuje SQL dotazy a je kompatibiln\u00e1 s MySQL na \u00farovni klientskych rozhran\u00ed. K\u00f3d projektu je nap\u00edsan\u00fd v jazyku Go a je spr\u00edstupnen\u00fd pod licenciou Apache 2.0. <\/p>\n

Mo\u017enosti verzionovania d\u00e1t v DB umo\u017e\u0148uj\u00fa sledova\u0165 p\u00f4vod \u00fadajov \u2014 viazanie na commity umo\u017e\u0148uje fixova\u0165 stav na z\u00edskanie identick\u00fdch v\u00fdsledkov, ktor\u00e9 m\u00f4\u017eu by\u0165 kedyko\u013evek zopakovan\u00e9 na in\u00fdch syst\u00e9moch bez oh\u013eadu na aktu\u00e1lny stav. Okrem toho m\u00f4\u017eu pou\u017e\u00edvatelia prech\u00e1dza\u0165 hist\u00f3riou, sledova\u0165 zmeny v tabu\u013ek\u00e1ch pomocou SQL bez potreby kontroly z\u00e1loh, vykon\u00e1va\u0165 audit zmien a vytv\u00e1ra\u0165 dotazy pokr\u00fdvaj\u00face d\u00e1ta v ur\u010ditom momente.

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

DBMS poskytuje dva re\u017eimy pr\u00e1ce \u2014 Offline a Online. Po prechode do offline je obsah DB spr\u00edstupnen\u00fd ako repozit\u00e1r, s ktor\u00fdm je mo\u017en\u00e9 vykon\u00e1va\u0165 \u010dinnosti pomocou git-podobnej n\u00e1strojovej pr\u00edkazovej l\u00ednie. Pr\u00e1ca sa v mnohom podob\u00e1 gitu a l\u00ed\u0161i sa hlavne t\u00fdm, \u017ee zmeny sa sleduj\u00fa nie pre s\u00fabory, ale pre obsah tabuliek. Prostredn\u00edctvom pon\u00fakan\u00e9ho CLI rozhrania je mo\u017en\u00e9 importova\u0165 \u00fadaje zo s\u00faborov vo form\u00e1te CSV alebo JSON, prid\u00e1va\u0165 commity so zmenami, zobrazova\u0165 rozdiely medzi verziami, vytv\u00e1ra\u0165 vetvy, nastavova\u0165 zna\u010dky, vykon\u00e1va\u0165 push po\u017eiadavky na extern\u00e9 servery a vykon\u00e1va\u0165 zl\u00fa\u010denia zmien navrhnut\u00fdch in\u00fdmi \u00fa\u010dastn\u00edkmi. <\/p>\n

Pri \u017eelan\u00ed m\u00f4\u017eu by\u0165 d\u00e1ta umiestnen\u00e9 v adres\u00e1ri DoltHub, ktor\u00fd m\u00f4\u017eeme pova\u017eova\u0165 za anal\u00f3g GitHubu pre hosting d\u00e1t a spolupr\u00e1cu s d\u00e1tami. Pou\u017e\u00edvatelia m\u00f4\u017eu vytv\u00e1ra\u0165 forky repozit\u00e1rov d\u00e1t, navrhova\u0165 svoje zmeny a vykon\u00e1va\u0165 zl\u00fa\u010denia so svojimi d\u00e1tami. Napr\u00edklad, v DoltHub n\u00e1jdete r\u00f4zne datab\u00e1zy so \u0161tatistikami o koronav\u00edrusoch, kolekciami anotovan\u00fdch d\u00e1t pre syst\u00e9my strojov\u00e9ho u\u010denia, jazykov\u00fdmi lexik\u00e1lnymi datab\u00e1zami, kolekciami obr\u00e1zkov, s\u00fabormi pre klasifik\u00e1ciu objektov a inform\u00e1ciami o pr\u00edslu\u0161nosti. IP adresy<\/a>. <\/p>\n

V re\u017eime \u201eonline\u201c sa sp\u00fa\u0161\u0165a Dolt SQL Server, ktor\u00fd umo\u017e\u0148uje manipul\u00e1ciu s d\u00e1tami pomocou jazyka SQL. Poskytovan\u00e9 rozhranie je bl\u00edzke MySQL a m\u00f4\u017ee sa pou\u017e\u00edva\u0165 prostredn\u00edctvom pripojen\u00ed kompatibiln\u00fdch s MySQL klientmi alebo pomocou CLI rozhrania. Dolt je sk\u00f4r n\u00e1stroj na manipul\u00e1ciu s d\u00e1tami ne\u017e syst\u00e9m spracovania dotazov. Napr\u00edklad, predvolene SQL server m\u00f4\u017ee spracova\u0165 len jedno akt\u00edvne pripojenie pou\u017e\u00edvate\u013ea k repozit\u00e1ru umiestnen\u00e9mu v aktu\u00e1lnom adres\u00e1ri (cez nastavenia je mo\u017en\u00e9 toto spr\u00e1vanie zmeni\u0165). servera<\/a> do re\u017eimu iba na \u010d\u00edtanie. Mnoh\u00e9 \u010dinnosti spojen\u00e9 s riaden\u00edm verzi\u00ed je tie\u017e mo\u017en\u00e9 vykon\u00e1va\u0165 pomocou SQL, napr\u00edklad uskuto\u010d\u0148ova\u0165 commity alebo prech\u00e1dza\u0165 medzi vetvami.
\n
Zdroj: 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\udd47DBMS Dolt, ktor\u00e1 umo\u017e\u0148uje manipul\u00e1ciu s d\u00e1tami v \u0161t\u00fdle Git | ProHoster","description":"Projekt Dolt rozv\u00edja DBMS, ktor\u00e1 sp\u00e1ja podporu SQL s prostriedkami na verziovanie d\u00e1t v \u0161t\u00fdle Git.","canonical_url":"https:\/\/prohoster.info\/sk\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sk_SK","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\/sk\/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\/sk\/wp-json\/wp\/v2\/posts\/99375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/comments?post=99375"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/99375\/revisions"}],"predecessor-version":[{"id":162225,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/posts\/99375\/revisions\/162225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media\/99376"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/media?parent=99375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/categories?post=99375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sk\/wp-json\/wp\/v2\/tags?post=99375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}