{"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\/cs\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","title":{"rendered":"Datab\u00e1ze Dolt, umo\u017e\u0148uj\u00edc\u00ed manipulaci s daty stylem Git.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Projekt Dolt vyv\u00edj\u00ed datab\u00e1zov\u00fd syst\u00e9m, kter\u00fd kombinuje podporu SQL s prost\u0159edky pro verzov\u00e1n\u00ed dat ve stylu Git. Dolt umo\u017e\u0148uje klonov\u00e1n\u00ed tabulek, vytv\u00e1\u0159en\u00ed fork\u016f a prov\u00e1d\u011bn\u00ed slou\u010den\u00ed tabulek a tak\u00e9 prov\u00e1d\u011bn\u00ed operac\u00ed push a pull analogicky k akc\u00edm v git repozit\u00e1\u0159i. Tento datab\u00e1zov\u00fd syst\u00e9m podporuje SQL dotazy a je kompatibiln\u00ed s MySQL na \u00farovni klientsk\u00fdch rozhran\u00ed. K\u00f3d projektu je naps\u00e1n v jazyce Go a je distribuov\u00e1n pod licenc\u00ed Apache 2.0. <\/p>\n

Mo\u017enosti verzov\u00e1n\u00ed dat v datab\u00e1zi umo\u017e\u0148uj\u00ed sledovat p\u016fvod dat \u2013 propojen\u00ed s commity d\u00e1v\u00e1 mo\u017enost fixovat stav pro z\u00edsk\u00e1n\u00ed shodn\u00fdch v\u00fdsledk\u016f, kter\u00e9 mohou b\u00fdt kdykoliv nez\u00e1visle na aktu\u00e1ln\u00edm stavu opakov\u00e1ny na jin\u00fdch syst\u00e9mech. D\u00e1le mohou u\u017eivatel\u00e9 proch\u00e1zet histori\u00ed, sledovat zm\u011bny v tabulk\u00e1ch pomoc\u00ed SQL bez nutnosti porovn\u00e1vat z\u00e1lohy, prov\u00e1d\u011bt audit zm\u011bn a vytv\u00e1\u0159et dotazy pokr\u00fdvaj\u00edc\u00ed data k ur\u010dit\u00e9mu okam\u017eiku.

\"Datab\u00e1ze<\/center> <\/p>\n

Syst\u00e9m spr\u00e1vy datab\u00e1z\u00ed poskytuje dva re\u017eimy provozu \u2013 Offline a Online. Po p\u0159epnut\u00ed do offline re\u017eimu se obsah datab\u00e1ze st\u00e1v\u00e1 dostupn\u00fdm jako repozit\u00e1\u0159, se kter\u00fdm lze prov\u00e1d\u011bt akce pomoc\u00ed git-podobn\u00e9ho p\u0159\u00edkazov\u00e9ho rozhran\u00ed. Pr\u00e1ce do zna\u010dn\u00e9 m\u00edry p\u0159ipom\u00edn\u00e1 git a li\u0161\u00ed se hlavn\u011b t\u00edm, \u017ee zm\u011bny se sleduj\u00ed nikoli pro soubory, ale pro obsah tabulek. Prost\u0159ednictv\u00edm nab\u00edzen\u00e9ho CLI rozhran\u00ed m\u016f\u017eete importovat data ze soubor\u016f ve form\u00e1tu CSV nebo JSON, p\u0159id\u00e1vat commity se zm\u011bnami, zobrazovat rozd\u00edly mezi verzemi, vytv\u00e1\u0159et v\u011btve, nastavovat zna\u010dky, prov\u00e1d\u011bt push-p\u0159\u00edkazy k extern\u00edm server\u016fm a prov\u00e1d\u011bt slou\u010den\u00ed zm\u011bn navrhovan\u00fdch jin\u00fdmi \u00fa\u010dastn\u00edky. <\/p>\n

Pokud si p\u0159ejete, data mohou b\u00fdt um\u00edst\u011bna v adres\u00e1\u0159i DoltHub, kter\u00fd lze pova\u017eovat za analogii GitHubu pro um\u00edst\u011bn\u00ed dat a spolupr\u00e1ci s daty. U\u017eivatel\u00e9 mohou vytv\u00e1\u0159et forky repozit\u00e1\u0159\u016f s daty, navrhovat sv\u00e9 zm\u011bny a prov\u00e1d\u011bt slou\u010den\u00ed se sv\u00fdmi daty. Nap\u0159\u00edklad, na DoltHubu m\u016f\u017eete naj\u00edt r\u016fzn\u00e9 datab\u00e1ze se statistikou o koronaviru, kolekcemi anotovan\u00fdch dat pro syst\u00e9my strojov\u00e9ho u\u010den\u00ed, jazykov\u00fdmi lexik\u00e1ln\u00edmi datab\u00e1zemi, kolekcemi obr\u00e1zk\u016f, soubory pro klasifikaci objekt\u016f a informacemi o p\u0159\u00edslu\u0161nosti. IP adress<\/a>. <\/p>\n

V re\u017eimu \u201eonline\u201c se spou\u0161t\u00ed Dolt SQL Server, kter\u00fd umo\u017e\u0148uje manipulovat s daty pomoc\u00ed jazyka SQL. Poskytovan\u00e9 rozhran\u00ed je bl\u00edzk\u00e9 MySQL a m\u016f\u017ee b\u00fdt pou\u017e\u00edv\u00e1no prost\u0159ednictv\u00edm p\u0159ipojen\u00ed kompatibiln\u00edch s MySQL klient\u016f nebo pomoc\u00ed CLI rozhran\u00ed. Dolt je sp\u00ed\u0161e n\u00e1strojem pro manipulaci s daty ne\u017e syst\u00e9mem zpracov\u00e1n\u00ed dotaz\u016f. Nap\u0159\u00edklad, ve v\u00fdchoz\u00edm nastaven\u00ed SQL server m\u016f\u017ee zpracov\u00e1vat pouze jedno aktivn\u00ed u\u017eivatelsk\u00e9 p\u0159ipojen\u00ed k repozit\u00e1\u0159i um\u00edst\u011bn\u00e9mu v aktu\u00e1ln\u00edm adres\u00e1\u0159i (chov\u00e1n\u00ed lze zm\u011bnit v nastaven\u00ed). P\u0159evod je mo\u017en\u00fd. serveru<\/a> Mo\u017en\u00fd p\u0159evod do re\u017eimu pouze pro \u010dten\u00ed. Mnoho akc\u00ed spojen\u00fdch s \u0159\u00edzen\u00edm verz\u00ed lze tak\u00e9 prov\u00e1d\u011bt prost\u0159ednictv\u00edm SQL, nap\u0159\u00edklad prov\u00e1d\u011bt commity nebo p\u0159ep\u00ednat mezi v\u011btvemi.
\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\udd47S\u0158BD Dolt, kter\u00fd umo\u017e\u0148uje manipulaci s daty v stylu Git | ProHoster","description":"Projekt Dolt vyv\u00edj\u00ed S\u0158BD, kter\u00fd kombinuje podporu SQL s prost\u0159edky pro verzov\u00e1n\u00ed dat v stylu Git.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","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\/cs\/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\/cs\/wp-json\/wp\/v2\/posts\/99375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=99375"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/99375\/revisions"}],"predecessor-version":[{"id":162225,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/99375\/revisions\/162225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/99376"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=99375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=99375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=99375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}