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...
How to Set Up a MySQL Master-Slave Replication in Docker
Hey there! Ever wanted to build your own mini MySQL backup server, but worried it'd be a total...
SQL Complete guide for Interview
Structured Query Language or SQL is a standard database language that is used to create, maintain,...
Installing and Configuring MySQL on Arch Linux
MySQL, a robust and widely used relational database management system, serves as a cornerstone for...
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...
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 PHP CRUD Application with OOP and MySQL: A Best Practice Guide
When developing PHP applications, managing database operations effectively is crucial. One of the...
How MySQL Tuning Improves the Laravel Performance
MySQL Configuration tuning is an important component of database management implemented by database...
📂 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...
SQL Basic Question for interview
Let's come to the point. I have created an Awesome SQL Interview GitHub repo to prepare for...
Beginner's Guide to CRUD Operations in PHP
Introduction PHP is a flexible and widely-used server-side scripting language that powers...
How to inject simple dummy data at a large scale in MySQL
Introduction Ever found yourself in a situation where you needed a large amount of dummy...
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...
Filtering in JOIN or WHERE in MySQL: Differences and Performance Impact
📑 About The decision of where to apply a filter in an SQL query, either in JOIN or WHERE,...
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...
Connecting AWS RDS to Spring Boot
Introduction In this article, I will walk through the process of setting up an AWS RDS...
MySQL Performance Monitoring and Query Analysis
MySQL Performance Monitoring and Query Analysis In this guide, we will explore various...
A Straightforward Guide for MySQL Locks
In this article, I aim to introduce you to the common and fundamental locks in InnoDB. If you're not...
Migrating from MySQL to PostgreSQL
Migrating a database from MySQL to Postgres is a challenging process. While MySQL and Postgres do 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...
Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀
Hey everyone! I'm excited to share some significant progress on the PolyDisease Predictor, a...
Enterprise-Level Authentication in a Containerized Environment for NextJS 13
Enterprise-Level Authentication in a Containerized Environment for NextJS 13 ...
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...
How to Check MySQL Database and Table Sizes
From modest few-megabyte databases perfect for small-scale applications to behemoths spanning several...
Step-by-step guide for how to install an SQL server on Ubuntu 22.04
Step-by-step guide for how to install an SQL server on Ubuntu 22.04 Installing...