Node.js – How to connect to MySQL

By | 04/03/2020

In this post, we will see how to connect a Node application with the MySQL Db called “DbManagerUser”, created in the post: MySQL – How to create a DB. First of all, we open Visual Studio Code, we open a terminal and we install the MySQL Module, using the command npm install mysqlThen, we create an… Read More »

Angular – How to pass values between components using query string

By | 26/02/2020

In this post, we will see how to pass data between components, using query string.We start creating a project called PassData and installing Angular Material as well:ng new PassDatang add @angular/material Then, we create three components called “Page1”, “Page2” and “Page3”:ng g c Pages/Page1ng g c Pages/Page2ng g c Pages/Page3 Finally, we create an entity… Read More »

Python – How to connect to MySQL

By | 05/02/2020

In this post, we will see how to connect a Python application with the MySQL Db called “DbManagerUser”, created in the post: MySQL – How to create a DB. First of all, in order to install the MySQL connector for Python, we run the command pip install mysql-connector-python. Then, we open Visual Studio Code and… Read More »

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 »