{"id":27801,"date":"2024-05-27T12:45:17","date_gmt":"2024-05-27T10:45:17","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=27801"},"modified":"2024-05-28T17:07:45","modified_gmt":"2024-05-28T15:07:45","slug":"open-source-il-risveglio-di-pgsql","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/","title":{"rendered":"Open Source: il risveglio di PgSQL"},"content":{"rendered":"\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\tIndice\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
  1. Chi \u00e8 PgS(kywalker)QL?<\/a>
  2. Il ritorno di PostgreSQL<\/a>
  3. Ma chi lo dice che PostgreSQL \u00e8 lo standard?<\/a>
  4. Ma quindi \u00e8 vero che si pu\u00f2 usare PostgreSQL per tutto?<\/a>
  5. Conclusioni<\/a><\/ol>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\n\n\n

    Nell’era dei vector database, dell’AI e del cloud computing sembra che il buon vecchio SQL sia ormai un ricordo del passato. Ma \u00e8 davvero cos\u00ec?<\/p>\n\n\n\n

    SPOILER: No, perch\u00e8 proprio come la forza\u2122 in Star Wars al massimo pu\u00f2 assopirsi ma non scomparire, anche il linguaggio SQL pu\u00f2 rimanere nascosto per un po’ tornando per\u00f2 sempre in auge grazie a dei nuovi (anzi, vecchi ma riscoperti) alleati come Postgresql. Ma perch\u00e8 nel 2024 \u00e8 stato proprio PostgreSQL a far tornare di moda il linguaggio SQL? Scopriamolo insieme!<\/p>\n\n\n\n

    Chi \u00e8 PgS(kywalker)QL?<\/strong><\/h2>\n\n\n\n

    PgS(kywalker)QL \u00e8 il Jedi dei database open source, con un’abilit\u00e0 straordinaria nella gestione dei dati. Come un giovane Padawan che si trasforma in un potente Maestro Jedi, PostgreSQL \u00e8 cresciuto costantemente, migliorandosi grazie al contributo della sua devota comunit\u00e0 open source. Proprio come Luke Skywalker, PostgreSQL incarna speranza e innovazione, sfidando il lato oscuro della tecnologia proprietaria e chiusa.<\/p>\n\n\n\n

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

    La sua forza sta nella sua flessibilit\u00e0, scalabilit\u00e0 e sicurezza, rendendolo una scelta perfetta per chiunque cerchi un alleato affidabile nella gestione delle informazioni. Che tu stia costruendo un piccolo progetto o una complessa galassia di applicazioni, PgS(kywalker)QL \u00e8 il compagno fidato che ti guider\u00e0 verso il successo.<\/p>\n\n\n\n

    Il ritorno di PostgreSQL<\/strong><\/h2>\n\n\n\n

    Tanto tempo fa, in una galassia lontana lontana, nascevano i primi database relazionali. PostgreSQL era uno di questi e all’alba della nascita del concetto di database ancora non esisteva la distinzione tra OLTP <\/strong>(Online Transaction Processing) e OLAP <\/strong>(Online Analytical Processing). Con il passare degli anni le differenze tra questi due approcci portarono ad avere delle architetture multi database, con scope specifici e funzionalit\u00e0 diverse che puntavano ad affrontare al meglio i diversi problemi, tuttavia avere un’architettura multi database costituisce un problema di ridondanza di dati, manutenibilit\u00e0 e costi.<\/p>\n\n\n\n

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

    Fu con l’avvento di ParadeDB, ovvero un’estensione di PosgresSQL progettata per la scalabilit\u00e0 e la gestione di big data e di DuckDB (anzi, dell’estensione pg_quack che utilizza il query engine DuckDB) ovvero un database flessibile per gestione di analisi dei dati che PostgreSQL divenne il database perfetto per affrontare sia OLTP che OLAP, unendo in un unico database le funzionalit\u00e0 di entrambi, andando a non dover essere in grado di conoscere due diversi database, avendoci sotto la stessa base.<\/p>\n\n\n\n

    Ma chi lo dice che PostgreSQL \u00e8 lo standard?<\/strong><\/h2>\n\n\n\n

    I dati. Sono i dati di utilizzo che parlano per PgSQL incoronandolo re indiscusso dei database relazionali e non. Il fatto che sia open source aiuta sicuramente la diffusione dell’utilizzo di questo database e la popolarit\u00e0 tra gli sviluppatori che nel survey di Stack Overflow ci hanno detto che PostgreSQL \u00e8 lo standard.<\/p>\n\n\n\n

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

    Ma quindi \u00e8 vero che si pu\u00f2 usare PostgreSQL per tutto?<\/strong><\/h2>\n\n\n\n

    Una delle capacit\u00e0 pi\u00f9 impattanti aggiunte a PostgreSQL durantela sua ascesa al potere \u00e8 stata la possibilit\u00e0 di supportare le estensioni: moduli software che aggiungono funzionalit\u00e0 a PostgreSQL. Le estensioni hanno permesso a un numero ancora maggiore di sviluppatori di aggiungere funzionalit\u00e0 a PostgreSQL in modo indipendente, rapido e con minima coordinazione.<\/p>\n\n\n\n

    Grazie alle estensioni, PostgreSQL ha iniziato a diventare pi\u00f9 di un semplice grande database relazionale. Grazie a PostGIS, \u00e8 diventato un grande database geospaziale; grazie a TimescaleDB, \u00e8 diventato un grande database per serie temporali; grazie a hstore, un key-value store; grazie a AGE, un database a grafo; grazie a pgvector, un database a vettori. PostgreSQL \u00e8 diventato una piattaforma.<\/p>\n\n\n\n

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

    Ora, gli sviluppatori possono usare PostgreSQL per la sua affidabilit\u00e0, scalabilit\u00e0 (sostituendo i database non relazionali), analisi dei dati (sostituendo i data warehouse) e altro ancora. PostgreSQL \u00e8 diventato un database per tutte le stagioni.<\/p>\n\n\n\n

    \n\n\n\n

    Articolo consigliato: 5 tool open source da provare assolutamente<\/strong><\/a><\/p>\n\n\n\n

    \n\n\n\n

    Conclusioni<\/h2>\n\n\n\n

    In conclusione, PostgreSQL continua a dimostrare che il vecchio non \u00e8 necessariamente obsoleto. Proprio come un buon Jedi, SQL pu\u00f2 assopirsi ma non scomparire mai davvero. Grazie a PostgreSQL, il linguaggio SQL non \u00e8 solo rilevante ma essenziale per il futuro della gestione dei dati. Che la forza di PgS(kywalker)QL sia con voi!<\/p>\n","protected":false},"excerpt":{"rendered":"

    Nell’era dei vector database, dell’AI e del cloud computing sembra che il buon vecchio SQL sia ormai un ricordo del passato. Ma \u00e8 davvero cos\u00ec? SPOILER: No, perch\u00e8 proprio come la forza\u2122 in Star Wars al massimo pu\u00f2 assopirsi ma non scomparire, anche il linguaggio SQL pu\u00f2 rimanere nascosto per un po’ tornando per\u00f2 sempre… 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":[10263],"tags":[12173,12171],"collections":[11708],"class_list":{"0":"post-27801","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-backend-it","8":"tag-database-it","9":"tag-pgsql","10":"collections-dalla-community","11":"entry"},"yoast_head":"\nOpen Source: il risveglio di PgSQL - Codemotion Magazine<\/title>\n<meta name=\"description\" content=\"PostgreSQL \u00e8 il prescelto per portare l'equilibrio nell'universo dei database? Leggi l'articolo per scoprire di pi\u00f9.\" \/>\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\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Open Source: il risveglio di PgSQL\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL \u00e8 il prescelto per portare l'equilibrio nell'universo dei database? Leggi l'articolo per scoprire di pi\u00f9.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-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-27T10:45:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-28T15:07:45+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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/\"},\"author\":{\"name\":\"TheZal\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/f3f099160f0d8f2f80c5e4f3c8d53503\"},\"headline\":\"Open Source: il risveglio di PgSQL\",\"datePublished\":\"2024-05-27T10:45:17+00:00\",\"dateModified\":\"2024-05-28T15:07:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/\"},\"wordCount\":648,\"publisher\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png\",\"keywords\":[\"Database\",\"PgSQL\"],\"articleSection\":[\"Backend\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/\",\"url\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/\",\"name\":\"Open Source: il risveglio di PgSQL - Codemotion Magazine\",\"isPartOf\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png\",\"datePublished\":\"2024-05-27T10:45:17+00:00\",\"dateModified\":\"2024-05-28T15:07:45+00:00\",\"description\":\"PostgreSQL \u00e8 il prescelto per portare l'equilibrio nell'universo dei database? Leggi l'articolo per scoprire di pi\u00f9.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-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\/it\/backend-it\/open-source-il-risveglio-di-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\/it\/backend-it\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Open Source: il risveglio di 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: il risveglio di PgSQL - Codemotion Magazine","description":"PostgreSQL \u00e8 il prescelto per portare l'equilibrio nell'universo dei database? Leggi l'articolo per scoprire di pi\u00f9.","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\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/","og_locale":"en_US","og_type":"article","og_title":"Open Source: il risveglio di PgSQL","og_description":"PostgreSQL \u00e8 il prescelto per portare l'equilibrio nell'universo dei database? Leggi l'articolo per scoprire di pi\u00f9.","og_url":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2024-05-27T10:45:17+00:00","article_modified_time":"2024-05-28T15:07:45+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/"},"author":{"name":"TheZal","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/f3f099160f0d8f2f80c5e4f3c8d53503"},"headline":"Open Source: il risveglio di PgSQL","datePublished":"2024-05-27T10:45:17+00:00","dateModified":"2024-05-28T15:07:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/"},"wordCount":648,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","keywords":["Database","PgSQL"],"articleSection":["Backend"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/","url":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/","name":"Open Source: il risveglio di PgSQL - Codemotion Magazine","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/05\/image-3.png","datePublished":"2024-05-27T10:45:17+00:00","dateModified":"2024-05-28T15:07:45+00:00","description":"PostgreSQL \u00e8 il prescelto per portare l'equilibrio nell'universo dei database? Leggi l'articolo per scoprire di pi\u00f9.","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-pgsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/open-source-il-risveglio-di-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\/it\/backend-it\/open-source-il-risveglio-di-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\/it\/backend-it\/"},{"@type":"ListItem","position":3,"name":"Open Source: il risveglio di 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":"Nell’era dei vector database, dell’AI e del cloud computing sembra che il buon vecchio SQL sia ormai un ricordo del passato. Ma \u00e8 davvero cos\u00ec? SPOILER: No, perch\u00e8 proprio come la forza\u2122 in Star Wars al massimo pu\u00f2 assopirsi ma non scomparire, anche il linguaggio SQL pu\u00f2 rimanere nascosto per un po’ tornando per\u00f2 sempre……","lang":"it","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27801","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=27801"}],"version-history":[{"count":3,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27801\/revisions"}],"predecessor-version":[{"id":27905,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/27801\/revisions\/27905"}],"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=27801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=27801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=27801"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=27801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}