A database is a structured set of data, and the most common type you'll encounter in web hosting environments is a relational database. In this module, we’ll cover practical administration of MySQL/MariaDB using the command line on cPanel-powered ser...
Today marks a milestone in my #90DaysOfCloud challenge, as I successfully built and deployed a 3-tier web application architecture on AWS, designed with best practices for security, modularity, and scalability. This blog details every major configura...
After learning the basics of MySQL, today I deep-dived into the advanced features of SQL — the kind that powers real-world applications like WordPress and large-scale cloud-native systems. Understanding advanced MySQL is essential for anyone building...
Today I rolled up my sleeves and dove into MySQL, a powerful relational database used by millions of applications. In this blog, I’ll show you: What MySQL is & why it’s essential How to install MySQL on EC2 How to configure MySQL securely CRUD op...
A Milestone Moment for SkySQL and the MariaDB Community Today we announced the launch of SkySQL Inc., a strategic spin-off from MariaDB plc, dedicated to delivering the best fully managed MariaDB experience in the cloud. This allows us to focus exclu...
This guide walks you through deploying a simple Flask web app connected to a MariaDB database on a free-tier Amazon EC2 instance running Amazon Linux 2023. Prerequisites An AWS account EC2 instance (Amazon Linux 2023) Security group with port 5000...
When working with text data in MySQL, simple queries often fall short when you need to filter or validate complex patterns. This is where regular expressions (REGEXP) shine — providing a powerful way to search, match, and manipulate text based on fle...
Se você trabalha com sistemas que utilizam MySQL com engine MyISAM, pode eventualmente se deparar com erros de corrupção de tabelas — especialmente após travamentos, quedas de energia ou falhas de disco. Neste artigo, você vai aprender a recuperar es...
For developers, analysts, and database professionals working with MySQL, mastering aggregate functions is non-negotiable. A comprehensive guide published by Devart provides a thorough breakdown of how to use COUNT(), SUM(), AVG(), MIN(), and MAX() to...
All code and resources for this post are available on GitHub. You can follow along by cloning the repository! Last semester in my Computer Science studies, we built a small backend with PHP. To get started, we used XAMPP — just like I did more than ...
