Youtube videotutorial source from Automation Step by Step : https://www.youtube.com/watch?v=TMGHOW8Hzvw
For this example, we will use this website to create our free MySQL database: https://www.freesqldatabase.com/
Scrolling down in the home page we find the 2 subscription modalities, let’s register into the free version of this online database
Once we register, the system will ask about which region location should we use, in our case is Europe (Mainland)
After selection our GDPR location, we can proceed and click on “Start new database” button.
And we can see how the data base has been created.
We will get an email with all details to connect to our database:
Host: sql11.freesqldatabase.com
Database name: ********
Database user: ********
Database password: ********
Port number: 3306
For database administration, to created tables, insert data, update or delete data, etc
We can use the online version of phpMyAdmin: https://www.phpmyadmin.co/
Now let create our Products Table with this structure, where product description and picture are links from the original seller website.
| ID | Name | Description | Price | Picture | Brand | Category | Country |
| 00001 | TERRA SERVER 3030 G5 E-2324G/16/2X960/C/WS2022E | https://terra-pc-shop24.de/terra-server-3030-g5-e-2324g-16-2×960-c-ws2022e-200.html | 2.729,00 € | https://terra-pc-shop24.de/media/catalog/product/cache/1/image/9df78eab33525d08d6e5fb8d27136e95/i/t/item110093010000.jpg | Terra | PC Server | Germany |
| 00002 | TERRA MOBILE 1551P I5-1240P W11P | https://terra-pc-shop24.de/terra-mobile-1551p-i5-1240p-w11p-279.html | 999,00 | https://terra-pc-shop24.de/media/catalog/product/cache/1/image/9df78eab33525d08d6e5fb8d27136e95/i/t/item122073110000.jpg | Terra | Laptop | Germany |
And let’s insert 2 products from a German computer distributor called Terra
In the next How-to, we will create a backend on Express.js with APIs to manage our new database from an Angular 17 project
Express is a minimal and flexible Node.js web application framework that provides a robust set of features for web and mobile applications. APIs.
Leave a Reply