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

Projekti Dolt po zhvillon nj\u00eb DBMS q\u00eb kombinon mb\u00ebshtetje SQL me mjete p\u00ebr versionimin e t\u00eb dh\u00ebnave n\u00eb stilin Git. Dolt lejon klonimin e tabelave, krijimin e fork-ve dhe kryerjen e bashkimeve t\u00eb tabelave, si dhe operacione push dhe pull n\u00eb m\u00ebnyr\u00eb t\u00eb ngjashme me veprimet n\u00eb nj\u00eb depo git. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, DBMS mb\u00ebshtet k\u00ebrkesa SQL dhe \u00ebsht\u00eb e p\u00ebrputhshme me MySQL n\u00eb nivelin e nd\u00ebrfaqeve klient. 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 e versionimit t\u00eb t\u00eb dh\u00ebnave n\u00eb DB lejojn\u00eb t\u00eb gjurmohet origjina e t\u00eb dh\u00ebnave \u2014 lidhja me komitetet ofron mund\u00ebsin\u00eb p\u00ebr t\u00eb fiksuar gjendjen p\u00ebr t\u00eb marr\u00eb rezultate identike, t\u00eb cilat 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 p\u00ebrmes historis\u00eb, t\u00eb gjurmojn\u00eb ndryshimet n\u00eb tabela duke p\u00ebrdorur 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 p\u00ebrfshijn\u00eb t\u00eb dh\u00ebnat n\u00eb nj\u00eb moment t\u00eb caktuar.

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

SGBD ofron dy moda operimi \u2014 Offline dhe Online. Pas kalimit n\u00eb offline, p\u00ebrmbajtja e DB b\u00ebhet disponibile si nj\u00eb depo, me t\u00eb cil\u00ebn mund t\u00eb kryhen veprime duke p\u00ebrdorur nj\u00eb utilitar komand\u00eb t\u00eb ngjash\u00ebm me git. Funksionimi kujton shum\u00eb git-in dhe ndryshon kryesisht n\u00eb at\u00eb q\u00eb ndryshimet nuk gjurmohen p\u00ebr skedar\u00ebt, por p\u00ebr p\u00ebrmbajtjen e tabelave. N\u00ebp\u00ebrmjet nd\u00ebrfaqes CLI t\u00eb ofruar, mund t\u00eb importoni t\u00eb dh\u00ebna nga skedar\u00eb n\u00eb format CSV ose JSON, t\u00eb shtoni komitete me ndryshime, t\u00eb shfaqni diferencat mes versioneve, t\u00eb krijoni deg\u00eb, t\u00eb vendosni etiketa, t\u00eb kryeni k\u00ebrkesa push ndaj server\u00ebve t\u00eb jasht\u00ebm dhe t\u00eb realizoni bashk\u00ebngjitje ndryshimesh t\u00eb propozuara nga pjes\u00ebmarr\u00ebs t\u00eb tjer\u00eb. <\/p>\n

N\u00ebse d\u00ebshirohet, t\u00eb dh\u00ebnat mund t\u00eb strehohen n\u00eb katalogun DoltHub, i cili mund t\u00eb konsiderohet si nj\u00eb ekuivalent i GitHub p\u00ebr strehuar t\u00eb dh\u00ebna dhe bashk\u00ebpunim mbi to. P\u00ebrdoruesit mund t\u00eb krijojn\u00eb fork-e t\u00eb depozitat e t\u00eb dh\u00ebnave, t\u00eb propozojn\u00eb ndryshimet e tyre dhe t\u00eb realizojn\u00eb bashkime me t\u00eb dh\u00ebnat e tyre. P\u00ebr shembull, n\u00eb DoltHub mund t\u00eb gjenden disa DB me statistik\u00eb mbi coronavirus, koleksione t\u00eb dh\u00ebnash t\u00eb annotuar p\u00ebr sistema t\u00eb m\u00ebsimit t\u00eb makinerive, baza leksikore t\u00eb gjuh\u00ebve, koleksione imazhesh, sete p\u00ebr klasifikimin e objekteve dhe informacion mbi p\u00ebrkat\u00ebsin\u00eb. IP-adresat<\/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 e ngjashme me MySQL dhe mund t\u00eb p\u00ebrdoret p\u00ebrmes lidhjeve 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 p\u00ebrpunimin e k\u00ebrkesave. P\u00ebr shembull, sipas rregullave, serveri SQL mund t\u00eb trajtoj\u00eb vet\u00ebm nj\u00eb lidhje aktive t\u00eb p\u00ebrdoruesit n\u00eb depo, e vendosur n\u00eb direktorin\u00eb aktuale (k\u00ebto sjellje mund t\u00eb ndryshohen p\u00ebrmes konfigurimeve). server\u00eb<\/a> n\u00eb modalitetin 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 b\u00ebhen komitet ose t\u00eb kaloni 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-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\udd47DBMS Dolt, e cila lejon manipulimin e t\u00eb dh\u00ebnave n\u00eb stilin Git | ProHoster","description":"Projekti Dolt zhvillon nj\u00eb DBMS q\u00eb kombinon mb\u00ebshtetje SQL me mjete versionimi t\u00eb dh\u00ebnash n\u00eb stilin Git.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/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.","og:url":"https:\/\/prohoster.info\/sq\/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\/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}]}}