{"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\/et\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","title":{"rendered":"Andmebaas Dolt, mis v\u00f5imaldab andmetega manipuleerida Git-stiilis","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Dolt projekt arendab andmebaasis\u00fcsteemi, mis \u00fchendab SQL toetuse Git-stiilis andmeversioonimise v\u00f5imalustega. Dolt v\u00f5imaldab tabelite kloonimist, harude loomist ja tabelite \u00fchinemist ning teostada push ja pull operatsioone sarnaselt git-repositooriumite tegevustega. Samuti toetab andmebaasis\u00fcsteem SQL-p\u00e4ringuid ja on MySQL-ga \u00fchilduv kliendi liidese tasemel. Projekti kood on kirjutatud Go keeles ja levitatakse Apache 2.0 litsentsi alusel. <\/p>\n

Andmebaasi versioonimisv\u00f5imalused v\u00f5imaldavad j\u00e4lgida andmete p\u00e4ritolu \u2014 seondumine commit'itega annab v\u00f5imaluse fikseerida olek, mille tulemused v\u00f5ivad igal ajal olla korratav teistes s\u00fcsteemides, olenemata praegusest seisundist. Lisaks saavad kasutajad liikuda ajaloos, j\u00e4lgida tabelite muudatusi SQL abil ilma varukoopiate v\u00f5rreldamise vajaduseta, teostada muudatuste auditeerimist ning koostada p\u00e4ringuid, mis h\u00f5lmavad andmeid teatud hetkel.

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

Andmebaasis\u00fcsteem pakub kahte t\u00f6\u00f6re\u017eiimi \u2014 Offline ja Online. P\u00e4rast offline-olekusse \u00fcleminekut muutub andmebaasi sisu k\u00e4tte saadavaks kui hoidla, millega saab teostada toiminguid git-taolise k\u00e4surea utiliidiga. T\u00f6\u00f6 sarnaneb palju git-iga ja erineb peamiselt selles, et muudatusi j\u00e4lgitakse mitte failide, vaid tabelite sisu osas. Pakutava CLI-liidese kaudu saab importida andmeid CSV v\u00f5i JSON formaadis failidest, lisada muudatuste commit'e, tuua v\u00e4lja erinevused versioonide vahel, luua harusid, seadistada silte, teha v\u00e4listele serveritele push-p\u00e4ringuid ja rakendada teiste osalejate esitatud muudatuste sulandumisi. <\/p>\n

Soovi korral saavad andmed paikneda DoltHub kataloogis, mida v\u00f5ib pidada andmete majutamise ja koost\u00f6\u00f6 platvormiks, nagu GitHub. Kasutajad saavad luua andmerepostite haru, pakkuda oma muudatusi ja teostada \u00fchinemisi oma andmetega. N\u00e4iteks v\u00f5ib DoltHub'is leida erinevaid andmebaase koronaviiruse statistika, masin\u00f5ppe s\u00fcsteemide jaoks m\u00e4rgistatud andmete kogumite, keeleliste leksikaalsete andmebaaside, pildi kogumite, objektide klassifitseerimise komplektide ja kuuluvusinfo kohta. IP-aadresse<\/a>. <\/p>\n

Online-re\u017eiimis k\u00e4ivitub Dolt SQL Server, mis v\u00f5imaldab andmete manipuleerimist SQL-keele abil. Pakutav liides on sarnane MySQL-iga ja seda saab kasutada \u00fchilduvate MySQL kliendide kaudu v\u00f5i CLI-liidese abil. Sellegipoolest on Dolt pigem andmete manipuleerimise t\u00f6\u00f6riist kui p\u00e4ringute t\u00f6\u00f6tlemise s\u00fcsteem. N\u00e4iteks suudab vaikimisi SQL-server hallata ainult \u00fchte aktiivset kasutaja\u00fchendust hoidla jaoks, mis asub praeguses kataloogis (seda k\u00e4itumist saab seadete kaudu muuta). serverid<\/a> ainult lugemisre\u017eiimile. Paljusid versioonihaldusega seotud toiminguid saab samuti teha SQL-i kaudu, n\u00e4iteks sooritada commit'e v\u00f5i vahetada harusid.
\n
Allikas: 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\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\udd47Andmebaasis\u00fcsteem Dolt, mis v\u00f5imaldab andmeta manipuleerimist Git-stiilis | ProHoster","description":"Dolt projekt arendab andmebaasis\u00fcsteemi, mis \u00fchendab SQL-i toe ja andmete versioonihalduse Git-sarnaselt.","canonical_url":"https:\/\/prohoster.info\/et\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","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\/et\/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\/et\/wp-json\/wp\/v2\/posts\/99375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=99375"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/99375\/revisions"}],"predecessor-version":[{"id":162225,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/99375\/revisions\/162225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/99376"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=99375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=99375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=99375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}