MySQL Security: Best practices for Protecting Sensitive Data.
This article will give you the best practices for securing a MySQL installation and protecting sensitive data in your database.
MySQL
Best practices for optimizing MySQL database performance.
In this article, we will discuss some best practices for optimizing MySQL database performance, and we’ll talk about some top recommendations for improving MySQL database speed.
Automating Your MySQL Database with Triggers
This article presents an overview of triggers in MySQL and shows how to use them to automate tasks and simplify your MySQL database management.
How to use ON DELETE CASCADE in MySQL
In this post, we’ll look at how MySQL’s ON DELETE CASCADE feature works and how you can manage your database better.
MySQL + Event Scheduler: How to delete data from MYSQL table using Event Scheduler
This article aims to show you how to use MySQL Event Scheduler to schedule a DELETE query to remove data automatically from a MySQL table at a specific time and date or at regular intervals.
Using MySQL Event Scheduler: A Complete Guide
This article will show you how to create and use MySQL Event Scheduler to automatize your database management.
How to add Custom Error Handler Middleware to your Node.js/Express API
This post will discuss Error Handling and show you how to write and set up your own custom Error handler middleware function in Node.js/Express.js API.
Node.js + MySQL : Add Forgot/Reset Password to Login-Authentication System.
This tutorial will show you how to add and implement a forgot and reset password feature to your MySQL + node.js API by using the Nodemailer module to send an email link to the user account and allow him to reset his password when he forgets it securely.
Complete JWT Authentication and Authorization System for MySQL/Node.js API
This article will implement a complete authentication and authorization system with JWT to add a security layer to access protected routes within our MySQL/Node.js API.
How to implement Many-To-Many association in MySQL/Node.js API using async/await
This article provided a step-by-step tutorial showing how to easily implement a Many-To-Many association in MySQL/Node.js API using async/await calls.