Registration form with RDS AWS database and facial recognition via OpenCV
The algorithm performs a simple user registration (Name, CPF, E-mail and Telephone) in an Amazon RDS database and also performs the storage, training and facial recognition of the user's face to identify the users already registered in the system in a next time the user is seen.
Requirements
You will need to install the libraries below:
- numpy
- OpenCV
- mysql-connector
Creating RDS-MySQL instance on AWS
- Access the "AWS Management Console"
- Open the services menu and select the RDS option
- Select the "Create database" option
- Select MySQL
- Version: MySQL 8.0.11 -> Free tier
- Enter the basic data, username and password:
db instance: "database name"
username: "your username"
password: "your password"
- DB instance size and Storage is default not to mess
- VPC: Default
- Subnet group: default
- Public access: Yes
- VPC security group: Create new
New VPC security group name: <enter_com_the_name>
- Availability Zone: choose where you are connected
Operation
When the code is run, the menu below will be presented with the options for registration and identification: 
Option 1
If option 1 is selected, some fields will be presented for filling in the new registration as shown below: 
After completing the new registration in our database, the face recognition screen will be presented.
On this screen we have the option to register a new user photo (space key), perform the training (letter t), or log out (letter q). Pressing the 'space' key on the keyboard, we will capture the photos to perform the training later. 
By pressing 'space' a folder will be created called 'USER' and inside it will be created a folder with the name previously registered, inside that folder will be stored all the photos of the user that we just registered. In the case of a new registration, another folder will be created automatically with the name registered within the 'USER' folder. 
Now the time has come to carry out the training of our algorithm for it to recognize the registered user through the photos taken. To do this, press the 't' key on the same screen where we took the capture. The algorithm will be trained and the name of the registered user will be presented directly in the facial recognition layer. 
Option 2
When the code is run, the menu below will be presented with the options for registration and identification:
If option 2 is selected, the face recognition screen will be presented to the user. 
As in this case we already have our user registered in our database in the cloud, it will only be necessary to press the 't' key to run the training algorithm so that he can recognize the user's face and present his name. 
Validating the registration via MySQL Workbench
We use MySQL Workbench to validate that our registered user was successfully registered 
7 Aug 27, 2021
53 Jan 5, 2023
26 Dec 7, 2022
2 Feb 11, 2022
22 Dec 26, 2022
1 Oct 13, 2021
7 Mar 24, 2022
11 Nov 1, 2022
57 Dec 18, 2022
3 Sep 24, 2022
9 Oct 17, 2022
25 Nov 24, 2022
5 Dec 25, 2021
9 Dec 14, 2022
1.1k Jan 08, 2023
48 Dec 19, 2022
90 Dec 15, 2022
23 Nov 09, 2022
9 Oct 24, 2021
6 May 30, 2022
199 Dec 27, 2022
29 Aug 30, 2021
12 Sep 12, 2022
4 Mar 28, 2022
2 Jun 10, 2022
63 Dec 14, 2022
1 Dec 14, 2021
2 Jan 16, 2022
1 Nov 30, 2021