MySQL – How to create a DB

By | 21/01/2020

In this post, we will see how to create a DB in MySQL, using MySQLWorkbench.First of all, we open MySQLWorkbench, select our MySQL instance and we insert the password: CREATE DBWe push on the “new schema” icon, insert the Db name “DbManagerUser” and then we push the Apply button: CREATE TABLESWe select the new schema… Read More »

MySQL – How to install on Win

By | 17/01/2020

In this post, we will see how to install and configure MySQL on Windows.We open a browser, go to https://dev.mysql.com/downloads/mysql/ and we download the latest version of MySQL (we select MySQL Installer MSI): Then, we double click on the MSI file for starting the installation: Now, we select the Custom installation: and then, we select… Read More »

Python – How to create a RESTful service

By | 14/01/2020

In this post, we will see how to create a RESTful service for handling data of some Dogs, with Python and Flask. First of all, what Flask is?From Wikipedia:“Flask is a micro web framework written in Python. It is classified as a microframework because it does not require particular tools or libraries.It has no database abstraction layer, form validation, or any… Read More »

MySQL – How to install on macOS

By | 10/01/2020

From Wikipedia:“MySQL is an open-source relational database management system (RDBMS).Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and SQL, the abbreviation for Structured Query Language.MySQL is free and open-source software under the terms of the GNU General Public License, and is also available under a variety of proprietary licenses. MySQL was owned and sponsored by the Swedish company MySQL AB, which was bought… Read More »

Node.js – How to use pipe()

By | 07/01/2020

In this post, we will see how pipe works and how we can use it. First of all, what is a pipe?The pipe() function reads data from a readable stream as it becomes available and writes it to a destination writable stream.In the previous post Node.js – Streams, we have read a file and we… Read More »

Python – How to connect to SQL Server

By | 20/12/2019

In this post, we will see how to connect Python to SQL Server. First of all, we create a database called DBTestPython and then, we run some sql scripts in order to create two tables and feeding them with some test data: TABTYPE: TABUSER: FEED DATA: Now, in order to connect Python to a Sql… Read More »

React – How to create a menu

By | 17/12/2019

In this post, we will see how to create a menu in React, using React Router. First of all, we create an application called manage_user, using the command:npx Create-react-app manage_userand then, using the command npm i react-router-dom –save, we will install React Router We start to create a component called menu: [MENU.JS] Then, we add… Read More »