{"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\/pt\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","title":{"rendered":"O SGBD Dolt, que permite manipular dados no estilo Git.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

O projeto Dolt desenvolve um SGBD que combina suporte SQL com recursos de versionamento de dados ao estilo Git. O Dolt permite clonar tabelas, criar forks e realizar merges de tabelas, al\u00e9m de opera\u00e7\u00f5es de push e pull, semelhante \u00e0s a\u00e7\u00f5es em um reposit\u00f3rio git. Ao mesmo tempo, o SGBD suporta consultas SQL e \u00e9 compat\u00edvel com MySQL em n\u00edvel de interfaces de cliente. O c\u00f3digo do projeto \u00e9 escrito na linguagem Go e \u00e9 distribu\u00eddo sob a licen\u00e7a Apache 2.0. <\/p>\n

As capacidades de versionamento de dados em bancos de dados permitem rastrear a origem dos dados \u2014 a vincula\u00e7\u00e3o a commits possibilita fixar um estado que pode ser reproduzido a qualquer momento em outros sistemas, independentemente do estado atual. Al\u00e9m disso, os usu\u00e1rios podem navegar pelo hist\u00f3rico, acompanhar altera\u00e7\u00f5es em tabelas usando SQL sem a necessidade de verificar backups, realizar auditorias de mudan\u00e7as e gerar consultas que abrangem dados em um determinado momento.

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

O SGBD oferece dois modos de opera\u00e7\u00e3o \u2014 Offline e Online. Ap\u00f3s a mudan\u00e7a para offline, o conte\u00fado do banco de dados se torna acess\u00edvel como um reposit\u00f3rio, com o qual podem ser realizadas a\u00e7\u00f5es utilizando uma ferramenta de linha de comando semelhante ao git. O funcionamento \u00e9 bastante semelhante ao git e se diferencia principalmente pelo fato de que as altera\u00e7\u00f5es s\u00e3o rastreadas n\u00e3o para arquivos, mas para o conte\u00fado das tabelas. Atrav\u00e9s da interface CLI oferecida, \u00e9 poss\u00edvel importar dados de arquivos nos formatos CSV ou JSON, adicionar commits com altera\u00e7\u00f5es, exibir diferen\u00e7as entre vers\u00f5es, criar branches, estabelecer tags, executar push requests para servidores externos e mesclar altera\u00e7\u00f5es propostas por outros participantes. <\/p>\n

Se desejado, os dados podem ser hospedados no diret\u00f3rio DoltHub, que pode ser considerado como um an\u00e1logo ao GitHub para o armazenamento de dados e colabora\u00e7\u00e3o em dados. Os usu\u00e1rios podem criar forks de reposit\u00f3rios de dados, sugerir suas altera\u00e7\u00f5es e realizar merges com seus dados. Por exemplo, no DoltHub, \u00e9 poss\u00edvel encontrar diversos bancos de dados com estat\u00edsticas sobre coronav\u00edrus, cole\u00e7\u00f5es de dados anotados para sistemas de aprendizado de m\u00e1quina, bases lexicais de idiomas, cole\u00e7\u00f5es de imagens, conjuntos para classifica\u00e7\u00e3o de objetos e informa\u00e7\u00f5es sobre propriedade. endere\u00e7os IP<\/a>. <\/p>\n

No modo \u2018online\u2019, \u00e9 iniciado o Dolt SQL Server, que permite manipular dados usando a linguagem SQL. A interface fornecida \u00e9 semelhante ao MySQL e pode ser usada atrav\u00e9s da conex\u00e3o com clientes compat\u00edveis com MySQL ou atrav\u00e9s da interface CLI. Al\u00e9m disso, o Dolt \u00e9 mais uma ferramenta para manipula\u00e7\u00e3o de dados do que um sistema de processamento de consultas. Por exemplo, por padr\u00e3o, o servidor SQL pode processar apenas uma conex\u00e3o ativa de usu\u00e1rio ao reposit\u00f3rio localizado no diret\u00f3rio atual (esse comportamento pode ser alterado nas configura\u00e7\u00f5es). \u00c9 poss\u00edvel fazer a mudan\u00e7a. servidor<\/a> para o modo somente leitura. Muitas a\u00e7\u00f5es relacionadas ao gerenciamento de vers\u00f5es tamb\u00e9m podem ser realizadas via SQL, por exemplo, realizar commits ou alternar entre ramos.
\n
Fonte: 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\udd47SGBD Dolt, permitindo manipular dados no estilo Git | ProHoster","description":"O projeto Dolt desenvolve um SGBD que combina suporte a SQL com recursos de versionamento de dados no estilo Git.","canonical_url":"https:\/\/prohoster.info\/pt\/blog\/news\/subd-dolt-pozvolyayushhaya-manipulirovat-dannymi-v-stile-git","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"pt_PT","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\/pt\/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\/pt\/wp-json\/wp\/v2\/posts\/99375","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/comments?post=99375"}],"version-history":[{"count":2,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/99375\/revisions"}],"predecessor-version":[{"id":162225,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/posts\/99375\/revisions\/162225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media\/99376"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/media?parent=99375"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/categories?post=99375"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/pt\/wp-json\/wp\/v2\/tags?post=99375"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}