MySQL.tsx

What do I know?

High Performance - Replication - Scalability
MySQL icon

MySQL

Proficiency94%
Experience2+ years

Overview

My standard relational database for most applications. Due to its greater simplicity compared to PostgreSQL and good speed, it is my go-to choice most of the time. I have had extensive professional experience with this specific database, ranging from efficient schema modeling to complex relationships and query optimization.

Tools & Libraries

ACIDOptimizationRelational ModelingIndexingReplicationStored Procedures

Highlights

Web Application
Login System
Login system developed using NestJS for the backend and NextJS for the frontend. The goal was to understand how this type of system works, including the involved security logic and features such as token generation and renewal, user registration, password reset and recovery.
Messaging Systems
Chat System
Project developed in Python using the terminal as the interface. The goal was to understand how this type of system works, which uses the socket protocol. It includes a simple login, user creation, user configuration interactions, and group and individual chats.
Databases
Relational Database Experience
The database I reach for in most of my projects, especially for its speed and simplicity compared to Postgres. During my experience at Giovanella, working on the system's back-end, I took on a range of database responsibilities, from creating and maintaining tables to more complex queries.