Articles by Tag #mysql
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
Postgres vs. MySQL
Hello I'm Brandon, I’m the CEO & Co-founder of Outerbase, where we are building a modern data...
Dockerizing a Golang API with MySQL and adding Docker Compose Support
Developing and testing APIs locally connected to a database is no joke. The database often becomes a...
SQL Complete guide for Interview
Structured Query Language or SQL is a standard database language that is used to create, maintain,...
True Alphanumeric / natural sorting in MySQL - why is the answer always recursion?
Yesterday I attempted to solve alphanumeric sorting in MySQL and failed. (read that article here) I...
Alphanumeric / Natural sort in MySQL - 30 years and we still can't do this? 😤
Our QA team are absolute monsters, they're monsters I tell you! No matter how much I try to bribe...
Dockerizing a Laravel App: Nginx, MySql, PhpMyAdmin, and Php-8.2
What is Docker? Docker is an open-source platform that enables developers to automate the...
Building a PHP CRUD Application with OOP and MySQL: A Best Practice Guide
When developing PHP applications, managing database operations effectively is crucial. One of the...
Choosing the Right Database for Your Project: Beyond Personal Experience
Hello, fellow developers!🧑🏼💻 When architecting a new project and selecting a database type,...
📂 Building a Simple File Management System with PHP & MySQL 🚀
Hello, Dev Community! 👋 Today, I want to share with you my journey of creating a File Management...
Building a Simple CRUD Application with PHP and MySQL
PHP and MySQL have been my go-to for developing dynamic web applications. If you're just getting...
How MySQL Tuning Improves the Laravel Performance
MySQL Configuration tuning is an important component of database management implemented by database...
SQL Basic Question for interview
Let's come to the point. I have created an Awesome SQL Interview GitHub repo to prepare for...
Setting Up a PHP Website on EC2 with Nginx, MySQL, PHP, and Git
This guide will walk you through the process of setting up a PHP website on an Amazon EC2 instance...
Accessing MySQL Server from a Remote Machine in the Same Network
Overview This guide explains how to connect to a MySQL server running on a local network...
Migrating from MySQL to PostgreSQL
Migrating a database from MySQL to Postgres is a challenging process. While MySQL and Postgres do a...
Connecting AWS RDS to Spring Boot
Introduction In this article, I will walk through the process of setting up an AWS RDS...
SQL vs. NoSQL | Schema Design Differences Explained Visually
When planning a new application, one of the first things to figure out is how your data will be...
Beginner’s Guide to Designing a Relational Database Schema
Setting up the structure of your database is one of the first and most critical things to get right...
Automate MySQL Backups with CRON Jobs in cPanel
Data loss is every website owner's nightmare. Regular database backups ensure that your data is safe...
Triggers in MySQL: Benefits and Drawbacks
MySQL triggers are powerful database objects that automatically execute when specific events occur on...
Best MySQL Database Design Tools in 2025
Planning a new MySQL project? A good database design tool can help you move faster, stay organized,...
Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀
Hey everyone! I'm excited to share some significant progress on the PolyDisease Predictor, a...
Cómo instalar MySQL en una instancia EC2 con Amazon Linux 2023
¿Estás trabajando con una instancia EC2 usando Amazon Linux 2023 y necesitas MySQL? A diferencia de...
Mastering PHP and MySQL: An Extensive Guide for Modern Developers
Mastering PHP and MySQL: An Extensive Guide for Modern Developers 🚀 PHP and MySQL form the backbone...
Run a Local 💻 MySQL 🐬 Instance
This document describes how to run a MySQL instance locally with Docker and how to add it as an...
⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥
Here's how to quickly set up a development environment with MySQL, PostgreSQL, MongoDB, Redis and...
Create New User in MySQL & Grant Access
Creating a new user in MySQL and granting privileges is very easy. First, you have to open the MySQL...
🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)
Hey folks 👋 I’m Capwell, and I recently had to migrate a MySQL database to PostgreSQL. It wasn’t a...
20 Livros sobre Linguagem SQL que você deveria ler
Na série #QueroLer de hoje conheceremos 20 livros de qualidade para aprender Linguagem SQL. Eles...
The Best Tools to Design Database Schemas Visually in 2025
If you’ve worked with databases, you’ve probably run into messy, confusing schemas-tables with...