{"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\/sq\/blog\/novosti-interneta\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","title":{"rendered":"DB Dolt, e cila lejon manipulimin e t\u00eb dh\u00ebnave n\u00eb stilin Git","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Projekti Dolt zhvillon nj\u00eb SGBD q\u00eb kombinon mb\u00ebshtetje p\u00ebr SQL me mjete versionimi t\u00eb dh\u00ebnash n\u00eb stilin Git. Dolt lejon klonimin e tabelave, krijimin e forkeve dhe bashkimin e tabelave, si dhe kryerjen e operacioneve push dhe pull n\u00eb m\u00ebnyr\u00eb analogjike me veprimet n\u00eb nj\u00eb depo git. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, SGBD mb\u00ebshtet k\u00ebrkesat SQL dhe \u00ebsht\u00eb e pajtueshme me MySQL n\u00eb nivelin e nd\u00ebrfaqeve klientike. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Go dhe shp\u00ebrndahet n\u00ebn licenc\u00ebn Apache 2.0. <\/p>\n

Mund\u00ebsit\u00eb p\u00ebr versionimin e t\u00eb dh\u00ebnave n\u00eb DB lejojn\u00eb t\u00eb ndjekin origjin\u00ebn e t\u00eb dh\u00ebnave \u2014 lidhja me commit-et ofron mund\u00ebsin\u00eb p\u00ebr t\u00eb fiksuar gjendjen p\u00ebr t\u00eb marr\u00eb rezultate identike, q\u00eb pavar\u00ebsisht nga gjendja aktuale mund t\u00eb p\u00ebrs\u00ebriten n\u00eb sisteme t\u00eb tjera n\u00eb \u00e7do koh\u00eb. P\u00ebr m\u00eb tep\u00ebr, p\u00ebrdoruesit mund t\u00eb l\u00ebvizin n\u00ebp\u00ebr histori, t\u00eb ndjekin ndryshimet n\u00eb tabela p\u00ebrmes SQL pa nevoj\u00ebn p\u00ebr t\u00eb krahasuar kopjet rezerv\u00eb, t\u00eb kryejn\u00eb auditimin e ndryshimeve, si dhe t\u00eb formulojn\u00eb pyetje q\u00eb mbulojn\u00eb t\u00eb dh\u00ebnat n\u00eb nj\u00eb moment t\u00eb caktuar.

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

SUBD ofron dy m\u00ebnyra pune \u2014 Offline dhe Online. Pas kalimit n\u00eb offline, p\u00ebrmbajtja e DB b\u00ebhet e disponueshme si nj\u00eb repo, me t\u00eb cil\u00ebn mund t\u00eb kryhen veprime duke p\u00ebrdorur nj\u00eb mjet t\u00eb komand\u00ebs t\u00eb ngjash\u00ebm me git. Puna n\u00eb shum\u00eb aspekte ngjan me git dhe ndryshon kryesisht n\u00eb at\u00eb q\u00eb ndryshimet ndjekin nuk jan\u00eb p\u00ebr skedar\u00eb, por p\u00ebr p\u00ebrmbajtjen e tabelave. P\u00ebrmes nd\u00ebrfaqes CLI t\u00eb ofruar, mund t\u00eb importoni t\u00eb dh\u00ebna nga skedar\u00eb n\u00eb formato CSV ose JSON, t\u00eb shtoni commit-e me ndryshime, t\u00eb nxirrni dallime midis versioneve, t\u00eb krijoni dega, t\u00eb vendosni etiketa, t\u00eb kryeni k\u00ebrkesa push p\u00ebr server\u00eb t\u00eb jasht\u00ebm dhe t\u00eb realizoni bashkime ndryshimesh t\u00eb propozuara nga pjes\u00ebmarr\u00ebs t\u00eb tjer\u00eb. <\/p>\n

N\u00ebse d\u00ebshirojn\u00eb, t\u00eb dh\u00ebnat mund t\u00eb vendosen n\u00eb katalogun DoltHub, i cili mund t\u00eb shqyrtohet si nj\u00eb analog i GitHub p\u00ebr vendosjen e t\u00eb dh\u00ebnave dhe p\u00ebr bashk\u00ebpunimin mbi to. P\u00ebrdoruesit mund t\u00eb krijojn\u00eb forke t\u00eb depozita me t\u00eb dh\u00ebna, t\u00eb propozojn\u00eb ndryshimet e tyre dhe t\u00eb kryejn\u00eb bashkime me t\u00eb dh\u00ebnat e tyre. P\u00ebr shembull, n\u00eb DoltHub mund t\u00eb gjenden BD t\u00eb ndryshme me statistika mbi coronavirusin, koleksione t\u00eb dh\u00ebnash t\u00eb annotuara p\u00ebr sisteme m\u00ebsimi makinerik, bazat leksikore t\u00eb gjuh\u00ebve, koleksione imazhesh, grupe p\u00ebr klasifikimin e objekteve dhe informacion mbi p\u00ebrkat\u00ebsin\u00eb. IP-adresave<\/a>. <\/p>\n

N\u00eb modalitetin \u00abonline\u00bb aktivizohet Dolt SQL Server, i cili lejon manipulimin e t\u00eb dh\u00ebnave duke p\u00ebrdorur gjuh\u00ebn SQL. Nd\u00ebrfaqja e ofruar \u00ebsht\u00eb af\u00ebr MySQL dhe mund t\u00eb p\u00ebrdoret p\u00ebrmes lidhjes me klient\u00eb t\u00eb p\u00ebrputhsh\u00ebm me MySQL ose p\u00ebrmes nd\u00ebrfaqes CLI. N\u00eb k\u00ebt\u00eb rast, Dolt \u00ebsht\u00eb m\u00eb shum\u00eb nj\u00eb mjet p\u00ebr manipulimin e t\u00eb dh\u00ebnave sesa nj\u00eb sistem p\u00ebr procesimin e k\u00ebrkesave. P\u00ebr shembull, n\u00eb m\u00ebnyr\u00eb default serveri SQL mund t\u00eb procesoj\u00eb vet\u00ebm nj\u00eb lidhje aktive p\u00ebrdoruesi me repo-n\u00eb e vendosur n\u00eb drejtorin\u00eb aktuale (kjo sjellje mund t\u00eb ndryshohet p\u00ebrmes konfigurimeve). server<\/a> n\u00eb nj\u00eb mod t\u00eb vet\u00ebm p\u00ebr lexim. Shum\u00eb veprime t\u00eb lidhura me menaxhimin e versioneve gjithashtu mund t\u00eb kryhen p\u00ebrmes SQL, p\u00ebr shembull, t\u00eb kryhen commit-e ose t\u00eb kalojn\u00eb midis deg\u00ebve.
\n
Burimi: 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-novosti-interneta"],"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\udd47SGBD Dolt, q\u00eb lejon manipulimin e t\u00eb dh\u00ebnave n\u00eb stilin Git | ProHoster","description":"Projekti Dolt zhvillon nj\u00eb SGBD q\u00eb kombinon mb\u00ebshtetje p\u00ebr SQL me mjete versionimi t\u00eb dh\u00ebnash n\u00eb stilin Git. Dolt lejon klonimin e tabelave, krijimin e forkeve dhe bashkimin e tabelave, si dhe kryerjen e operacioneve push dhe pull n\u00eb m\u00ebnyr\u00eb analogjike me veprimet n\u00eb nj\u00eb depo git. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, SGBD mb\u00ebshtet k\u00ebrkesat SQL dhe \u00ebsht\u00eb e pajtueshme me MySQL n\u00eb nivelin e nd\u00ebrfaqeve klientike. Kodi i projektit \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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. 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","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/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\/sq\/wp-json\/wp\/v2\/posts\/99375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=99375"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/99375\/revisions"}],"predecessor-version":[{"id":162225,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/99375\/revisions\/162225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/99376"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=99375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=99375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=99375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}