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.
Types of Databases: A Developer’s Overview

Types of Databases: A Developer’s Overview

Comments
2 min read
Country Data API

Country Data API

2
Comments
4 min read
Unlock PostgreSQL Performance: A Practical Tuning Guide

Unlock PostgreSQL Performance: A Practical Tuning Guide

Comments
4 min read
normalization

normalization

Comments
2 min read
MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

Comments
2 min read
MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

Comments
2 min read
🚀 Supercharge Your Laravel App: Master Multiple Databases in Laravel 12!

🚀 Supercharge Your Laravel App: Master Multiple Databases in Laravel 12!

Comments
1 min read
5 Steps to Optimize MySQL Deep Pagination

5 Steps to Optimize MySQL Deep Pagination

Comments
4 min read
MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

Comments
2 min read
Indexing and Query Optimization in Laravel

Indexing and Query Optimization in Laravel

Comments
2 min read
SQL Database Concepts:

SQL Database Concepts:

Comments
1 min read
concat() vs Group_concat()

concat() vs Group_concat()

1
Comments
1 min read
Database index tutorial with MYSQL

Database index tutorial with MYSQL

1
Comments
3 min read
MongoDB vs MySQL: A Real-World Performance Showdown Using Disneyland Data

MongoDB vs MySQL: A Real-World Performance Showdown Using Disneyland Data

Comments
4 min read
How to Deploy Your Node.js + MySQL App for Free Using Render and TiDB Cloud

How to Deploy Your Node.js + MySQL App for Free Using Render and TiDB Cloud

3
Comments
4 min read
Memilih Primary Key, INT Auto Increment vs UUID

Memilih Primary Key, INT Auto Increment vs UUID

1
Comments
2 min read
Part 2 - MySQL vs PostgreSQL: Storage Architecture

Part 2 - MySQL vs PostgreSQL: Storage Architecture

Comments
10 min read
Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

5
Comments 2
3 min read
SQL LIKE Operator: What It Is, How It Works, and Best Practices

SQL LIKE Operator: What It Is, How It Works, and Best Practices

Comments
2 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

1
Comments 1
14 min read
🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

Comments
2 min read
🌏 Nusantara-API 🇮🇩 — from MySQL dump to a tiny 420 KB library

🌏 Nusantara-API 🇮🇩 — from MySQL dump to a tiny 420 KB library

Comments
1 min read
How MySQL Actually Works: A Deep Dive into Database Internals

How MySQL Actually Works: A Deep Dive into Database Internals

4
Comments
16 min read
SQL Commands Guide

SQL Commands Guide

Comments 3
4 min read
100 Days of DevOps: Day 66

100 Days of DevOps: Day 66

1
Comments
3 min read
loading...