{"id":7832,"date":"2021-10-01T14:39:00","date_gmt":"2021-10-01T12:39:00","guid":{"rendered":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/?p=7832"},"modified":"2023-11-22T17:35:20","modified_gmt":"2023-11-22T16:35:20","slug":"creare-software-gestionale-gratis-con-sql-server-e-nodejs","status":"publish","type":"post","link":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/","title":{"rendered":"Come creare un software gestionale gratis con SQL Server e NodeJS"},"content":{"rendered":"\n<p class=\"has-medium-font-size wp-block-paragraph\">Dopo averti presentato la mia guida su <a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/come-sviluppare-web-app-codeless-con-wordpress-php-e-mysql\/\" target=\"_blank\" rel=\"noreferrer noopener\">Come sviluppare web app CodeLess con WordPress, PHP e MySQL<\/a> oggi ti spiegher\u00f2 <mark><span style=\"color:#000000\" class=\"tadv-color\"><span style=\"background-color:#f2f927\" class=\"tadv-background-color\"><strong>come creare un<\/strong> <strong>&nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/aggiornamento-software-gestionale-automatico-da-prompt-dei-comandi\/\">software gestionale<\/a>\u00a0 gratis<\/strong> con &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/eseguire-comandi-sql-con-sqlcmd-da-prompt-dei-comandi\/\">SQL Server<\/a>\u00a0 Express, &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/compressione-dati\/\">JavaScript<\/a>\u00a0 e NodeJS<\/span><\/span><\/mark>.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Le nuove regole sulla programmazione di applicazioni web, stanno sempre di pi\u00f9 spostando il codice lato client e lasciando sul server il solo codice di accesso e modifica della banca dati.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Grazie a sistemi e framework innovativi, che vedremo pi\u00f9 avanti nella guida, oggi \u00e8 possibile progettare applicativi web senza l\u2019ausilio di un &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/come-installare-un-server-web-su-raspberry-pi\/\">server web<\/a>\u00a0, come ad esempio, Apache, IIS ecc\u2026 Parlo di &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/come-diventare-un-full-stack-developer-con-node-js-ed-express-js\/\">applicazioni ServerLess<\/a>\u00a0 scritte interamente in Javascript.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">In questo articolo:<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#1_Javascript_per_accedere_a_Microsoft_SQL_Server\" >1. Javascript per accedere a Microsoft SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#2_Download_Microsoft_SQL_Server_Express\" >2. Download Microsoft SQL Server Express<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#3_Download_NodeJs\" >3. Download NodeJs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#4_Creare_su_SQL_Server_database_di_prova\" >4. Creare su SQL Server database di prova<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#5_Crea_il_tuo_primo_script_con_npm_NodeJs\" >5. Crea il tuo primo script con npm NodeJs<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#6_Come_invocare_una_http_Get_Request_in_NodeJS_con_Javascript\" >6. Come invocare una http Get Request in NodeJS con Javascript<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1-javascript-per-accedere-a-microsoft-sql-server\"><span class=\"ez-toc-section\" id=\"1_Javascript_per_accedere_a_Microsoft_SQL_Server\"><\/span><strong>1. Javascript per accedere a Microsoft SQL Server<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Non esiste una libreria di funzioni, standard, per connettersi a database SQL Server con JavaScript. Infatti, ogni browser ha una sua API proprietaria e delle librerie studiate ad hoc per connettersi a SQL Server.&nbsp;Ad esempio, in Windows, il browser Internet Explorer ha una sua classe di nome <strong>ActiveXObject<\/strong>&nbsp;che viene utilizzata per creare istanze di oggetti OLE per la connessione a database remoti creati su SQL Server.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Nello script che segue, \u00e8 riportato un tipico esempio di connessione al database <strong>adventureworks<\/strong> presente in tutte le installazioni di SQL Server. Non devi fare altro che creare un file, con estensione html, copiare e incollare il seguente codice nel file.<\/p>\n\n\n\n<pre class=\"wp-block-code has-medium-font-size\"><code>&lt;html&gt;\n&lt;head&gt;\n   &lt;title&gt;Connessione a SQL Server&lt;\/title&gt;\n&lt;\/head&gt;\n&lt;body&gt;\n\t&lt;script&gt;\n\t\tvar objConnection = new ActiveXObject(\"adodb.connection\");\n\n\t\tvar strConn = \"driver={sql server}; \n\t\t\t       server=&lt;nome_server&gt;; \n\t\t\t       database=adventureworks; \n\t\t\t       uid=sa; \n                               password=12345\";\n\n\t\tobjConnection.Open(strConn);\n\n\t\tvar rs = new ActiveXObject(\"ADODB.Recordset\");\n\t\tvar strQuery = \"SELECT * FROM Person.Address\";\n\t\trs.Open(strQuery, objConnection);\n\t\trs.MoveFirst();\n\t\twhile (!rs.EOF) {\n\t\t\tdocument.write(rs.fields(0) + \"&amp;nbsp;\");\n\t\t\tdocument.write(rs.fields(1) + \"&amp;nbsp;\");\n\t\t\tdocument.write(rs.fields(2) + \"&amp;nbsp;\");\n\t\t\tdocument.write(rs.fields(3) + \"&amp;nbsp;\");\n\t\t\tdocument.write(rs.fields(4) + \"&lt;br\/&gt;\");\n\t\t\trs.movenext();\n\t\t}\n\t&lt;\/script&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;\n<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Questo tipo di approccio, per\u00f2, ha delle grosse controindicazioni. Specificare username e password all\u2019interno di una pagina html non \u00e8 assolutamente consigliabile.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Cio\u00e8, non rientra tra gli usi convenzionali utilizzare codice di questo tipo per accedere a un database SQL Server. Infatti, basta aprire la console degli strumenti per gli sviluppatori, integrata in tutti i pi\u00f9 diffusi browser, per vedere in chiaro tutti i parametri di accesso al database, password comprese.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">In figura \u00e8 raffigurato un tipico esempio di pagina html con codice di accesso a SQL Server in cui figurano in chiaro username e password.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"450\" src=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/strumenti-per-sviluppatori-chrome-642x450.jpg\" alt=\"Software gestionale gratis - Strumenti per sviluppatori Chrome\" class=\"wp-image-7843\" srcset=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/strumenti-per-sviluppatori-chrome-642x450.jpg 642w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/strumenti-per-sviluppatori-chrome-300x210.jpg 300w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/strumenti-per-sviluppatori-chrome-768x539.jpg 768w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/strumenti-per-sviluppatori-chrome-130x90.jpg 130w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/strumenti-per-sviluppatori-chrome.jpg 824w\" sizes=\"auto, (max-width: 642px) 100vw, 642px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">&nbsp;<br>Pi\u00f9 avanti scopriremo come, Node.js, ci fornisce il sistema ideale per eseguire &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/un-comando-javascript-poco-conosciuto-ma-molto-efficace\/\">codice JavaScript<\/a>\u00a0 lato server offrendo enormi vantaggi legati alla sicurezza e alla scalabilit\u00e0.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Innanzitutto scarichiamo e installiamo SQL Server Express e NodeJs sulla macchina locale o server, nel caso in cui avessimo uno a disposizione.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2-download-microsoft-sql-server-express\"><span class=\"ez-toc-section\" id=\"2_Download_Microsoft_SQL_Server_Express\"><\/span><br><strong>2. Download Microsoft SQL Server Express<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">&nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/il-segreto-per-scrivere-query-sql-server\/\">Microsoft SQL Server<\/a>\u00a0 \u00e8 un sistema di gestione di database relazionali sviluppato dalla Microsoft.&nbsp;Essendo un server di database, \u00e8 un prodotto software con la funzione principale di archiviare e recuperare dati come richiesto dalle applicazioni software a lui connesse. Tieni in considerazione che, SQL Server Express pu\u00f2 essere eseguito sullo stesso computer o su un altro computer in rete.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Microsoft SQL Server \u00e8 presente in varie versioni, quasi tutte a pagamento tranne la versione Express, che \u00e8 libera ma che ha anche delle limitazioni che comunque consentono un uso del software a livello di piccole e medie applicazioni.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"746\" height=\"450\" src=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-sql-server-express-746x450.jpg\" alt=\"creare software gestionale gratis con sql server express\" class=\"wp-image-7845\" srcset=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-sql-server-express-746x450.jpg 746w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-sql-server-express-300x181.jpg 300w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-sql-server-express-768x463.jpg 768w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-sql-server-express.jpg 1308w\" sizes=\"auto, (max-width: 746px) 100vw, 746px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">A <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noreferrer noopener\">questo link<\/a>, \u00e8 possibile scaricare SQL Server Express e installarlo. Seguendo questo video tutorial puoi vedere come installare SQL Server Express in pochi semplici passaggi.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube\" style=\"margin-top:var(--wp--preset--spacing--50);margin-right:var(--wp--preset--spacing--50);margin-bottom:var(--wp--preset--spacing--50);margin-left:var(--wp--preset--spacing--50)\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Install SQL Server Express 2019\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/LIytfaWH_10?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/youtu.be\/LIytfaWH_10\" target=\"_blank\" rel=\"noreferrer noopener\">Installare SQL Server Express 2019<\/a><\/figcaption><\/figure>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Terminata l\u2019installazione di SQL Server Express nel paragrafo seguente vedremo come installare l\u2019ultimo componente che caratterizza tutto il progetto, <strong>NodeJS<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"3-download-nodejs\"><span class=\"ez-toc-section\" id=\"3_Download_NodeJs\"><\/span><strong>3. Download NodeJs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Node.js \u00e8 un ambiente runtime JavaScript multipiattaforma open source che esegue codice JavaScript questa volta per\u00f2 non all\u2019interno di un browser web. NodeJs esegue codice javascript autonomamente, inoltre, ti permette di creare applicazioni web ServerLess, cio\u00e8, senza la necessit\u00e0 di installare un server web per l\u2019elaborazione di script lato server, come ad esempio, PHP, Java, c#, ecc\u2026<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">In questa guida, stiamo trattando l\u2019argomento circa la connessione a database MS SQL Server utilizzando JavaScript in ambiente Node.js.&nbsp;Quindi, per iniziare con il piede giusto, dobbiamo installare oltre a <strong>MS SQL Server&nbsp;anche Node.js<\/strong>&nbsp;sul computer. A <a href=\"https:\/\/nodejs.org\/en\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">questo link<\/a>, \u00e8 possibile scaricare NodeJs e installarlo.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"450\" src=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-nodejs-582x450.jpg\" alt=\"download NodeJs\" class=\"wp-image-7846\" srcset=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-nodejs-582x450.jpg 582w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-nodejs-300x232.jpg 300w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-nodejs-768x593.jpg 768w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/download-nodejs.jpg 1016w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><figcaption class=\"wp-element-caption\">Home page di NodeJS<\/figcaption><\/figure>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Inoltre, seguendo questo video tutorial potrai vedere, passo-passo, come installare velocemente NodeJs sul tuo computer.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube\" style=\"margin-top:var(--wp--preset--spacing--50);margin-right:var(--wp--preset--spacing--50);margin-bottom:var(--wp--preset--spacing--50);margin-left:var(--wp--preset--spacing--50)\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"Install Node.js and Express.js | windows 10\" width=\"800\" height=\"450\" src=\"https:\/\/www.youtube.com\/embed\/0SpL_YhJJ3s?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>\n<\/div><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/youtu.be\/0SpL_YhJJ3s\" target=\"_blank\" rel=\"noreferrer noopener\">Come installare NodeJS ed ExpressJS<\/a><\/figcaption><\/figure>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Da qui in avanti, nella guida, utilizzeremo lo strumento a riga di comando (CLI) come il Terminale di Linux o CMD di Windows per eseguire i comandi e le query che seguiranno.<\/p>\n\n\n\n<hr>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">LEGGI ANCHE: <a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/come-diventare-un-full-stack-developer-con-node-js-ed-express-js\/\" target=\"_blank\" rel=\"noreferrer noopener\">Come diventare Full Stack Developer con Node Js ed Express Js<\/a><\/p>\n\n\n\n<hr>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"4-creare-su-sql-server-database-di-prova\"><span class=\"ez-toc-section\" id=\"4_Creare_su_SQL_Server_database_di_prova\"><\/span><strong>4. Creare su SQL Server database di prova<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Come anticipato precedentemente, a questo punto, <a href=\"https:\/\/www.microsoft.com\/en-gb\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noreferrer noopener\">MS SQL Server<\/a>&nbsp;deve essere installato sul computer locale.&nbsp;Ora, apri il &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/i-5-migliori-metodi-per-resettare-la-password-di-windows-10\/\">prompt dei comandi<\/a>\u00a0 di Windows e digita il seguente codice per connetterti a SQL Server.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">sqlcmd -S localhost -U SA -P \"&lt;password&gt;\"<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Ora, abbiamo bisogno di creare un database che utilizzeremo per le nostre prove, pertanto, digita i seguenti comandi per creare un database di nome <strong>\u201ctest\u201d.<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">CREATE DATABASE test;\nGO<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Una volta creato il database, devi istruire SQL Server a inoltrare i comandi verso il database appena creato, quindi, digita il comando seguente per rendere il database <strong>test<\/strong> il database corrente.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">Use test;\nGO<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Adesso \u00e8 necessario creare una tabella all\u2019interno del database <strong>test<\/strong>, digitando i comandi seguenti creerai la tabella <strong>studenti<\/strong>&nbsp;contenente i campi: <strong>id<\/strong>, <strong>nome<\/strong> e <strong>cognome<\/strong>.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">CREATE TABLE studenti \n(id INT, nome NVARCHAR(30), cognome NVARCHAR(30));\nGO\n<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Tanto per rendere le cose ancora pi\u00f9 interessanti e reali \u00e8 meglio riempire la tabella studenti con alcuni records. I seguenti comandi aggiungono 3 studenti all\u2019interno della tabella&nbsp;<strong>&#8220;studenti&#8221;.<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">INSERT INTO studenti VALUES (1, 'Stephen', 'Hawking');\nINSERT INTO studenti VALUES (2, 'Isaac', 'Newton');\nINSERT INTO studenti VALUES (3, 'Leonardo', 'da Vinci');\nGO\n<\/pre>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"260\" src=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/crea-database-sql-server.jpg\" alt=\"software gestionale gratis\" class=\"wp-image-7848\" srcset=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/crea-database-sql-server.jpg 667w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/crea-database-sql-server-300x117.jpg 300w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Verifichiamo se i comandi precedenti hanno inserito effettivamente i 3 records nella tabella studenti:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">SELECT * FROM studenti;\nGO<\/pre>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"670\" height=\"268\" src=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/elenco-records-tabella-studenti-1.jpg\" alt=\"software gestionale gratis\" class=\"wp-image-7850\" srcset=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/elenco-records-tabella-studenti-1.jpg 670w, https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/elenco-records-tabella-studenti-1-300x120.jpg 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"5-crea-il-tuo-primo-script-con-npm-nodejs\"><span class=\"ez-toc-section\" id=\"5_Crea_il_tuo_primo_script_con_npm_NodeJs\"><\/span><strong>5. Crea il tuo primo script con npm NodeJs<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Prima di iniziare&nbsp;<a href=\"https:\/\/nodejs.org\/en\/download\/\" target=\"_blank\" rel=\"noreferrer noopener\">Node.js<\/a>&nbsp;dovrebbe essere installato nel sistema locale.&nbsp;Come primo step \u00e8 necessario inizializzare l\u2019ambiente Node.js digitando il seguente comando nella console o nel terminale di sistema.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">npm init<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">A questo punto \u00e8 necessario installare Express Js che ci consentir\u00e0 di creare un middleware per rispondere al tutte le richieste HTTP. Quindi, digita il seguente comando:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">npm install express --save<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Come ultimo step installiamo Il client Microsoft SQL Server che ci consentir\u00e0 di connetterci con il server SQL e di impartire, a quest\u2019ultimo, i comandi necessari per le nostre richieste http. Pertanto, digita il seguente comando:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">npm install mssql --save<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">A questo punto siamo pronti per iniziare a scrivere il codice, con Nodejs ed ExpressJs, per reperire dati dal nostro server SQL. Innanzitutto dobbiamo creare un file, in una cartella del nostro computer locale, cio\u00e8 dove \u00e8 installato sql server e nodejs, con estensione \u201c.js\u201d e, che per nostra comodit\u00e0, possiamo rinominare in <strong>server.js<\/strong>. Infine, copia e incolla, in server.js, questo codice:<\/p>\n\n\n\n<pre class=\"wp-block-code has-medium-font-size\"><code>\/\/ --------------------------\n\/\/ Importa i moduli richiesti\n\/\/ --------------------------\nconst express = require('express');\nconst app = express();\nconst mssql = require('mssql');\n\n\/\/ --------------------------\n\/\/ Get request GetAllStudents\n\/\/ --------------------------\napp.get('\/GetAllStudents', function (req, res) {\n   \/\/ Parametri di connessione al database\n   const config = {\n        user: 'SA',\n        password: 'Your_Password',\n        server: 'localhost',\n        database: 'test'\n   };\n\n   \/\/ Connessione al database\n   mssql.connect(config, function (err) {\n      var request = new mssql.Request();\n      \/\/ Esegue Query SQL Server\n      request.query('select * from studenti',\n         function (err, records) {\n            if (err) console.log(err)\n            \/\/ Invia i records al browser\n            res.send(records);\n         });\n   });\n});\n\/\/ -------------------------------\n\/\/ Fine Get request GetAllStudents\n\/\/ -------------------------------\n\n\/\/ --------------------------------------\n\/\/ Server web in ascolto sulla porta 5000\n\/\/ --------------------------------------\nvar server = app.listen(5000, function () {\n   console.log('Il Server \u00e8 in ascolto sulla porta 5000...');\n});\n<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Esegui il&nbsp;file&nbsp;<strong>server.js<\/strong>&nbsp;usando il seguente comando:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">node server.js<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Dopo aver eseguito il comando precedente, vedrai il seguente output visualizzato nella tua console dei comandi:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted has-medium-font-size\">Il server \u00e8 in ascolto sulla porta 5000...<\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Questo significa, che nel file server.js \u00e8 compreso non solo il codice per eseguire la Get Request <strong>GetAllStudents<\/strong>, cio\u00e8 il codice per eseguire una query su SQL Server, ma anche il codice per creare e avviare il nostro server web.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Infatti, le ultime 3 righe di codice in server.js \u00e8 tutto quello che serve per creare un vero e proprio server web. Ecco perch\u00e9 questo tipo di applicazioni sono chiamate ServerLess, cio\u00e8, applicazioni web che per essere eseguite non hanno bisogno di un server web installato come, ad esempio, Apache.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Ora, non ci resta che richiamare la &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/a-che-serve-il-simbolo-nella-url\/\">http Get<\/a>\u00a0 Request \u201c<strong>GetAllStudents<\/strong>\u201d<strong>. <\/strong>Per fare questo apri il browser web e digita l&#8217;URL&nbsp;<strong>http:\/\/localhost:5000\/GetAllStudents\/<\/strong>&nbsp;nella barra degli indirizzi del browser stesso, premi invio e dovresti vedere qualcosa del genere:<\/p>\n\n\n\n<pre class=\"wp-block-code has-medium-font-size\"><code>{\n   \u201cstudenti\u201d: &#91;\n      {\n         \u201cid\u201c : 1,\n         \u201cnome\u201c : \u201cStephen\u201c,\n         \u201ccognome\u201c : \u201cHawking\u201c\n      },\n      {\n         \u201cid\u201c : 2,\n         \u201cnome\u201c : \u201cIsaac\u201c,\n         \u201ccognome\u201c : \u201cNewton\u201c\n      },\n      {\n         \u201cid\u201c : 3,\n         \u201cnome\u201c : \u201cLeonardo\u201c,\n         \u201ccognome\u201c : \u201cda Vinci\u201c\n      }\n   ]\n}\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"6-come-invocare-una-http-get-request-in-nodejs-con-javascript\"><span class=\"ez-toc-section\" id=\"6_Come_invocare_una_http_Get_Request_in_NodeJS_con_Javascript\"><\/span><strong>6. Come invocare una http Get Request in NodeJS con Javascript<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Una volta definite tutte le <strong>http Get Request<\/strong> nel file server.js rimane il problema di come invocare da client la richiesta, e di come recuperare i dati, forniti da SQL Server, in una pagina html.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Innanzitutto, sempre nella stessa cartella creata per contenere il file server.js, crea anche il file index.html, copia e incolla il codice seguente in index.html:<\/p>\n\n\n\n<pre class=\"wp-block-code has-medium-font-size\"><code>&lt;html&gt;\n   &lt;head&gt;\n      &lt;meta charset=\"UTF-8\" \/&gt;\n      &lt;meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" \/&gt;\n      &lt;title&gt;Get request da NodeJs e SQL Server&lt;\/title&gt;\n\n      &lt;!-- Font-awesome and Google APIs &nbsp;<a href=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/i-vantaggi-dellutilizzo-di-sass-per-lo-sviluppo-web\/\">CSS<\/a>\u00a0 --&gt;\n      &lt;link rel=\"stylesheet\" href=\"https:\/\/fonts.googleapis.com\/css?family=Roboto|Varela+Round\" \/&gt;\n      &lt;link rel=\"stylesheet\" href=\"https:\/\/fonts.googleapis.com\/icon?family=Material+Icons\" \/&gt;\n      &lt;link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/font-awesome\/4.7.0\/css\/font-awesome.min.css\" \/&gt;\n\n      &lt;!-- Bootstrap CSS --&gt;\n      &lt;link rel=\"stylesheet\" href=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css\" \/&gt;\n\n      &lt;!-- JQuery CSS --&gt;\n      &lt;link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery-confirm\/3.3.4\/jquery-confirm.min.css\" \/&gt;\n      &lt;link rel=\"stylesheet\" href='https:\/\/cdn.datatables.net\/1.10.25\/css\/jquery.dataTables.min.css' \/&gt;\n      \n      &lt;link rel=\"stylesheet\" href='https:\/\/cdn.datatables.net\/buttons\/1.7.1\/css\/buttons.dataTables.min.css' \/&gt;\n      &lt;link rel=\"stylesheet\" href='https:\/\/cdn.datatables.net\/select\/1.3.3\/css\/select.dataTables.min.css' \/&gt;\n      &lt;link rel=\"stylesheet\" href='https:\/\/cdn.datatables.net\/datetime\/1.1.0\/css\/dataTables.dateTime.min.css' \/&gt;\n\n      &lt;!-- Datatables Buttons CSS --&gt;\n      &lt;link rel=\"stylesheet\" href='https:\/\/cdn.datatables.net\/buttons\/1.7.1\/css\/buttons.dataTables.min.css' \/&gt;\n\n      &lt;!-- Bootstrap Multiselect CSS --&gt;\n      &lt;link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/bootstrap-multiselect\/0.9.13\/css\/bootstrap-multiselect.css\"&gt;\n\n      &lt;!-- JQuery JS --&gt;\n      &lt;script src=\"https:\/\/code.jquery.com\/jquery-3.6.0.min.js\" integrity=\"sha256-\/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej\/m4=\" crossorigin=\"anonymous\"&gt;&lt;\/script&gt;\n      &lt;script src=\"https:\/\/cdn.datatables.net\/1.10.25\/js\/jquery.dataTables.min.js\"&gt;&lt;\/script&gt;\n      &lt;script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery-confirm\/3.3.4\/jquery-confirm.min.js\"&gt;&lt;\/script&gt;\n\n      &lt;!-- Bootstrap JS --&gt;\n      &lt;script src=\"https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js\"&gt;&lt;\/script&gt;\n\n      &lt;script src=\"https:\/\/cdn.datatables.net\/select\/1.3.3\/js\/dataTables.select.min.js\"&gt;&lt;\/script&gt;\n      &lt;script src=\"https:\/\/cdn.datatables.net\/datetime\/1.1.0\/js\/dataTables.dateTime.min.js\"&gt;&lt;\/script&gt;\n\n      &lt;!-- Bootstrap Multiselect JS --&gt;\n      &lt;script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/bootstrap-multiselect\/0.9.13\/js\/bootstrap-multiselect.js\"&gt;&lt;\/script&gt;\n\n      &lt;script src=\"https:\/\/cdn.datatables.net\/buttons\/1.7.1\/js\/dataTables.buttons.min.js\"&gt;&lt;\/script&gt;\n      \n      &lt;!-- Datatables Buttons JS --&gt;\n      &lt;script src=\"https:\/\/cdn.datatables.net\/buttons\/1.7.1\/js\/buttons.colVis.min.js\"&gt;&lt;\/script&gt;\n\n      &lt;script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jszip\/3.1.3\/jszip.min.js\"&gt;&lt;\/script&gt;\n      &lt;script src=\"https:\/\/cdn.datatables.net\/buttons\/1.7.1\/js\/buttons.print.min.js\"&gt;&lt;\/script&gt;\n      &lt;script src=\"https:\/\/cdn.datatables.net\/buttons\/1.7.1\/js\/buttons.html5.min.js\"&gt;&lt;\/script&gt;\n\n   &lt;\/head&gt;\n&lt;body&gt;\n   &lt;div class=\"table-responsive\"&gt;\n      &lt;table id=\"user_data\" class=\"table table-bordered\"&gt;\n         &lt;thead class=\"header-table\"&gt;\n            &lt;tr&gt;\n               &lt;th&gt;ID&lt;\/th&gt;\n               &lt;th&gt;NOME&lt;\/th&gt;\n               &lt;th&gt;COGNOME&lt;\/th&gt;\n            &lt;\/tr&gt;\n         &lt;\/thead&gt;\n      &lt;\/table&gt;\n   &lt;\/div&gt;  \n\n   &lt;script type=\"text\/javascript\" language=\"javascript\"&gt;\n      $(document).ready(function() {\n         var dataTable;\n         fetch_data();\n  \n         function fetch_data() {\n            dataTable = $('#user_data').DataTable({\n            dom: 'lrfBtip',\n            retrieve : true,\n            autoWidth : true,\n            responsive: true,        \n            fixedColumns: false,\n            processing : true,\n            serverSide : true,\n            select: true,\n            select: {style: 'single'},\n            paging: true,\n            PagingType: 'simple',\n            pageLength: 10,\n            order : &#91;],\n            ajax : {\n               url: 'http:\/\/localhost:5000\/GetAllStudents\/',\n               type:\"GET\"\n            }        \n        });\n   &lt;\/script&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;\n<\/code><\/pre>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Il codice presente all\u2019interno del file index.html \u00e8 suddiviso in 3 sezioni:<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>a)<\/strong> Nella prima sezione, e cio\u00e8, tutto il codice racchiuso tra i tag <strong>&lt;head&gt; <\/strong>e<strong> &lt;\/head&gt;<\/strong>, troviamo i comandi di inclusione di tutte le librerie javascript necessarie e recuperate dai loro rispettivi siti internet certificati. Per questo motivo il PC che eseguir\u00e0 index.html dovr\u00e0 essere necessariamente connesso a Internet.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>b)<\/strong> Nella seconda sezione, e cio\u00e8, tutto il codice racchiuso tra i tag <strong>&lt;div class=&#8221;table-responsive&#8221;&gt;<\/strong> eilsuo tag<strong> &lt;\/div&gt; <\/strong>di chiusura, troviamo il codice html di creazione della tabella html che ricever\u00e0 i dati richiesti a SQL Server tramite l\u2019invocazione della Get Request <strong>GetAllStudents<\/strong>.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\"><strong>c)<\/strong> Nella terza sezione, e cio\u00e8, tutto il codice racchiuso tra i tag <strong>&lt;script type=&#8221;text\/javascript&#8221; language=&#8221;javascript&#8221;&gt;<\/strong> eilsuo tag<strong> &lt;\/script&gt; <\/strong>di chiusura, troviamo il codice javascript che invoca la http Get Request <strong>GetAllStudents<\/strong> e sfrutta i dati richiesti a SQL Server per popolare la <strong>tabella HTML<\/strong>.<\/p>\n\n\n\n<p class=\"has-medium-font-size wp-block-paragraph\">Una volta copiato e incollato questo codice, all\u2019interno del file index.html, non ci resta che aprire questo file, con un browser qualsiasi, e al caricamento della pagina vedrai la tabella html popolarsi con i dati forniti dalla query SQL invocata da <strong>GetAllStudents<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In questa guida ti spiegher\u00f2 come creare un software gestionale gratis con SQL Server e NodeJS.<\/p>\n","protected":false},"author":1,"featured_media":7839,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,6,12,11],"tags":[3860,4544,4265,2255,2231,1683,1207,1454,1154,30,3881,678,31,34,74,1682,2116,73,1787,39,4742,2371,2364,2236,3356,2374,2237,1786,2362,2363,37,1156,28,1785,70,585,40],"class_list":["post-7832","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web-e-strumenti-operativi-per-lo-sviluppo-software","category-strumenti-per-il-web","category-recenti","category-sviluppo","tag-browser-it","tag-cloudflare","tag-driver","tag-estensione","tag-fare","tag-framework","tag-google","tag-gratis","tag-guida","tag-html","tag-html5","tag-internet","tag-java","tag-javascript","tag-jquery","tag-linux","tag-microsoft","tag-mysql","tag-new","tag-php","tag-programmazione","tag-prompt-dei-comandi","tag-query","tag-rete","tag-server","tag-server-web","tag-sistema","tag-software","tag-sql","tag-sql-server","tag-sviluppo","tag-tutorial","tag-url","tag-video","tag-web","tag-windows","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Come creare un software gestionale gratis con SQL Server e NodeJS<\/title>\n<meta name=\"description\" content=\"In questa guida ti spiegher\u00f2 come creare software gestionale gratis con SQL Server express, javascript e NodeJS\" \/>\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.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creare software gestionale gratis con SQL Server e NodeJS.\" \/>\n<meta property=\"og:description\" content=\"Dopo averti visto \u201ccome sviluppare web app con WordPress\u201d oggi ti spiegher\u00f2 come creare software gestionale gratis con SQL Server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/\" \/>\n<meta property=\"og:site_name\" content=\"Antonio Lamorgese\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-01T12:39:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-22T16:35:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Antonio Lamorgese\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Creare software gestionale gratis con SQL Server e NodeJS.\" \/>\n<meta name=\"twitter:description\" content=\"Dopo averti visto \u201ccome sviluppare web app con WordPress\u201d oggi ti spiegher\u00f2 come creare software gestionale gratis con SQL Server.\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@AntonioLamorge3\" \/>\n<meta name=\"twitter:site\" content=\"@AntonioLamorge3\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antonio Lamorgese\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minuti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"TechArticle\",\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/\"},\"author\":{\"name\":\"Antonio Lamorgese\",\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/#\\\/schema\\\/person\\\/264cf3af38edc93a3362a4c47ec5b2f0\"},\"headline\":\"Come creare un software gestionale gratis con SQL Server e NodeJS\",\"datePublished\":\"2021-10-01T12:39:00+00:00\",\"dateModified\":\"2023-11-22T16:35:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/\"},\"wordCount\":1494,\"publisher\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/#\\\/schema\\\/person\\\/264cf3af38edc93a3362a4c47ec5b2f0\"},\"image\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg\",\"keywords\":[\"browser\",\"cloudflare\",\"driver\",\"estensione\",\"fare\",\"framework\",\"google\",\"gratis\",\"guida\",\"html\",\"html5\",\"internet\",\"java\",\"javascript\",\"jquery\",\"linux\",\"microsoft\",\"mysql\",\"new\",\"php\",\"Programmazione\",\"prompt dei comandi\",\"query\",\"rete\",\"server\",\"server web\",\"sistema\",\"software\",\"sql\",\"sql server\",\"sviluppo\",\"tutorial\",\"URL\",\"video\",\"web\",\"windows\",\"wordpress\"],\"articleSection\":[\"Articoli\",\"In primo piano\",\"Recenti\",\"Sviluppo\"],\"inLanguage\":\"it-IT\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/\",\"url\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/\",\"name\":\"Come creare un software gestionale gratis con SQL Server e NodeJS\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg\",\"datePublished\":\"2021-10-01T12:39:00+00:00\",\"dateModified\":\"2023-11-22T16:35:20+00:00\",\"description\":\"In questa guida ti spiegher\u00f2 come creare software gestionale gratis con SQL Server express, javascript e NodeJS\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg\",\"contentUrl\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2021\\\/10\\\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg\",\"width\":800,\"height\":450,\"caption\":\"software gestionale gratis\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Sviluppo\",\"item\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/category\\\/sviluppo\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Come creare un software gestionale gratis con SQL Server e NodeJS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/#website\",\"url\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/\",\"name\":\"Antonio Lamorgese\",\"description\":\"Il web e i suoi strumenti operativi\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/#\\\/schema\\\/person\\\/264cf3af38edc93a3362a4c47ec5b2f0\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/#\\\/schema\\\/person\\\/264cf3af38edc93a3362a4c47ec5b2f0\",\"name\":\"Antonio Lamorgese\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ChiSono.png\",\"url\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ChiSono.png\",\"contentUrl\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ChiSono.png\",\"width\":120,\"height\":130,\"caption\":\"Antonio Lamorgese\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/ChiSono.png\"},\"description\":\"Amministratore di rete e sviluppatore. Dopo anni di esperienza nel settore, ho ideato un sistema di gestione dati MYSQL in PHP senza scrivere una sola riga di codice.&nbsp;Scopri di pi\u00f9....\",\"sameAs\":[\"https:\\\/\\\/www.Phpcodewizard.it\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/antonio-lamorgese-660735190\\\/\",\"https:\\\/\\\/pinterest.it\\\/antoniolamorgese9711\\\/\",\"https:\\\/\\\/x.com\\\/AntonioLamorge3\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/antoniolamorgese\",\"https:\\\/\\\/tumblr.com\\\/blog\\\/phpcodewizard\"],\"url\":\"https:\\\/\\\/www.phpcodewizard.it\\\/antoniolamorgese\\\/author\\\/antonio-lamorgese\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Come creare un software gestionale gratis con SQL Server e NodeJS","description":"In questa guida ti spiegher\u00f2 come creare software gestionale gratis con SQL Server express, javascript e NodeJS","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.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/","og_locale":"it_IT","og_type":"article","og_title":"Creare software gestionale gratis con SQL Server e NodeJS.","og_description":"Dopo averti visto \u201ccome sviluppare web app con WordPress\u201d oggi ti spiegher\u00f2 come creare software gestionale gratis con SQL Server.","og_url":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/","og_site_name":"Antonio Lamorgese","article_published_time":"2021-10-01T12:39:00+00:00","article_modified_time":"2023-11-22T16:35:20+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg","type":"image\/jpeg"}],"author":"Antonio Lamorgese","twitter_card":"summary_large_image","twitter_title":"Creare software gestionale gratis con SQL Server e NodeJS.","twitter_description":"Dopo averti visto \u201ccome sviluppare web app con WordPress\u201d oggi ti spiegher\u00f2 come creare software gestionale gratis con SQL Server.","twitter_image":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg","twitter_creator":"@AntonioLamorge3","twitter_site":"@AntonioLamorge3","twitter_misc":{"Scritto da":"Antonio Lamorgese","Tempo di lettura stimato":"9 minuti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"TechArticle","@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#article","isPartOf":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/"},"author":{"name":"Antonio Lamorgese","@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/#\/schema\/person\/264cf3af38edc93a3362a4c47ec5b2f0"},"headline":"Come creare un software gestionale gratis con SQL Server e NodeJS","datePublished":"2021-10-01T12:39:00+00:00","dateModified":"2023-11-22T16:35:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/"},"wordCount":1494,"publisher":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/#\/schema\/person\/264cf3af38edc93a3362a4c47ec5b2f0"},"image":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg","keywords":["browser","cloudflare","driver","estensione","fare","framework","google","gratis","guida","html","html5","internet","java","javascript","jquery","linux","microsoft","mysql","new","php","Programmazione","prompt dei comandi","query","rete","server","server web","sistema","software","sql","sql server","sviluppo","tutorial","URL","video","web","windows","wordpress"],"articleSection":["Articoli","In primo piano","Recenti","Sviluppo"],"inLanguage":"it-IT"},{"@type":"WebPage","@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/","url":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/","name":"Come creare un software gestionale gratis con SQL Server e NodeJS","isPartOf":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#primaryimage"},"image":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#primaryimage"},"thumbnailUrl":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg","datePublished":"2021-10-01T12:39:00+00:00","dateModified":"2023-11-22T16:35:20+00:00","description":"In questa guida ti spiegher\u00f2 come creare software gestionale gratis con SQL Server express, javascript e NodeJS","breadcrumb":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/"]}]},{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#primaryimage","url":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg","contentUrl":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2021\/10\/Creare-software-gestionale-gratis-con-SQL-Server-e-NodeJS.jpg","width":800,"height":450,"caption":"software gestionale gratis"},{"@type":"BreadcrumbList","@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/creare-software-gestionale-gratis-con-sql-server-e-nodejs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/en\/"},{"@type":"ListItem","position":2,"name":"Sviluppo","item":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/category\/sviluppo\/"},{"@type":"ListItem","position":3,"name":"Come creare un software gestionale gratis con SQL Server e NodeJS"}]},{"@type":"WebSite","@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/#website","url":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/","name":"Antonio Lamorgese","description":"Il web e i suoi strumenti operativi","publisher":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/#\/schema\/person\/264cf3af38edc93a3362a4c47ec5b2f0"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":["Person","Organization"],"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/#\/schema\/person\/264cf3af38edc93a3362a4c47ec5b2f0","name":"Antonio Lamorgese","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2019\/06\/ChiSono.png","url":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2019\/06\/ChiSono.png","contentUrl":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2019\/06\/ChiSono.png","width":120,"height":130,"caption":"Antonio Lamorgese"},"logo":{"@id":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-content\/uploads\/2019\/06\/ChiSono.png"},"description":"Amministratore di rete e sviluppatore. Dopo anni di esperienza nel settore, ho ideato un sistema di gestione dati MYSQL in PHP senza scrivere una sola riga di codice.&nbsp;Scopri di pi\u00f9....","sameAs":["https:\/\/www.Phpcodewizard.it\/","https:\/\/www.linkedin.com\/in\/antonio-lamorgese-660735190\/","https:\/\/pinterest.it\/antoniolamorgese9711\/","https:\/\/x.com\/AntonioLamorge3","https:\/\/www.youtube.com\/user\/antoniolamorgese","https:\/\/tumblr.com\/blog\/phpcodewizard"],"url":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/author\/antonio-lamorgese\/"}]}},"_links":{"self":[{"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/posts\/7832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/comments?post=7832"}],"version-history":[{"count":2,"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/posts\/7832\/revisions"}],"predecessor-version":[{"id":26235,"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/posts\/7832\/revisions\/26235"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/media\/7839"}],"wp:attachment":[{"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/media?parent=7832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/categories?post=7832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.phpcodewizard.it\/antoniolamorgese\/wp-json\/wp\/v2\/tags?post=7832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}