{"id":27906,"date":"2024-05-28T18:00:49","date_gmt":"2024-05-28T16:00:49","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=27906"},"modified":"2024-05-28T18:00:50","modified_gmt":"2024-05-28T16:00:50","slug":"codigo-abierto-el-despertar-de-pgsql","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/","title":{"rendered":"C\u00f3digo Abierto: El Despertar de PgSQL"},"content":{"rendered":"\n

Introducci\u00f3n<\/h3>\n\n\n\n

En la era de las bases de datos vectoriales, la inteligencia artificial y la computaci\u00f3n en la nube, el SQL tradicional puede parecer desactualizado, pero esto est\u00e1 lejos de ser cierto. PostgreSQL, una resistente base de datos de c\u00f3digo abierto, ha emergido como un fuerte contendiente en 2024, revitalizando el uso de SQL<\/strong> y demostrando que las tecnolog\u00edas tradicionales pueden adaptarse y prosperar en el mundo moderno.<\/p>\n\n\n\n

SPOILER:<\/strong> No, porque al igual que la Fuerza\u2122 en Star Wars solo puede caer en letargo pero nunca desaparecer, el lenguaje SQL puede permanecer oculto por un tiempo, pero siempre vuelve a estar de moda gracias a nuevos (o m\u00e1s bien, viejos pero redescubiertos) aliados como PostgreSQL. \u00bfPero por qu\u00e9 fue PostgreSQL quien trajo el SQL de vuelta a la moda en 2024? \u00a1Vamos a descubrirlo juntos!<\/p>\n\n\n\n

\u00bfQui\u00e9n es PgS(kywalker)QL?<\/h3>\n\n\n\n

PostgreSQL es comparado con un Jedi de las bases de datos de c\u00f3digo abierto, mostrando capacidades excepcionales de gesti\u00f3n de datos. Al igual que Luke Skywalker, PostgreSQL encarna la esperanza y la innovaci\u00f3n, desafiando a las tecnolog\u00edas propietarias. Sus fortalezas radican en la flexibilidad, escalabilidad y seguridad, lo que lo convierte en un aliado confiable para diversas aplicaciones, desde peque\u00f1as startups hasta grandes corporaciones.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

El Retorno de PostgreSQL<\/h3>\n\n\n\n

Inicialmente, las bases de datos relacionales como PostgreSQL no distingu\u00edan entre OLTP (procesamiento de transacciones en l\u00ednea) y OLAP (procesamiento anal\u00edtico en l\u00ednea). Con el tiempo, estas distinciones llevaron a arquitecturas de m\u00faltiples bases de datos, causando problemas de redundancia, mantenimiento y costos. Con la llegada de extensiones innovadoras como ParadeDB para la escalabilidad y DuckDB para el an\u00e1lisis de datos, PostgreSQL se convirti\u00f3 en una soluci\u00f3n unificada para tanto OLTP como OLAP, simplificando la gesti\u00f3n de bases de datos y reduciendo los costos operativos.<\/p>\n\n\n\n

\n\n\n\n

Art\u00edculo recomendado: \u00a1No dejes morir tus proyectos en GitHub!<\/strong><\/a><\/p>\n\n\n\n

\n\n\n\n

PostgreSQL como el Est\u00e1ndar<\/h3>\n\n\n\n

Los datos de uso coronan a PostgreSQL como el rey de las bases de datos relacionales. Su naturaleza de c\u00f3digo abierto aumenta su popularidad entre los desarrolladores, como lo demuestran las encuestas de Stack Overflow<\/a>. La comunidad activa y el soporte constante de PostgreSQL aseguran que se mantenga a la vanguardia de las innovaciones tecnol\u00f3gicas.<\/p>\n\n\n\n

\"stackoverflow<\/figure>\n\n\n\n

Versatilidad de PostgreSQL<\/h3>\n\n\n\n

El soporte de PostgreSQL para extensiones le permite trascender su papel como base de datos relacional. Extensiones como PostGIS (geoespacial), TimescaleDB (series temporales), hstore (almacenamiento de clave-valor), AGE (base de datos de grafos) y pgvector (base de datos vectorial) transforman a PostgreSQL en una plataforma vers\u00e1til para diversas necesidades de gesti\u00f3n de datos. Esta capacidad de adaptarse y expandirse seg\u00fan las demandas del mercado lo convierte en una herramienta indispensable para los desarrolladores modernos.<\/p>\n\n\n\n

Conclusi\u00f3n<\/h3>\n\n\n\n

PostgreSQL demuestra que las tecnolog\u00edas antiguas no est\u00e1n obsoletas, sino que son esenciales para el futuro de la gesti\u00f3n de datos. Con sus caracter\u00edsticas robustas, su capacidad de adaptaci\u00f3n y el apoyo de una comunidad global, PgSQL asegura que el SQL siga siendo relevante<\/strong>. En un mundo donde las tecnolog\u00edas emergentes dominan los titulares, PostgreSQL nos recuerda que lo probado y verdadero todav\u00eda tiene un lugar crucial en nuestro futuro digital.<\/p>\n\n\n\n

\u00a1Que la fuerza de PgS(kywalker)QL te acompa\u00f1e!<\/p>\n","protected":false},"excerpt":{"rendered":"

Introducci\u00f3n En la era de las bases de datos vectoriales, la inteligencia artificial y la computaci\u00f3n en la nube, el SQL tradicional puede parecer desactualizado, pero esto est\u00e1 lejos de ser cierto. PostgreSQL, una resistente base de datos de c\u00f3digo abierto, ha emergido como un fuerte contendiente en 2024, revitalizando el uso de SQL y… Read more<\/a><\/p>\n","protected":false},"author":193,"featured_media":27829,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","_uag_custom_page_level_css":"","_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[10654],"tags":[10756,12180],"collections":[],"class_list":{"0":"post-27906","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-open-source-es","8":"tag-codigo-abierto","9":"tag-postgresql-es","10":"entry"},"yoast_head":"\nC\u00f3digo Abierto: El Despertar de PgSQL - Codemotion Magazine<\/title>\n<meta name=\"description\" content=\"\u00bfEs PostgreSQL el elegido para traer equilibrio al universo de las bases de datos? Lee el art\u00edculo para descubrir m\u00e1s.\" \/>\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.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3digo Abierto: El Despertar de PgSQL\" \/>\n<meta property=\"og:description\" content=\"\u00bfEs PostgreSQL el elegido para traer equilibrio al universo de las bases de datos? Lee el art\u00edculo para descubrir m\u00e1s.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Codemotion Magazine\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Codemotion.Italy\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-28T16:00:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-28T16:00:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"TheZal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@CodemotionIT\" \/>\n<meta name=\"twitter:site\" content=\"@CodemotionIT\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TheZal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/\"},\"author\":{\"name\":\"TheZal\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/person\\\/f3f099160f0d8f2f80c5e4f3c8d53503\"},\"headline\":\"C\u00f3digo Abierto: El Despertar de PgSQL\",\"datePublished\":\"2024-05-28T16:00:49+00:00\",\"dateModified\":\"2024-05-28T16:00:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/\"},\"wordCount\":559,\"publisher\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-3.png\",\"keywords\":[\"C\u00f3digo abierto\",\"PostgreSQL\"],\"articleSection\":[\"Open source\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/\",\"name\":\"C\u00f3digo Abierto: El Despertar de PgSQL - Codemotion Magazine\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-3.png\",\"datePublished\":\"2024-05-28T16:00:49+00:00\",\"dateModified\":\"2024-05-28T16:00:50+00:00\",\"description\":\"\u00bfEs PostgreSQL el elegido para traer equilibrio al universo de las bases de datos? Lee el art\u00edculo para descubrir m\u00e1s.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-3.png\",\"contentUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/05\\\/image-3.png\",\"width\":1200,\"height\":800,\"caption\":\"postgresql\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/codigo-abierto-el-despertar-de-pgsql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Open source\",\"item\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/es\\\/open-source-es\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00f3digo Abierto: El Despertar de PgSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#website\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/\",\"name\":\"Codemotion Magazine\",\"description\":\"We code the future. Together\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\",\"name\":\"Codemotion\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/codemotionlogo.png\",\"contentUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2019\\\/11\\\/codemotionlogo.png\",\"width\":225,\"height\":225,\"caption\":\"Codemotion\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Codemotion.Italy\\\/\",\"https:\\\/\\\/x.com\\\/CodemotionIT\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/person\\\/f3f099160f0d8f2f80c5e4f3c8d53503\",\"name\":\"TheZal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/avatar-100x100.png\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/avatar-100x100.png\",\"contentUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/01\\\/avatar-100x100.png\",\"caption\":\"TheZal\"},\"description\":\"Hello there! My name is Riccardo (aka TheZal), a passionate software engineer who loves to combine his passion for code with his love for fantasy realms like Dungeons and Dragons, Harry Potter, Star Wars, LOTR, etc., etc. I'm really into studying and exploring new technologies (with a lot of love for Open Source). I'm also a co-owner of a 12-year-old dachshund called Poldo, who is the mascot of my blog!\",\"sameAs\":[\"http:\\\/\\\/www.thezal.dev\"],\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/author\\\/thezal\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00f3digo Abierto: El Despertar de PgSQL - Codemotion Magazine","description":"\u00bfEs PostgreSQL el elegido para traer equilibrio al universo de las bases de datos? Lee el art\u00edculo para descubrir m\u00e1s.","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.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/","og_locale":"en_US","og_type":"article","og_title":"C\u00f3digo Abierto: El Despertar de PgSQL","og_description":"\u00bfEs PostgreSQL el elegido para traer equilibrio al universo de las bases de datos? Lee el art\u00edculo para descubrir m\u00e1s.","og_url":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2024-05-28T16:00:49+00:00","article_modified_time":"2024-05-28T16:00:50+00:00","og_image":[{"width":1200,"height":800,"url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","type":"image\/png"}],"author":"TheZal","twitter_card":"summary_large_image","twitter_creator":"@CodemotionIT","twitter_site":"@CodemotionIT","twitter_misc":{"Written by":"TheZal","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/"},"author":{"name":"TheZal","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/f3f099160f0d8f2f80c5e4f3c8d53503"},"headline":"C\u00f3digo Abierto: El Despertar de PgSQL","datePublished":"2024-05-28T16:00:49+00:00","dateModified":"2024-05-28T16:00:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/"},"wordCount":559,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","keywords":["C\u00f3digo abierto","PostgreSQL"],"articleSection":["Open source"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/","url":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/","name":"C\u00f3digo Abierto: El Despertar de PgSQL - Codemotion Magazine","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","datePublished":"2024-05-28T16:00:49+00:00","dateModified":"2024-05-28T16:00:50+00:00","description":"\u00bfEs PostgreSQL el elegido para traer equilibrio al universo de las bases de datos? Lee el art\u00edculo para descubrir m\u00e1s.","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/#primaryimage","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","width":1200,"height":800,"caption":"postgresql"},{"@type":"BreadcrumbList","@id":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/codigo-abierto-el-despertar-de-pgsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.codemotion.com\/magazine\/"},{"@type":"ListItem","position":2,"name":"Open source","item":"https:\/\/www.codemotion.com\/magazine\/es\/open-source-es\/"},{"@type":"ListItem","position":3,"name":"C\u00f3digo Abierto: El Despertar de PgSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.codemotion.com\/magazine\/#website","url":"https:\/\/www.codemotion.com\/magazine\/","name":"Codemotion Magazine","description":"We code the future. Together","publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.codemotion.com\/magazine\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.codemotion.com\/magazine\/#organization","name":"Codemotion","url":"https:\/\/www.codemotion.com\/magazine\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2019\/11\/codemotionlogo.png","width":225,"height":225,"caption":"Codemotion"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Codemotion.Italy\/","https:\/\/x.com\/CodemotionIT"]},{"@type":"Person","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/f3f099160f0d8f2f80c5e4f3c8d53503","name":"TheZal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/01\/avatar-100x100.png","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/01\/avatar-100x100.png","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/01\/avatar-100x100.png","caption":"TheZal"},"description":"Hello there! My name is Riccardo (aka TheZal), a passionate software engineer who loves to combine his passion for code with his love for fantasy realms like Dungeons and Dragons, Harry Potter, Star Wars, LOTR, etc., etc. I'm really into studying and exploring new technologies (with a lot of love for Open Source). I'm also a co-owner of a 12-year-old dachshund called Poldo, who is the mascot of my blog!","sameAs":["http:\/\/www.thezal.dev"],"url":"https:\/\/www.codemotion.com\/magazine\/author\/thezal\/"}]}},"featured_image_src":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-600x400.png","featured_image_src_square":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-600x600.png","author_info":{"display_name":"TheZal","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/thezal\/"},"uagb_featured_image_src":{"full":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png",1200,800,false],"thumbnail":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-150x150.png",150,150,true],"medium":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-300x200.png",300,200,true],"medium_large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-768x512.png",768,512,true],"large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-1024x683.png",1024,683,true],"1536x1536":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png",1200,800,false],"2048x2048":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png",1200,800,false],"small-home-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-100x100.png",100,100,true],"sidebar-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-180x128.png",180,128,true],"genesis-singular-images":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-896x504.png",896,504,true],"archive-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-400x225.png",400,225,true],"gb-block-post-grid-landscape":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-600x400.png",600,400,true],"gb-block-post-grid-square":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3-600x600.png",600,600,true]},"uagb_author_info":{"display_name":"TheZal","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/thezal\/"},"uagb_comment_info":0,"uagb_excerpt":"Introducci\u00f3n En la era de las bases de datos vectoriales, la inteligencia artificial y la computaci\u00f3n en la nube, el SQL tradicional puede parecer desactualizado, pero esto est\u00e1 lejos de ser cierto. PostgreSQL, una resistente base de datos de c\u00f3digo abierto, ha emergido como un fuerte contendiente en 2024, revitalizando el uso de SQL y……","lang":"es","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/users\/193"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/comments?post=27906"}],"version-history":[{"count":3,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27906\/revisions"}],"predecessor-version":[{"id":27920,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27906\/revisions\/27920"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media\/27829"}],"wp:attachment":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media?parent=27906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=27906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=27906"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=27906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}