{"id":3860,"date":"2017-07-24T08:36:32","date_gmt":"2017-07-24T15:36:32","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=3860"},"modified":"2022-07-06T06:31:37","modified_gmt":"2022-07-06T13:31:37","slug":"using-couchbase-r","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/pt\/using-couchbase-r\/","title":{"rendered":"Usando o Couchbase com o R"},"content":{"rendered":"<p>Tenho visto muito interesse na \u00e1rea sobre o uso do Couchbase com o R. \u00c9 uma integra\u00e7\u00e3o f\u00e1cil, portanto, aqui voc\u00ea tem alguns exemplos para come\u00e7ar a us\u00e1-lo agora mesmo.<\/p>\n<p>Para que voc\u00ea saiba um pouco mais, o R \u00e9 uma linguagem e um ambiente para computa\u00e7\u00e3o estat\u00edstica e gr\u00e1ficos. Voc\u00ea a encontrar\u00e1 nas primeiras posi\u00e7\u00f5es das classifica\u00e7\u00f5es das melhores linguagens para an\u00e1lise de dados, aprendizado de m\u00e1quina ou processamento de dados. Os cientistas de dados usam o R como uma de suas ferramentas mais poderosas.<\/p>\n<p>Para a ingest\u00e3o de dados, o R pode carregar arquivos em diferentes formatos, como csv, excel, html, texto simples e outros, com uma simples linha de comando. O R tamb\u00e9m pode carregar dados de sites remotos usando HTTP e pode trabalhar facilmente com JSON.<\/p>\n<p>Com tudo isso em mente, como podemos carregar dados do Couchbase para o R? Precisamos de um adaptador especial? N1QL \u00e9 a resposta. O mecanismo de consulta do Couchbase aceita solicita\u00e7\u00f5es REST, retornando documentos JSON, para que possamos importar dados diretamente para o R. N\u00e3o s\u00e3o necess\u00e1rios componentes adicionais.<\/p>\n<p>Aqui voc\u00ea tem alguns exemplos com dados do bucket \"travel-sample\", inclu\u00eddo no Couchbase como um conjunto de dados de exemplo. Estou usando aqui as vers\u00f5es R 3.4.1 e Couchbase 4.6.2.<\/p>\n<p>Como primeiro exerc\u00edcio, vamos carregar as 20 principais companhias a\u00e9reas com mais voos em nosso sistema. Carregaremos esses dados em um Data Frame do R, mostraremos os resultados no console e criaremos um gr\u00e1fico de barras simples.<\/p>\n<p>No lado do Couchbase, esta \u00e9 a consulta a ser executada:<\/p>\n<pre class=\"\">SELECT a.name, count(*) as total_flights\r\n\u00a0 FROM `travel-sample` r JOIN `travel-sample` a ON KEYS r.airlineid\r\n\u00a0 WHERE r.type =\"route\" AND a.type=\"airline\"\r\n\u00a0 GROUP BY a.name\r\n\u00a0 ORDER BY total_flights DESC\r\n\u00a0 LIMIT 20<\/pre>\n<p>Para o lado do R, usaremos o Console do R. Primeiro, precisamos importar as bibliotecas usadas neste exerc\u00edcio:<\/p>\n<pre class=\"lang:r decode:true\">library(httr)\r\nlibrary(jsonlite)\r\nlibrary(ggplot2)\r\nlibrary(leaflet)<\/pre>\n<p>A pr\u00f3xima etapa \u00e9 criar algumas vari\u00e1veis, incluindo o endere\u00e7o do n\u00f3 do Couchbase Query e a consulta. Observe as aspas duplas com escape (\\\"):<\/p>\n<pre class=\"wrap:true lang:r decode:true\">cbServer &lt;- \"https:\/\/cb451box:8093\/query\/service\"\r\nquery &lt;- \"SELECT a.name, count(*) as total_flights FROM `travel-sample` r JOIN `travel-sample` a ON KEYS r.airlineid WHERE r.type =\\\"route\\\" AND a.type=\\\"airline\\\" GROUP BY a.name ORDER BY total_flights DESC LIMIT 20\"<\/pre>\n<p>Em seguida, devemos criar a solicita\u00e7\u00e3o HTTP e ler a resposta no formato JSON:<\/p>\n<pre class=\"wrap:true lang:r decode:true\">req &lt;- httr::POST(cbServer, httr::add_headers(\"Content-Type\" = \"application\/x-www-form-urlencoded;charset=UTF-8\"), body = paste(\"statement=\", query))\r\nres &lt;- fromJSON(httr::content(req, \"text\"))<\/pre>\n<p><strong>OBSERVA\u00c7\u00c3O<\/strong>: Se voc\u00ea estiver usando um bucket protegido por senha, dever\u00e1 incluir credenciais como as seguintes:<\/p>\n<pre class=\"wrap:true lang:r decode:true\">creds &lt;- \"[{\\\"user\\\":\\\"local:bucketName\\\", \\\"pass\\\":\\\"password\\\"}]\"\r\nreq &lt;- httr::POST(cbServer, httr::add_headers(\"Content-Type\" = \"application\/x-www-form-urlencoded;charset=UTF-8\"), body =\u00a0paste(\"statement=\", query, \"&amp;creds=\", creds));<\/pre>\n<p>Em seguida, podemos salvar o resultado em uma vari\u00e1vel.<\/p>\n<pre class=\"lang:r decode:true\">airlineFlights &lt;- res$results<\/pre>\n<p>Para ver o valor, basta digitar o nome da vari\u00e1vel:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3862\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/07\/airlines_cmd-267x300.jpg\" alt=\"\" width=\"369\" height=\"415\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines_cmd-267x300.jpg 267w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines_cmd-300x337.jpg 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines_cmd-18x20.jpg 18w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines_cmd.jpg 554w\" sizes=\"auto, (max-width: 369px) 100vw, 369px\" \/><\/p>\n<p>Tamb\u00e9m podemos criar um gr\u00e1fico de barras usando a biblioteca ggplot:<\/p>\n<pre class=\"wrap:true lang:r decode:true\">ggplot(data=airlineFlights, aes(x=name, y=total_flights)) + theme(axis.text.x=element_text(angle=90,hjust=1)) + geom_bar(stat=\"identity\")<\/pre>\n<p>Este \u00e9 o resultado:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3861\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/07\/airlines-292x300.jpg\" alt=\"\" width=\"578\" height=\"593\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines-292x300.jpg 292w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines-996x1024.jpg 996w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines-1494x1536.jpg 1494w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines-50x50.jpg 50w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines-300x309.jpg 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines-20x20.jpg 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/airlines.jpg 1548w\" sizes=\"auto, (max-width: 578px) 100vw, 578px\" \/><\/p>\n<p>Como segundo exemplo, vamos pesquisar os hot\u00e9is que aceitam animais de estima\u00e7\u00e3o dispon\u00edveis em Londres e mostr\u00e1-los em um mapa. A consulta N1QL \u00e9 a seguinte:<\/p>\n<pre class=\"\">SELECT name,geo.lat as lat,geo.lon as long\r\nFROM `travel-sample`\r\nWHERE type=\"hotel\" AND city=\"London\" AND pets_ok=true<\/pre>\n<p>O c\u00f3digo R para executar a consulta e salvar os resultados:<\/p>\n<pre class=\"wrap:true lang:r decode:true\">query &lt;- \"SELECT name, geo.lat as lat, geo.lon as long FROM `travel-sample` WHERE type=\\\"hotel\\\" AND city=\\\"London\\\" AND pets_ok=true\"\r\nreq &lt;- httr::POST(cbServer, httr::add_headers(\"Content-Type\" = \"application\/x-www-form-urlencoded;charset=UTF-8\"), body = paste(\"statement=\", query))\r\nres &lt;- fromJSON(httr::content(req, \"text\"))\r\npetFriendlyHotelsLondon &lt;- res$results<\/pre>\n<p>Estes s\u00e3o os resultados:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3864\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/07\/petFriendlyHotelsLondon-274x300.jpg\" alt=\"\" width=\"527\" height=\"577\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/petFriendlyHotelsLondon-274x300.jpg 274w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/petFriendlyHotelsLondon-936x1024.jpg 936w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/petFriendlyHotelsLondon-768x840.jpg 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/petFriendlyHotelsLondon-300x328.jpg 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/petFriendlyHotelsLondon-18x20.jpg 18w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/petFriendlyHotelsLondon.jpg 1006w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/p>\n<p>Agora podemos usar a biblioteca leaflet para desenhar os resultados em um mapa:<\/p>\n<pre class=\"wrap:true lang:r decode:true\">leaflet(data = petFriendlyHotelsLondon) %&gt;% addTiles() %&gt;% addMarkers(~long, ~lat, popup = ~as.character(name), label = ~as.character(name)) %&gt;% addProviderTiles(providers$OpenStreetMap)<\/pre>\n<p>O mapa \u00e9 aberto em um navegador:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3863 aligncenter\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/07\/hotelsLondon-300x206.jpg\" alt=\"\" width=\"744\" height=\"511\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-300x206.jpg 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-1024x702.jpg 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-768x527.jpg 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-1536x1054.jpg 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-2048x1405.jpg 2048w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-235x160.jpg 235w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-20x14.jpg 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/hotelsLondon-1320x905.jpg 1320w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/>Isso \u00e9 tudo. Espero que isso seja \u00fatil para os primeiros passos no uso do Couchbase a partir do R. Boa an\u00e1lise de dados!<\/p>\n<p>Para obter mais detalhes, acesse:<br \/>\n<a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-rest-api\/index.html\">Refer\u00eancia da API REST do N1QL<\/a><br \/>\n<a href=\"https:\/\/www.r-project.org\/\">R: O projeto R para computa\u00e7\u00e3o estat\u00edstica<\/a><br \/>\n<a href=\"https:\/\/rstudio.github.io\/leaflet\/\">Folheto para R<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>I have seen a lot of interest in the field about using Couchbase with R. It is an easy integration, so here you have some examples to start using it right now. As a little background, R is a language [&hellip;]<\/p>","protected":false},"author":69,"featured_media":3865,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,1816,1812],"tags":[2014,2013],"ppma_author":[9041],"class_list":["post-3860","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-couchbase-server","category-n1ql-query","tag-data-analysis","tag-r"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Using Couchbase with R - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"Learn by example how to integrate Couchbase and R using N1QL and REST API\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/pt\/using-couchbase-r\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Couchbase with R\" \/>\n<meta property=\"og:description\" content=\"Learn by example how to integrate Couchbase and R using N1QL and REST API\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/pt\/using-couchbase-r\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-24T15:36:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-06T13:31:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/07\/featuredR.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2036\" \/>\n\t<meta property=\"og:image:height\" content=\"1264\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Manuel Hurtado, Solutions Engineer, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Manuel Hurtado, Solutions Engineer, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/\"},\"author\":{\"name\":\"Manuel Hurtado, Solutions Engineer, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/00c164bc72955b52cd86c966aafb9237\"},\"headline\":\"Using Couchbase with R\",\"datePublished\":\"2017-07-24T15:36:32+00:00\",\"dateModified\":\"2022-07-06T13:31:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/\"},\"wordCount\":455,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg\",\"keywords\":[\"Data Analysis\",\"R\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/\",\"name\":\"Using Couchbase with R - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg\",\"datePublished\":\"2017-07-24T15:36:32+00:00\",\"dateModified\":\"2022-07-06T13:31:37+00:00\",\"description\":\"Learn by example how to integrate Couchbase and R using N1QL and REST API\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg\",\"width\":2036,\"height\":1264},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Couchbase with R\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/00c164bc72955b52cd86c966aafb9237\",\"name\":\"Manuel Hurtado, Solutions Engineer, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/d792e93660734cc10c1f8a5bbc2cf29a\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e8eced6ee14aeefdf82ebfb694cfa145280c2e206f819d892eb82d5fef8a6a25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e8eced6ee14aeefdf82ebfb694cfa145280c2e206f819d892eb82d5fef8a6a25?s=96&d=mm&r=g\",\"caption\":\"Manuel Hurtado, Solutions Engineer, Couchbase\"},\"description\":\"Manuel is a Couchbase Solutions Engineer, with more than 15 years of experience helping companies to architect their systems, as developer, consultant, trainer and project manager. Happy to learn from the field how people use technology to success.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/pt\/author\/manuel-hurtado\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using Couchbase with R - The Couchbase Blog","description":"Aprenda, por exemplo, como integrar o Couchbase e o R usando o N1QL e a API REST","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/pt\/using-couchbase-r\/","og_locale":"pt_BR","og_type":"article","og_title":"Using Couchbase with R","og_description":"Learn by example how to integrate Couchbase and R using N1QL and REST API","og_url":"https:\/\/www.couchbase.com\/blog\/pt\/using-couchbase-r\/","og_site_name":"The Couchbase Blog","article_published_time":"2017-07-24T15:36:32+00:00","article_modified_time":"2022-07-06T13:31:37+00:00","og_image":[{"width":2036,"height":1264,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/07\/featuredR.jpg","type":"image\/jpeg"}],"author":"Manuel Hurtado, Solutions Engineer, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Manuel Hurtado, Solutions Engineer, Couchbase","Est. reading time":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/"},"author":{"name":"Manuel Hurtado, Solutions Engineer, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/00c164bc72955b52cd86c966aafb9237"},"headline":"Using Couchbase with R","datePublished":"2017-07-24T15:36:32+00:00","dateModified":"2022-07-06T13:31:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/"},"wordCount":455,"commentCount":2,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg","keywords":["Data Analysis","R"],"articleSection":["Best Practices and Tutorials","Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/","url":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/","name":"Using Couchbase with R - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg","datePublished":"2017-07-24T15:36:32+00:00","dateModified":"2022-07-06T13:31:37+00:00","description":"Aprenda, por exemplo, como integrar o Couchbase e o R usando o N1QL e a API REST","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/07\/featuredR.jpg","width":2036,"height":1264},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/using-couchbase-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using Couchbase with R"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"Blog do Couchbase","description":"Couchbase, o banco de dados NoSQL","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"Blog do Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/00c164bc72955b52cd86c966aafb9237","name":"Manuel Hurtado, engenheiro de solu\u00e7\u00f5es, Couchbase","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/d792e93660734cc10c1f8a5bbc2cf29a","url":"https:\/\/secure.gravatar.com\/avatar\/e8eced6ee14aeefdf82ebfb694cfa145280c2e206f819d892eb82d5fef8a6a25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e8eced6ee14aeefdf82ebfb694cfa145280c2e206f819d892eb82d5fef8a6a25?s=96&d=mm&r=g","caption":"Manuel Hurtado, Solutions Engineer, Couchbase"},"description":"Manuel \u00e9 engenheiro de solu\u00e7\u00f5es Couchbase, com mais de 15 anos de experi\u00eancia ajudando empresas a arquitetar seus sistemas, como desenvolvedor, consultor, instrutor e gerente de projetos. Tem prazer em aprender no campo como as pessoas usam a tecnologia para obter sucesso.","url":"https:\/\/www.couchbase.com\/blog\/pt\/author\/manuel-hurtado\/"}]}},"authors":[{"term_id":9041,"user_id":69,"is_guest":0,"slug":"manuel-hurtado","display_name":"Manuel Hurtado, Solutions Engineer, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/e8eced6ee14aeefdf82ebfb694cfa145280c2e206f819d892eb82d5fef8a6a25?s=96&d=mm&r=g","author_category":"","last_name":"Hurtado","first_name":"Manuel","job_title":"","user_url":"","description":"Manuel \u00e9 engenheiro de solu\u00e7\u00f5es Couchbase, com mais de 15 anos de experi\u00eancia ajudando empresas a arquitetar seus sistemas, como desenvolvedor, consultor, instrutor e gerente de projetos. Tem prazer em aprender no campo como as pessoas usam a tecnologia para obter sucesso."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/3860","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/users\/69"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/comments?post=3860"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/posts\/3860\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media\/3865"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/media?parent=3860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/categories?post=3860"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/tags?post=3860"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/pt\/wp-json\/wp\/v2\/ppma_author?post=3860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}