{"id":27879,"date":"2024-05-28T12:57:04","date_gmt":"2024-05-28T10:57:04","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=27879"},"modified":"2024-05-28T12:57:06","modified_gmt":"2024-05-28T10:57:06","slug":"open-source-the-awakening-of-pgsql","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/","title":{"rendered":"Open Source: The Awakening of PgSQL"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\" id=\"h-introduction\">Introduction<\/h4>\n\n\n\n<p>In the era of vector databases, AI, and cloud computing, traditional SQL may seem outdated, but this is far from true. <strong>PostgreSQL, a resilient open-source database<\/strong>, has emerged as a strong contender in 2024, revitalizing the use of SQL.<\/p>\n\n\n\n<p><strong>SPOILER:<\/strong> No, because just like the Force\u2122 in Star Wars can only fall dormant but never disappear, the SQL language <strong>may remain hidden for a while but always comes back<\/strong> into vogue thanks to new (or rather, old but rediscovered) allies like PostgreSQL. But why was it PostgreSQL that brought SQL back into fashion in 2024? Let\u2019s find out together!<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-who-is-pgs-kywalker-ql\">Who is PgS(kywalker)QL?<\/h4>\n\n\n\n<p>PostgreSQL is likened to a Jedi of open-source databases, showcasing exceptional data management capabilities. <strong>Much like Luke Skywalker, PostgreSQL embodies hope and innovation, challenging proprietary technologies<\/strong>. Its strengths lie in flexibility, scalability, and security, making it a reliable ally for various applications.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"715\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/e4ofSuQppSUsutiFu2ksDnDqqEf1-e9g34ww-1024x715.jpeg\" alt=\"PostgreSQL\" class=\"wp-image-27828\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/e4ofSuQppSUsutiFu2ksDnDqqEf1-e9g34ww-1024x715.jpeg 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/e4ofSuQppSUsutiFu2ksDnDqqEf1-e9g34ww-300x209.jpeg 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/e4ofSuQppSUsutiFu2ksDnDqqEf1-e9g34ww-768x536.jpeg 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/e4ofSuQppSUsutiFu2ksDnDqqEf1-e9g34ww.jpeg 1268w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-the-return-of-postgresql\">The Return of PostgreSQL<\/h4>\n\n\n\n<p>Initially, relational databases like PostgreSQL didn&#8217;t distinguish between OLTP and OLAP. Over time, these distinctions led to multi-database architectures, causing redundancy, maintenance, and cost issues. With the advent of extensions like ParadeDB for scalability and DuckDB for data analysis, PostgreSQL became a unified solution for both OLTP and OLAP, simplifying database management.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"724\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-1024x724.webp\" alt=\"\" class=\"wp-image-27882\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-1024x724.webp 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-300x212.webp 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-768x543.webp 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-1536x1085.webp 1536w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-180x128.webp 180w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image.webp 1755w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-postgresql-as-the-standard\">PostgreSQL as the Standard<\/h4>\n\n\n\n<p>Usage data crowns PostgreSQL as the king of relational databases. Its open-source nature boosts its popularity among developers, as evidenced by Stack Overflow surveys.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"783\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-2-1024x783.jpeg\" alt=\"stackoverflow survey postgreSQL\" class=\"wp-image-27881\" srcset=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-2-1024x783.jpeg 1024w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-2-300x230.jpeg 300w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-2-768x588.jpeg 768w, https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-2.jpeg 1200w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-versatility-of-postgresql\">Versatility of PostgreSQL<\/h4>\n\n\n\n<p>PostgreSQL&#8217;s support for extensions allows it to transcend its role as a relational database. Extensions like PostGIS (geospatial), TimescaleDB (time series), hstore (key-value store), AGE (graph database), and pgvector (vector database) turn PostgreSQL into a versatile platform for various data management needs.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h4>\n\n\n\n<p>PostgreSQL proves that old technologies aren&#8217;t obsolete but rather essential for the future of data management. With its robust features and community support, PostgreSQL ensures that SQL remains relevant. <\/p>\n\n\n\n<p><strong>May the force of PgS(kywalker)QL be with you!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In the era of vector databases, AI, and cloud computing, traditional SQL may seem outdated, but this is far from true. PostgreSQL, a resilient open-source database, has emerged as a strong contender in 2024, revitalizing the use of SQL. SPOILER: No, because just like the Force\u2122 in Star Wars can only fall dormant but&#8230; <a class=\"more-link\" href=\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/\">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":[36],"tags":[3360,12176],"collections":[],"class_list":{"0":"post-27879","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-backend","8":"tag-database","9":"tag-postgresql","10":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v26.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Open Source: The Awakening of PgSQL - Codemotion Magazine<\/title>\n<meta name=\"description\" content=\"Is PostgreSQL the chosen one to bring balance to the database universe? Read the article to find out more.\" \/>\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\/backend\/open-source-the-awakening-of-pgsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open Source: The Awakening of PgSQL\" \/>\n<meta property=\"og:description\" content=\"Is PostgreSQL the chosen one to bring balance to the database universe? Read the article to find out more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-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-28T10:57:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-28T10:57:06+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\/backend\/open-source-the-awakening-of-pgsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/\"},\"author\":{\"name\":\"TheZal\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/f3f099160f0d8f2f80c5e4f3c8d53503\"},\"headline\":\"Open Source: The Awakening of PgSQL\",\"datePublished\":\"2024-05-28T10:57:04+00:00\",\"dateModified\":\"2024-05-28T10:57:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/\"},\"wordCount\":321,\"publisher\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png\",\"keywords\":[\"Database\",\"PostgreSQL\"],\"articleSection\":[\"Backend\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/\",\"name\":\"Open Source: The Awakening of PgSQL - Codemotion Magazine\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png\",\"datePublished\":\"2024-05-28T10:57:04+00:00\",\"dateModified\":\"2024-05-28T10:57:06+00:00\",\"description\":\"Is PostgreSQL the chosen one to bring balance to the database universe? Read the article to find out more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-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\/backend\/open-source-the-awakening-of-pgsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.codemotion.com\/magazine\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Backend\",\"item\":\"https:\/\/www.codemotion.com\/magazine\/backend\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Open Source: The Awakening of 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\/#\/schema\/person\/image\/\",\"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":"Open Source: The Awakening of PgSQL - Codemotion Magazine","description":"Is PostgreSQL the chosen one to bring balance to the database universe? Read the article to find out more.","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\/backend\/open-source-the-awakening-of-pgsql\/","og_locale":"en_US","og_type":"article","og_title":"Open Source: The Awakening of PgSQL","og_description":"Is PostgreSQL the chosen one to bring balance to the database universe? Read the article to find out more.","og_url":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2024-05-28T10:57:04+00:00","article_modified_time":"2024-05-28T10:57:06+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\/backend\/open-source-the-awakening-of-pgsql\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/"},"author":{"name":"TheZal","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/f3f099160f0d8f2f80c5e4f3c8d53503"},"headline":"Open Source: The Awakening of PgSQL","datePublished":"2024-05-28T10:57:04+00:00","dateModified":"2024-05-28T10:57:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/"},"wordCount":321,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","keywords":["Database","PostgreSQL"],"articleSection":["Backend"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/","url":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/","name":"Open Source: The Awakening of PgSQL - Codemotion Magazine","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","datePublished":"2024-05-28T10:57:04+00:00","dateModified":"2024-05-28T10:57:06+00:00","description":"Is PostgreSQL the chosen one to bring balance to the database universe? Read the article to find out more.","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-pgsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/backend\/open-source-the-awakening-of-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\/backend\/open-source-the-awakening-of-pgsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.codemotion.com\/magazine\/"},{"@type":"ListItem","position":2,"name":"Backend","item":"https:\/\/www.codemotion.com\/magazine\/backend\/"},{"@type":"ListItem","position":3,"name":"Open Source: The Awakening of 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\/#\/schema\/person\/image\/","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":"Introduction In the era of vector databases, AI, and cloud computing, traditional SQL may seem outdated, but this is far from true. PostgreSQL, a resilient open-source database, has emerged as a strong contender in 2024, revitalizing the use of SQL. SPOILER: No, because just like the Force\u2122 in Star Wars can only fall dormant but&#8230;&hellip;","lang":"en","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27879","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=27879"}],"version-history":[{"count":3,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27879\/revisions"}],"predecessor-version":[{"id":27888,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27879\/revisions\/27888"}],"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=27879"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=27879"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=27879"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=27879"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}