DEV Community

# mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
🚀 Optimizing Costs Without Downtime: My Hands-On Experience Downgrading AWS Lightsail; A Step-by-Step Journey

🚀 Optimizing Costs Without Downtime: My Hands-On Experience Downgrading AWS Lightsail; A Step-by-Step Journey

Comments
4 min read
How I Built a Complete Invoice Management API with Spring Boot

How I Built a Complete Invoice Management API with Spring Boot

Comments
5 min read
Indexes in MySQL: How long do you wait before calling an index "unused"?

Indexes in MySQL: How long do you wait before calling an index "unused"?

5
Comments
1 min read
Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Comments
2 min read
Clean and Compare Strings in SQL with TRIM

Clean and Compare Strings in SQL with TRIM

Comments
2 min read
How to deploy phpMyAdmin with Docker Compose and Traefik in 5 Minutes

How to deploy phpMyAdmin with Docker Compose and Traefik in 5 Minutes

Comments
2 min read
SQL IQ – Advanced SQL Interview Queries Search and Prep System

SQL IQ – Advanced SQL Interview Queries Search and Prep System

1
Comments
4 min read
5 SQL Join Mistakes I Made as a Learner (and How I Fixed Them)"

5 SQL Join Mistakes I Made as a Learner (and How I Fixed Them)"

Comments
3 min read
How to Solve MySQL and Redis Cache Inconsistency Like a Pro

How to Solve MySQL and Redis Cache Inconsistency Like a Pro

7
Comments
2 min read
Implementing Transactional Tests with MySQL

Implementing Transactional Tests with MySQL

Comments
6 min read
MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾

MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾

5
Comments 1
3 min read
🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

1
Comments
10 min read
What is Error Code 1451 in MySQL

What is Error Code 1451 in MySQL

Comments
1 min read
Integrating Python with MySQL Databases: An Introduction and Practical Guide

Integrating Python with MySQL Databases: An Introduction and Practical Guide

Comments
12 min read
SQL DATABASE

SQL DATABASE

Comments
1 min read
SQL Tricks: Generate Calendar Table

SQL Tricks: Generate Calendar Table

Comments
5 min read
How to Count Daily Records with MySQL

How to Count Daily Records with MySQL

Comments
1 min read
How to Duplicate Rows in MySQL

How to Duplicate Rows in MySQL

Comments
2 min read
Building an Accessible School Management Portal: Lessons from My Web Dev Journey

Building an Accessible School Management Portal: Lessons from My Web Dev Journey

Comments
2 min read
MySQL 5.7 - 8.0 on Google CloudSQL: Inplace Migration

MySQL 5.7 - 8.0 on Google CloudSQL: Inplace Migration

Comments
6 min read
MySQL Data Synchronization to S3file and Hive Access: A SeaTunnel Practical Guide

MySQL Data Synchronization to S3file and Hive Access: A SeaTunnel Practical Guide

Comments
3 min read
Why Graph Databases Like Neo4j Are the Future of AI Data Modeling

Why Graph Databases Like Neo4j Are the Future of AI Data Modeling

Comments
2 min read
Visualize Data with Amazon QuickSight

Visualize Data with Amazon QuickSight

Comments
2 min read
🛠️ Como Recuperar um Banco de Dados MySQL/MariaDB Usando .ibd e .frm no XAMPP

🛠️ Como Recuperar um Banco de Dados MySQL/MariaDB Usando .ibd e .frm no XAMPP

Comments
4 min read
Using CASE to Sort ENUM Values in MySQL

Using CASE to Sort ENUM Values in MySQL

1
Comments
2 min read
loading...