{"id":28950,"date":"2024-08-07T10:07:04","date_gmt":"2024-08-07T08:07:04","guid":{"rendered":"https:\/\/www.codemotion.com\/magazine\/?p=28950"},"modified":"2024-08-07T10:07:05","modified_gmt":"2024-08-07T08:07:05","slug":"opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio","status":"publish","type":"post","link":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/","title":{"rendered":"OpenDev Explorer &#8211; Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell&#8217;elio"},"content":{"rendered":"\n<p>Nonostante l&#8217;avvento degli ORM, il linguaggio SQL rimane il re indiscusso per la gestione dei database relazionali. Purtroppo per\u00f2 alcuni client SQL sono troppo pesanti e complicati da utilizzare, ecco perch\u00e9 oggi vi presento Sql-studio, un client SQL leggero e facile da usare scritto in Rust e React!<\/p>\n\n\n\n<p>Benvenuti a OpenDev Explorer, la mia rubrica dedicata all&#8217;esplorazione del mondo Open Source che strizza un occhio alla developer experience. Io sono Riccardo (aka TheZal) e oggi vi parler\u00f2 di <strong>Sql-studio, un client SQL leggero e facile da usare<\/strong> che \u00e8 andato a sostituire il mio vecchio client SQL preferito.<\/p>\n\n\n\t\t\t\t<div class=\"wp-block-uagb-table-of-contents uagb-toc__align-left uagb-toc__columns-1  uagb-block-b69a0f72      \"\n\t\t\t\t\tdata-scroll= \"1\"\n\t\t\t\t\tdata-offset= \"30\"\n\t\t\t\t\tstyle=\"\"\n\t\t\t\t>\n\t\t\t\t<div class=\"uagb-toc__wrap\">\n\t\t\t\t\t\t<div class=\"uagb-toc__title\">\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<div class=\"uagb-toc__list-wrap \">\n\t\t\t\t\t\t<ol class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#panoramica-generale\" class=\"uagb-toc-link__trigger\">Panoramica generale<\/a><li class=\"uagb-toc__list\"><a href=\"#manuale-di-istruzioni\" class=\"uagb-toc-link__trigger\">Manuale di istruzioni<\/a><ul class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#installazione\" class=\"uagb-toc-link__trigger\">Installazione<\/a><li class=\"uagb-toc__list\"><li class=\"uagb-toc__list\"><a href=\"#utilizzo\" class=\"uagb-toc-link__trigger\">Utilizzo<\/a><\/li><\/ul><\/li><li class=\"uagb-toc__list\"><a href=\"#la-developer-experience\" class=\"uagb-toc-link__trigger\">La developer experience<\/a><li class=\"uagb-toc__list\"><a href=\"#lextra-mile\" class=\"uagb-toc-link__trigger\">L&#039;extra mile<\/a><li class=\"uagb-toc__list\"><a href=\"#il-confronto-con-lo-status-quo\" class=\"uagb-toc-link__trigger\">Il confronto con lo status quo<\/a><li class=\"uagb-toc__list\"><a href=\"#sql-studio-tiriamo-le-somme\" class=\"uagb-toc-link__trigger\">SQL-Studio: tiriamo le somme!<\/a><\/ul><\/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<h2 class=\"wp-block-heading\" id=\"h-panoramica-generale\"><strong>Panoramica generale<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/github.com\/frectonz\/sql-studio\/blob\/main\/screenshots\/overview-dark.png?raw=true\" alt=\"\"\/><\/figure>\n\n\n\n<p>Immaginate di voler dare un&#8217;occhiata veloce ad un database PostgreSQL, magari per fare una query veloce o per controllare lo stato di una tabella. Immaginate anche di non voler installare un client SQL pesante come DBeaver o PgAdmin, ma di voler utilizzare un client SQL leggero e facile da usare.<\/p>\n\n\n\n<p>Se questo \u00e8 il vostro desiderio allora Sql-studio \u00e8 il client SQL che fa per voi! Sql-studio \u00e8 un client SQL leggero e facile da usare scritto in Rust e React che vi permette di connettervi a qualsiasi database PostgreSQ (e non solo) e fare query SQL in modo semplice e veloce.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-manuale-di-istruzioni\"><strong>Manuale di istruzioni<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-installazione\"><strong>Installazione<\/strong><\/h3>\n\n\n\n<p>Sql-studio \u00e8 disponibile per tutti i sistemi operativi (Windows, MacOS, Linux) e pu\u00f2 essere installato tramite i seguenti comandi:<\/p>\n\n\n\n<p>MacOs o Linux:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">curl --proto <span class=\"hljs-string\">'=https'<\/span> --tlsv1<span class=\"hljs-number\">.2<\/span> -LsSf https:<span class=\"hljs-comment\">\/\/github.com\/frectonz\/sql-studio\/releases\/download\/0.1.23\/sql-studio-installer.sh | sh<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Windows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">powershell -c <span class=\"hljs-string\">\"irm https:\/\/github.com\/frectonz\/sql-studio\/releases\/download\/0.1.23\/sql-studio-installer.ps1 | iex\"<\/span><\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Oppure usando nix con il comando:<\/p>\n\n\n<pre class=\"wp-block-code\"><span><code class=\"hljs\">nix shell github:frectonz\/sql-studio<\/code><\/span><\/pre>\n\n\n<p>Una volta installato sar\u00e0 possibile fare l&#8217;update direttamente tramite il comando <code>sql-studio update<\/code>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-utilizzo\"><strong>Utilizzo<\/strong><\/h3>\n\n\n\n<p>Una volta installato Sql-studio sar\u00e0 possibile connettersi a qualsiasi database utilizzando il comando apposito per il tipo di database a cui ci si vuole connettere. I comandi che si possono eseguire sono:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># Local SQLite database<\/span>\nsql-studio sqlite path\/to\/database.db\n\n<span class=\"hljs-comment\"># Remote libSQL Server database<\/span>\nsql-studio libsql &#91;url] &#91;auth_token]\n\n<span class=\"hljs-comment\"># Remote PostgreSQL database<\/span>\nsql-studio postgres &#91;url]\n\n<span class=\"hljs-comment\"># Remote MySQL\/MariaDB database<\/span>\nsql-studio mysql &#91;url]\n\n<span class=\"hljs-comment\"># Local DuckDB database<\/span>\nsql-studio duckdb &#91;duckdb_file]<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Una volta eseguito il comando sar\u00e0 possibile accedere al client SQL tramite il browser all&#8217;indirizzo <code>http:\/\/localhost:3030<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-la-developer-experience\"><strong>La developer experience<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/github.com\/frectonz\/sql-studio\/raw\/main\/screenshots\/query-dark.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Sql-studio \u00e8 stato progettato con la developer experience al centro di tutto. Infatti, il client \u00e8 molto facile da usare e permette di fare query SQL in modo semplice e veloce. Inoltre, Sql-studio \u00e8 molto leggero e non appesantisce il sistema, permettendo di fare query SQL anche su macchine poco potenti.<\/p>\n\n\n\n<p>La sua interfaccia permette di avere subito sott&#8217;occhio praticamente tutto ci\u00f2 che cerchiamo e la possibilit\u00e0 di avere pi\u00f9 tab aperte contemporaneamente permette di fare query SQL in modo molto pi\u00f9 veloce rispetto ad altri client SQL.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-l-extra-mile\"><strong>L&#8217;extra mile<\/strong><\/h2>\n\n\n<div class=\"gb-container gb-container-3f65454e\">\n<div class=\"gb-container gb-container-55cf00cb\">\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"500\" src=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/image.webp\" alt=\"\" class=\"wp-image-29130\"\/><\/figure>\n<\/div>\n<\/div>\n<\/div>\n\n\n<p>L&#8217;extra mile di Sql-studio \u00e8 sicuramente l&#8217;attenzione che \u00e8 stata posta nel design dell&#8217;interfaccia. Infatti, Sql-studio ha un&#8217;interfaccia essenziale che si concentra sul dare le informazioni che servono in modo chiaro e veloce. Sql-studio \u00e8 lo strumento perfetto per chi ha bisogno di dare uno sguardo al proprio database senza dover fare operazioni troppo onerose o complesse, \u00e8 il client SQL perfetto per chi vuole fare query SQL in modo semplice e veloce, senza dover installare client SQL pesanti e complicati e senza doversi scontrare con interfacce complicate e confusionarie.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-il-confronto-con-lo-status-quo\"><strong>Il confronto con lo status quo<\/strong><\/h2>\n\n\n\n<p>Nel panorama degli sturmenti per la gestione dei database relazionali ce ne sono per tutti i gusti. Ad esempio DBeaver \u00e8 un client SQL molto potente e completo, ma \u00e8 anche molto pesante e complicato da utilizzare.<\/p>\n\n\n\n<p>Possiamo anche nominare Azure Data Studio, il client SQL di casa Microsoft che nasce come alternativa a SSMS e che &#8220;ruba&#8221; lo stile di Visual Studio Code, ma personalmente ho trovato alcune limitazioni del tool sui sistemi operativi non Windows e con database non Microsoft.<\/p>\n\n\n\n<p>Sql-studio invece non ha queste limitazioni, andando a funzionare su diversi sistemi operativi (testato su Windows e Linux) e con diversi tipi di database (PostgreSQL, MySQL, SQLite, DuckDB e parzialmente ClickHouse).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-sql-studio-tiriamo-le-somme\"><strong>SQL-Studio: tiriamo le somme!<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/media.wired.com\/photos\/641337bd5e3ab3be4fe3e789\/master\/w_960,c_limit\/sql_normal.gif\" alt=\"\"\/><\/figure>\n\n\n\n<p>Quando ho bisogno di fare una query sql su un database relazionale Sql-studio \u00e8 il mio go-to client SQL. <strong>Sql-studio<\/strong> \u00e8 leggero, facile da usare e funziona su diversi sistemi operativi e con diversi tipi di database. Inoltre, Sql-studio \u00e8 open source e questo permette di contribuire al progetto, segnalare bug e richiedere nuove funzionalit\u00e0.<\/p>\n\n\n\n<p>E voi darete una chance a Sql-studio?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nonostante l&#8217;avvento degli ORM, il linguaggio SQL rimane il re indiscusso per la gestione dei database relazionali. Purtroppo per\u00f2 alcuni client SQL sono troppo pesanti e complicati da utilizzare, ecco perch\u00e9 oggi vi presento Sql-studio, un client SQL leggero e facile da usare scritto in Rust e React! Benvenuti a OpenDev Explorer, la mia rubrica&#8230; <a class=\"more-link\" href=\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/\">Read more<\/a><\/p>\n","protected":false},"author":193,"featured_media":29103,"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":[12476],"collections":[11708,11820],"class_list":{"0":"post-28950","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-backend-it","8":"tag-sql-studio","9":"collections-dalla-community","10":"collections-opendev-explorer-it","11":"entry"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.9 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>OpenDev Explorer - Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell&#039;elio - Codemotion Magazine<\/title>\n<meta name=\"description\" content=\"Sql-studio \u00e8 il tool che ti permette di esplorare dei database con la stessa leggerezza dell&#039;elio!\" \/>\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\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"OpenDev Explorer - Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell&#039;elio\" \/>\n<meta property=\"og:description\" content=\"Sql-studio \u00e8 il tool che ti permette di esplorare dei database con la stessa leggerezza dell&#039;elio!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/\" \/>\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-08-07T08:07:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-07T08:07:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1663\" \/>\n\t<meta property=\"og:image:height\" content=\"451\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/\"},\"author\":{\"name\":\"TheZal\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#\\\/schema\\\/person\\\/f3f099160f0d8f2f80c5e4f3c8d53503\"},\"headline\":\"OpenDev Explorer &#8211; Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell&#8217;elio\",\"datePublished\":\"2024-08-07T08:07:04+00:00\",\"dateModified\":\"2024-08-07T08:07:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/\"},\"wordCount\":656,\"publisher\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/logo_banner.jpg\",\"keywords\":[\"sql studio\"],\"articleSection\":[\"Backend\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/\",\"name\":\"OpenDev Explorer - Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell'elio - Codemotion Magazine\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/logo_banner.jpg\",\"datePublished\":\"2024-08-07T08:07:04+00:00\",\"dateModified\":\"2024-08-07T08:07:05+00:00\",\"description\":\"Sql-studio \u00e8 il tool che ti permette di esplorare dei database con la stessa leggerezza dell'elio!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/logo_banner.jpg\",\"contentUrl\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/wp-content\\\/uploads\\\/2024\\\/08\\\/logo_banner.jpg\",\"width\":1663,\"height\":451,\"caption\":\"SQL-studio\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.codemotion.com\\\/magazine\\\/it\\\/backend-it\\\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\\\/#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\":\"OpenDev Explorer &#8211; Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell&#8217;elio\"}]},{\"@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":"OpenDev Explorer - Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell'elio - Codemotion Magazine","description":"Sql-studio \u00e8 il tool che ti permette di esplorare dei database con la stessa leggerezza dell'elio!","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\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/","og_locale":"en_US","og_type":"article","og_title":"OpenDev Explorer - Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell'elio","og_description":"Sql-studio \u00e8 il tool che ti permette di esplorare dei database con la stessa leggerezza dell'elio!","og_url":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/","og_site_name":"Codemotion Magazine","article_publisher":"https:\/\/www.facebook.com\/Codemotion.Italy\/","article_published_time":"2024-08-07T08:07:04+00:00","article_modified_time":"2024-08-07T08:07:05+00:00","og_image":[{"width":1663,"height":451,"url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner.jpg","type":"image\/jpeg"}],"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\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/#article","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/"},"author":{"name":"TheZal","@id":"https:\/\/www.codemotion.com\/magazine\/#\/schema\/person\/f3f099160f0d8f2f80c5e4f3c8d53503"},"headline":"OpenDev Explorer &#8211; Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell&#8217;elio","datePublished":"2024-08-07T08:07:04+00:00","dateModified":"2024-08-07T08:07:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/"},"wordCount":656,"publisher":{"@id":"https:\/\/www.codemotion.com\/magazine\/#organization"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner.jpg","keywords":["sql studio"],"articleSection":["Backend"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/","url":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/","name":"OpenDev Explorer - Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell'elio - Codemotion Magazine","isPartOf":{"@id":"https:\/\/www.codemotion.com\/magazine\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/#primaryimage"},"image":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/#primaryimage"},"thumbnailUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner.jpg","datePublished":"2024-08-07T08:07:04+00:00","dateModified":"2024-08-07T08:07:05+00:00","description":"Sql-studio \u00e8 il tool che ti permette di esplorare dei database con la stessa leggerezza dell'elio!","breadcrumb":{"@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/#primaryimage","url":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner.jpg","contentUrl":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner.jpg","width":1663,"height":451,"caption":"SQL-studio"},{"@type":"BreadcrumbList","@id":"https:\/\/www.codemotion.com\/magazine\/it\/backend-it\/opendev-explorer-episodio-7-sql-studio-il-client-sql-piu-leggero-dellelio\/#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":"OpenDev Explorer &#8211; Episodio 7 Sql-studio: il client SQL pi\u00f9 leggero dell&#8217;elio"}]},{"@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\/08\/logo_banner-600x400.jpg","featured_image_src_square":"https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-600x451.jpg","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\/08\/logo_banner.jpg",1663,451,false],"thumbnail":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-150x150.jpg",150,150,true],"medium":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-300x81.jpg",300,81,true],"medium_large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-768x208.jpg",768,208,true],"large":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-1024x278.jpg",1024,278,true],"1536x1536":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-1536x417.jpg",1536,417,true],"2048x2048":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner.jpg",1663,451,false],"small-home-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-100x100.jpg",100,100,true],"sidebar-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-180x128.jpg",180,128,true],"genesis-singular-images":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-896x451.jpg",896,451,true],"archive-featured":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-400x225.jpg",400,225,true],"gb-block-post-grid-landscape":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-600x400.jpg",600,400,true],"gb-block-post-grid-square":["https:\/\/www.codemotion.com\/magazine\/wp-content\/uploads\/2024\/08\/logo_banner-600x451.jpg",600,451,true]},"uagb_author_info":{"display_name":"TheZal","author_link":"https:\/\/www.codemotion.com\/magazine\/author\/thezal\/"},"uagb_comment_info":0,"uagb_excerpt":"Nonostante l&#8217;avvento degli ORM, il linguaggio SQL rimane il re indiscusso per la gestione dei database relazionali. Purtroppo per\u00f2 alcuni client SQL sono troppo pesanti e complicati da utilizzare, ecco perch\u00e9 oggi vi presento Sql-studio, un client SQL leggero e facile da usare scritto in Rust e React! Benvenuti a OpenDev Explorer, la mia rubrica&#8230;&hellip;","lang":"it","_links":{"self":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/28950","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=28950"}],"version-history":[{"count":3,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/28950\/revisions"}],"predecessor-version":[{"id":29131,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/posts\/28950\/revisions\/29131"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media\/29103"}],"wp:attachment":[{"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/media?parent=28950"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/categories?post=28950"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/tags?post=28950"},{"taxonomy":"collections","embeddable":true,"href":"https:\/\/www.codemotion.com\/magazine\/wp-json\/wp\/v2\/collections?post=28950"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}