{"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\/hr\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","title":{"rendered":"DBMS Dolt, koji omogu\u0107uje manipulaciju podacima na na\u010din Git","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Dolt projekt razvija sustav za upravljanje bazama podataka koji kombinira podr\u0161ku za SQL s verzioniranjem podataka u stilu Gita. Dolt omogu\u0107uje kloniranje tablica, stvaranje forkova i izvr\u0161avanje spajanja tablica, kao i provo\u0111enje operacija push i pull, sli\u010dno radnjama u git repozitoriju. Sustav podr\u017eava SQL upite i kompatibilan je s MySQL na razini korisni\u010dkih su\u010delja. Kod projekta napisan je na jeziku Go i distribuira se pod Apache 2.0 licencom. <\/p>\n

Mogu\u0107nosti verzioniranja podataka u Bazi podataka omogu\u0107uju pra\u0107enje porijekla podataka \u2014 povezanost s commit-ima omogu\u0107ava fiksiranje stanja kako bi se postigli identi\u010dni rezultati koji se mogu ponoviti na drugim sustavima neovisno o trenutnom stanju. Osim toga, korisnici mogu pregledavati povijest, pratiti promjene u tablicama pomo\u0107u SQL-a bez potrebe za usporedba rezervnih kopija, provesti reviziju promjena, kao i formirati upite koji obuhva\u0107aju podatke u odre\u0111enom trenutku.

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

Sustav za upravljanje bazama podataka nudi dva na\u010dina rada \u2014 Offline i Online. Nakon prijelaza u offline, sadr\u017eaj Baze podataka postaje dostupan kao repozitorij, s kojim se mogu izvoditi radnje pomo\u0107u git-sli\u010dnog alata za naredbeni redak. Rad nalikuje gitu, a glavno se razlikuje time \u0161to se promjene prate ne za datoteke, ve\u0107 za sadr\u017eaj tablica. Kroz ponu\u0111eni CLI su\u010delje mogu se uvoziti podaci iz datoteka u CSV ili JSON formatu, dodavati commit s promjenama, prikazivati razlike izme\u0111u verzija, kreirati grane, postavljati oznake, slati push zahtjeve vanjskim poslu\u017eiteljima i spajati promjene koje su predlo\u017eili drugi sudionici. <\/p>\n

Po \u017eelji, podaci se mogu pohraniti u katalogu DoltHub, koji se mo\u017ee smatrati ekvivalentom GitHub-u za pohranu podataka i suradnju na podacima. Korisnici mogu stvarati forkove repozitorija s podacima, predlagati svoje promjene i provoditi spajanja s vlastitim podacima. Na primjer, u DoltHubu se mogu prona\u0107i razli\u010dite baze podataka sa statistikama o koronavirusu, kolekcije anotiranih podataka za sustave strojnog u\u010denja, leksikoni jezika, kolekcije slika, skupovi za klasifikaciju objekata i informacije o pripadnosti. IP adresa<\/a>. <\/p>\n

U re\u017eimu \u201eonline\u201d pokre\u0107e se Dolt SQL Server, koji omogu\u0107uje manipulaciju podacima pomo\u0107u SQL jezika. Pru\u017eeno su\u010delje je blisko MySQL-u i mo\u017ee se koristiti kroz povezivanje s kompatibilnim MySQL klijentima ili putem CLI su\u010delja. Pri tome, Dolt je vi\u0161e alat za manipulaciju podacima nego sustav za obradu upita. Na primjer, prema zadanim postavkama, SQL poslu\u017eitelj mo\u017ee obraditi samo jedno aktivno korisni\u010dko povezivanje s repozitorijem smje\u0161tenim u trenutnom direktoriju (putem postavki se ovo pona\u0161anje mo\u017ee promijeniti). poslu\u017eitelja<\/a> u na\u010din samo za \u010ditanje. Mnoge radnje vezane uz upravljanje verzijama tako\u0111er se mogu izvr\u0161iti putem SQL-a, na primjer, izvo\u0111enje komitacija ili prebacivanje izme\u0111u grana.
\n
Izvor: 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, koji omogu\u0107ava manipulaciju podacima u stilu Gita | ProHoster","description":"Projekt Dolt razvija DBMS koji kombinira podr\u0161ku za SQL sa sredstvima za verzioniranje podataka u stilu Gita.","canonical_url":"https:\/\/prohoster.info\/hr\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hr_HR","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\/hr\/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\/hr\/wp-json\/wp\/v2\/posts\/99375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/comments?post=99375"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/99375\/revisions"}],"predecessor-version":[{"id":162225,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/posts\/99375\/revisions\/162225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media\/99376"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/media?parent=99375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/categories?post=99375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hr\/wp-json\/wp\/v2\/tags?post=99375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}