{"id":2413,"date":"2016-10-17T17:39:57","date_gmt":"2016-10-17T17:39:57","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2413"},"modified":"2025-10-09T07:21:00","modified_gmt":"2025-10-09T14:21:00","slug":"more-n1ql-enhancements-in-4-5-1-part2","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/es\/more-n1ql-enhancements-in-4-5-1-part2\/","title":{"rendered":"Mejoras de N1QL en 4.5.1 - Parte 2"},"content":{"rendered":"<h2 style=\"text-align: center\"><u>Simplificar la transici\u00f3n desde RDBMS<\/u><\/h2>\n<p><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">La versi\u00f3n 4.5.1 de Couchbase Server aporta m\u00faltiples mejoras de funcionalidad, usabilidad y rendimiento en N1QL para responder a las necesidades de las aplicaciones empresariales. Estas mejoras abordan muchos de los problemas cr\u00edticos de nuestros clientes y simplifican\u00a0<\/span><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">Transici\u00f3n desde RDBMS<\/span><span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">.<\/span><\/p>\n<p>Pruebe Couchbase Server 4.5.1.  Est\u00e1 listo para producci\u00f3n, probado por socios y clientes. Consulte las novedades para ver la lista completa de mejoras.<\/p>\n<p>No te pierdas\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/es\/n1ql-functionality-enhancements-in-couchbase-server-4.5.1\/\">parte1<\/a> del blog.<\/p>\n<h2>Nueva configuraci\u00f3n de la consulta <code>bonito<\/code><\/h2>\n<p>\u00a1\u00a1Guapa!! \u00a1\u00a1Guapa!! <code>bonito<\/code>\u00a1\u00a1!!  S\u00ed, <code>bonito<\/code> es un nuevo e impresionante ajuste de consulta en N1QL que puede activar o desactivar el formato bonito de los resultados de la consulta. Te preguntar\u00e1s, \u00bfqu\u00e9 tiene de bueno? Y, \u00bfpor qu\u00e9 alguien puede querer desactivar el hermoso formato bonito de la salida JSON.<\/p>\n<p>Como dice el refr\u00e1n, no hay comidas gratis. Dar un formato bonito a los resultados de una consulta conlleva sus propios gastos:<\/p>\n<ol>\n<li>En primer lugar, un hecho r\u00e1pido es que los caracteres de espacio en blanco (tabulaciones, espacios, nuevas l\u00edneas) en un documento JSON con formato bonito consumen casi un tercio de su tama\u00f1o.\n<ul>\n<li>As\u00ed, basta con reducir el embellecimiento para ahorrar todos los bytes brutos que circulan por la red.<\/li>\n<li>Adem\u00e1s, hay que tener en cuenta el correspondiente ahorro en los recursos de memoria y procesamiento del servicio N1QL.<\/li>\n<li>En conjunto, el ahorro es bastante significativo.<\/li>\n<\/ul>\n<\/li>\n<li>El bonito formato de salida es bueno para escenarios legibles por humanos, con\u00a0<span style=\"color: #333333;line-height: 20.799999237060547px;text-align: left\">resultados humanos manejables<\/span>.\n<ul>\n<li>Sin embargo, las aplicaciones del mundo real y los programas inform\u00e1ticos realizan consultas con mucha m\u00e1s frecuencia que los humanos y procesan resultados de consultas mucho mayores.<\/li>\n<li>Para ellos, lo importante es <strong>rendimiento<\/strong> y <strong>eficacia<\/strong>no es un formato bonito. De hecho, dicho formato es una sobrecarga para el analizador JSON y la aplicaci\u00f3n, y normalmente se descarta. Normalmente, las aplicaciones tienen su propia capa de presentaci\u00f3n para formatear los datos adecuadamente para los respectivos usuarios.<\/li>\n<li>Por ejemplo, considere un sitio web de reservas de viajes, donde usted est\u00e1 buscando vuelos. Estoy seguro de que ning\u00fan sitio de viajes vuelca los vuelos disponibles como un mont\u00f3n de documentos JSON.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>El nuevo par\u00e1metro de consulta <code>bonito<\/code> en 4.5.1 permite activar\/desactivar el formateo del resultado de una consulta.  El par\u00e1metro puede ser:<\/p>\n<ul>\n<li>ajustado a <code>verdadero<\/code> o <code>falso<\/code>.<\/li>\n<li>Pasados al motor CBQ como par\u00e1metros de l\u00ednea de comandos<\/li>\n<li>Se pasa como par\u00e1metro de consulta en las llamadas REST.<\/li>\n<\/ul>\n<p>Por defecto, se establece en <code>verdadero<\/code>. Cuando se ajusta a <code>falso<\/code>los caracteres en blanco se eliminan de los resultados de la consulta. Las ventajas de rendimiento son significativamente visibles cuando las consultas producen resultados de gran tama\u00f1o y, por supuesto, dependen del porcentaje de espacio en blanco de los documentos. Por ejemplo, la siguiente consulta, que selecciona todos los documentos de la muestra de viajes, ejecuta casi <strong>3 veces m\u00e1s r\u00e1pido<\/strong> cuando <code>bonito = false<\/code>. Observe tambi\u00e9n el tama\u00f1o del conjunto de resultados, que es un tercio del resultado con formato bonito.<\/p>\n<h2 style=\"margin-top: 0.7em;color: #333333;text-align: left\"><span style=\"font-family: monospace, monospace;line-height: 20.799999237060547px\">Con <code>bonito = true<\/code><\/span><\/h2>\n<pre><code class=\"language-http\">varakurprasad$ time curl -v https:\/\/localhost:8093\/query\/service -d \"pretty=true&amp;statement=SELECT * from `travel-sample`\" | tail -15\r\n* El nombre de host NO se ha encontrado en la cach\u00e9 DNS\r\n  % Total % Recibido % Xferd Velocidad Media Tiempo Tiempo Actual\r\n                                 Dload Upload Total Gastado Velocidad Izquierda\r\n  0 0 0 0 0 0 0 0 --:--:-- --:--:--:--:--:-- 0* Intentando ::1...\r\n* Conectado a localhost (::1) puerto 8093 (#0)\r\n* Server auth using Basic with user 'travel-sample'\r\n&gt; POST \/consulta\/servicio HTTP\/1.1\r\n&gt; Autorizaci\u00f3n: Basic dHJhdmVsLXNhbXBsZTpoZWxsbw==\r\n&gt; User-Agent: curl\/7.37.1\r\n&gt; Host: localhost:8093\r\n&gt; Accept: *\/*\r\n&gt; Content-Length: 51\r\n&gt; Content-Type: application\/x-www-form-urlencoded\r\n&gt;\r\n} [datos no mostrados]\r\n* carga completamente enviada 51 de 51 bytes\r\n&lt; HTTP\/1.1 200 OK\r\n&lt; Content-Type: application\/json; version=1.6.0\r\n&lt; Fecha: Sat, 15 Oct 2016 02:04:09 GMT\r\n&lt; Transfer-Encoding: chunked\r\n&lt;\r\n{ [datos no mostrados]\r\n100 103M 0 103M 100 51 16,6M 8 0:00:06 0:00:06 --:--:-- 17,2M\r\n* Conexi\u00f3n #0 al host localhost dejada intacta\r\n                ],\r\n                &quot;sourceairport&quot;: &quot;TLV&quot;,\r\n                &quot;paradas&quot;: 0,\r\n                &quot;tipo&quot;: &quot;route&quot;\r\n            }\r\n        }\r\n    ],\r\n    &quot;status&quot;: &quot;success&quot;,\r\n    &quot;m\u00e9tricas&quot;: {\r\n        &quot;elapsedTime&quot;: &quot;6.165034483s&quot;,\r\n        &quot;executionTime&quot;: &quot;6.164993497s&quot;,\r\n        &quot;resultCount&quot;: 31591,\r\n        &quot;resultSize&quot;: 107830610\r\n    }\r\n}\r\n\r\nreal 0m6.208s\r\nuser 0m5.704s\r\nsys 0m0.373s<\/code><\/pre>\n<h2 style=\"margin-top: 0.7em;color: #333333;text-align: left\"><span style=\"font-family: monospace, monospace;line-height: 20.799999237060547px\">Con\u00a0<code>bonito = false<\/code><\/span><\/h2>\n<p><span style=\"font-family: monospace, monospace;line-height: 20.799999237060547px\"><code>Tenga en cuenta que el total <\/code><\/span>resultSize ahora es s\u00f3lo 36754457bytes, y la consulta se ejecuta en 2,2seg.<\/p>\n<pre style=\"cursor: default\"><code>varakurprasad$ time curl -v https:\/\/localhost:8093\/query\/service -d \"pretty=false&amp;statement=SELECT * from `travel-sample`\" | tail -5\r\n* El nombre de host NO se ha encontrado en la cach\u00e9 DNS\r\n  % Total % Recibido % Xferd Velocidad Media Tiempo Tiempo Actual\r\n                                 Dload Upload Total Gastado Velocidad Izquierda\r\n  0 0 0 0 0 0 0 0 --:--:-- --:--:--:--:--:-- 0* Intentando ::1...\r\n* Conectado a localhost (::1) puerto 8093 (#0)\r\n* Server auth using Basic with user 'travel-sample'\r\n&gt; POST \/consulta\/servicio HTTP\/1.1\r\n&gt; Autorizaci\u00f3n: Basic dHJhdmVsLXNhbXBsZTpoZWxsbw==\r\n&gt; User-Agent: curl\/7.37.1\r\n&gt; Host: localhost:8093\r\n&gt; Accept: *\/*\r\n&gt; Content-Length: 52\r\n&gt; Content-Type: application\/x-www-form-urlencoded\r\n&gt;\r\n} [datos no mostrados]\r\n* carga completamente enviada: 52 de 52 bytes\r\n&lt; HTTP\/1.1 200 OK\r\n&lt; Content-Type: application\/json; version=1.6.0\r\n&lt; Fecha: Sat, 15 Oct 2016 02:03:29 GMT\r\n&lt; Transfer-Encoding: chunked\r\n&lt;\r\n{ [datos no mostrados]\r\n100 35,1M 0 35,1M 100 52 15,9M 23 0:00:02 0:00:02 --:--:-- 15,9M\r\n\r\n&quot;status&quot;: &quot;success&quot;\r\n&quot;m\u00e9tricas&quot;: {&quot;elapsedTime&quot;: &quot;2.148354775s&quot;,&quot;executionTime&quot;: &quot;2.148323137s&quot;,&quot;resultCount&quot;: 31591, &quot;resultSize&quot;: 36754457}\r\n}\r\n\r\nreal 0m2.223s\r\nusuario 0m1.977s\r\nsys 0m0.141s<\/code><\/pre>\n<h2>Mejoras en la construcci\u00f3n din\u00e1mica de objetos en las consultas N1QL<\/h2>\n<p>N1QL ya soporta la creaci\u00f3n de objetos JSON din\u00e1micamente en las consultas. Esto ayuda inmensamente en la creaci\u00f3n de objetos de resultados construidos espec\u00edficamente en las listas de proyecci\u00f3n de consultas. Couchbase server 4.5.1 ampl\u00eda la potencia de las expresiones y enriquece la creaci\u00f3n din\u00e1mica de objetos y el procesamiento de objetos en las consultas N1QL.<\/p>\n<ol>\n<li>En Couchbase Server 4.5.1, N1QL permite que tanto los nombres como los valores de los campos objeto sean expresiones arbitrarias. En versiones anteriores, se requiere que los nombres de los campos sean cadenas est\u00e1ticas. Si un nombre no se eval\u00faa a una cadena, el resultado de la construcci\u00f3n del objeto es NULL. Por ejemplo:\n<pre><code class=\"language-sql\">SELECT { UPPER(indicativo) || \"_key\" : indicativo || \":\" || pa\u00eds || \":\" || nombre } AS myobj\r\nFROM `viaje-muestra\r\nWHERE type = 'airline' limit 1;\r\n[\r\n  {\r\n    \"myobj\": {\r\n      \"MILE-AIR_key\": \"MILE-AIR:Estados Unidos:40-Mile Air\"\r\n    }\r\n  }\r\n]<\/code><\/pre>\n<\/li>\n<li>Cuando se construyen objetos en una consulta N1QL, los nombres de los campos en pares nombre-valor se hacen opcionales en 4.5.1. Por ejemplo, la siguiente consulta asigna impl\u00edcitamente los nombres \"type\" y \"name\" a los valores respectivos:\n<pre><code class=\"language-sql\">SELECT {type, name} AS myobj FROM `viaje-muestra` LIMIT 1;\r\n[\r\n  {\r\n    \"myobj\": {\r\n      \"tipo\": \"airport\"\r\n      \"name\": \"airport_123\"\r\n    }\r\n  }\r\n]<\/code><\/pre>\n<\/li>\n<\/ol>\n<h2>Nueva funci\u00f3n de matriz ARRAY_INTERSECT()<\/h2>\n<p>La funci\u00f3n ARRAY_INTERSECT() toma dos o m\u00e1s matrices como par\u00e1metros y devuelve como resultado la intersecci\u00f3n de las matrices de entrada, es decir, la matriz que contiene los valores presentes en todas las matrices de entrada. Si no hay elementos comunes, devuelve una matriz vac\u00eda. Para m\u00e1s informaci\u00f3n, consulte la documentaci\u00f3n. Por ejemplo, la siguiente consulta busca los hoteles que le gustan a Brian o Lilian, en el cubo de la muestra de viajes enviada con <a href=\"https:\/\/www.couchbase.com\/blog\/es\/nosql-databases\/downloads\/\">Servidor Couchbase 4.5.1<\/a>.<\/p>\n<pre><code class=\"language-sql\">SELECT meta().id, ARRAY_INTERSECT(public_likes, [\"Brian Kilback\", \"Lilian McLaughlin\"]) AS likes\r\nFROM `viajes-muestra` WHERE tipo = 'hotel'\r\nORDER BY gustos DESC\r\nLIMIT 4;\r\n[\r\n  {\r\n    \"id\": \"hotel_10025\",\r\n    \"likes\": [\r\n      \"Lilian McLaughlin\",\r\n      \"Brian Kilback\"\r\n    ]\r\n  },\r\n  {\r\n    \"id\": \"hotel_10026\",\r\n    \"likes\": []\r\n  },\r\n  {\r\n    \"id\": \"hotel_10064\",\r\n    \"likes\": []\r\n  },\r\n  {\r\n    \"id\": \"hotel_10063\",\r\n    \"likes\": []\r\n  }\r\n]<\/code><\/pre>\n<p>Descargar\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/es\/nosql-databases\/downloads\/\">Servidor Couchbase 4.5.1<\/a> y pru\u00e9balo. H\u00e1game saber cualquier pregunta \/ comentario, o simplemente lo impresionante que es ;-)<br \/>\n\u00a1Salud!<\/p>","protected":false},"excerpt":{"rendered":"<p>Simplificar la transici\u00f3n desde RDBMS La versi\u00f3n 4.5.1 de Couchbase Server aporta m\u00faltiples mejoras de funcionalidad, usabilidad y rendimiento en N1QL para satisfacer las necesidades de las aplicaciones empresariales. Estas mejoras abordan muchos de los problemas cr\u00edticos de nuestros clientes y simplifican la transici\u00f3n desde RDBMS. Pruebe Couchbase Server 4.5.1.  Su [...]<\/p>","protected":false},"author":2,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1812],"tags":[],"ppma_author":[8968],"class_list":["post-2413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n1ql-query"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v26.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>N1QL enhancements in 4.5.1 - Part2 - The Couchbase Blog<\/title>\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\/es\/more-n1ql-enhancements-in-4-5-1-part2\/\" \/>\n<meta property=\"og:locale\" content=\"es_MX\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"N1QL enhancements in 4.5.1 - Part2\" \/>\n<meta property=\"og:description\" content=\"Simplify Transitioning from RDBMS Couchbase Server 4.5.1 release brings multiple functionality, usability and performance improvements in N1QL to address needs of\u00a0enterprise applications. These enhancements address many of our customer critical issues, and simplify\u00a0Transitioning from RDBMS. Try Couchbase Server 4.5.1. \u00a0Its [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/es\/more-n1ql-enhancements-in-4-5-1-part2\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-17T17:39:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-09T14:21:00+00:00\" \/>\n<meta name=\"author\" content=\"The Couchbase Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"The Couchbase Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/\"},\"author\":{\"name\":\"The Couchbase Team\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/764f4a6771ee19bc7af70b70a326fb93\"},\"headline\":\"N1QL enhancements in 4.5.1 &#8211; Part2\",\"datePublished\":\"2016-10-17T17:39:57+00:00\",\"dateModified\":\"2025-10-09T14:21:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/\"},\"wordCount\":668,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/\",\"name\":\"N1QL enhancements in 4.5.1 - Part2 - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2016-10-17T17:39:57+00:00\",\"dateModified\":\"2025-10-09T14:21:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"N1QL enhancements in 4.5.1 &#8211; Part2\"}]},{\"@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\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@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\/764f4a6771ee19bc7af70b70a326fb93\",\"name\":\"The Couchbase Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/7befc37d02226b59499817eafdec60c3\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g\",\"caption\":\"The Couchbase Team\"},\"description\":\"Jennifer Garcia is a Senior Web Manager at Couchbase Inc. As the website manager, Jennifer has overall responsibility for the website properties including design, implementation, content, and performance.\",\"sameAs\":[\"https:\/\/www.couchbase.com\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/es\/author\/jennifer-garcia\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Mejoras de N1QL en 4.5.1 - Part2 - The Couchbase Blog","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\/es\/more-n1ql-enhancements-in-4-5-1-part2\/","og_locale":"es_MX","og_type":"article","og_title":"N1QL enhancements in 4.5.1 - Part2","og_description":"Simplify Transitioning from RDBMS Couchbase Server 4.5.1 release brings multiple functionality, usability and performance improvements in N1QL to address needs of\u00a0enterprise applications. These enhancements address many of our customer critical issues, and simplify\u00a0Transitioning from RDBMS. Try Couchbase Server 4.5.1. \u00a0Its [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/es\/more-n1ql-enhancements-in-4-5-1-part2\/","og_site_name":"The Couchbase Blog","article_published_time":"2016-10-17T17:39:57+00:00","article_modified_time":"2025-10-09T14:21:00+00:00","author":"The Couchbase Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"The Couchbase Team","Est. reading time":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/"},"author":{"name":"The Couchbase Team","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/764f4a6771ee19bc7af70b70a326fb93"},"headline":"N1QL enhancements in 4.5.1 &#8211; Part2","datePublished":"2016-10-17T17:39:57+00:00","dateModified":"2025-10-09T14:21:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/"},"wordCount":668,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["SQL++ \/ N1QL Query"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/","url":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/","name":"Mejoras de N1QL en 4.5.1 - Part2 - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2016-10-17T17:39:57+00:00","dateModified":"2025-10-09T14:21:00+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/more-n1ql-enhancements-in-4-5-1-part2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"N1QL enhancements in 4.5.1 &#8211; Part2"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"El blog de Couchbase","description":"Couchbase, la base de datos 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":"es"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"El blog de Couchbase","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"es","@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\/764f4a6771ee19bc7af70b70a326fb93","name":"El equipo de Couchbase","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/7befc37d02226b59499817eafdec60c3","url":"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g","caption":"The Couchbase Team"},"description":"Jennifer Garcia es Gerente Senior de Web en Couchbase Inc. Como responsable del sitio web, Jennifer tiene la responsabilidad general de las propiedades del sitio web, incluido el dise\u00f1o, la implementaci\u00f3n, el contenido y el rendimiento.","sameAs":["https:\/\/www.couchbase.com"],"url":"https:\/\/www.couchbase.com\/blog\/es\/author\/jennifer-garcia\/"}]}},"authors":[{"term_id":8968,"user_id":2,"is_guest":0,"slug":"jennifer-garcia","display_name":"The Couchbase Team","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/b4c18c758421903398e84d6c9560f319f39c665798d7d23e6a6f9dff8a8f984e?s=96&d=mm&r=g","author_category":"","last_name":"Garcia","first_name":"Jennifer","job_title":"","user_url":"https:\/\/www.couchbase.com","description":"Jennifer Garcia es Gerente Senior de Web en Couchbase Inc. Como responsable del sitio web, Jennifer tiene la responsabilidad general de las propiedades del sitio web, incluido el dise\u00f1o, la implementaci\u00f3n, el contenido y el rendimiento."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/2413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/comments?post=2413"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/posts\/2413\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/media?parent=2413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/categories?post=2413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/tags?post=2413"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/es\/wp-json\/wp\/v2\/ppma_author?post=2413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}