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.
Part 3 - MySQL vs PostgreSQL: Features & Capabilities Comparison

Part 3 - MySQL vs PostgreSQL: Features & Capabilities Comparison

Comments
8 min read
Database index tutorial with MYSQL

Database index tutorial with MYSQL

Comments
3 min read
Partition-Based Parallel Data Loading: An Architectural Practice for Improving Mass Data Import Efficiency

Partition-Based Parallel Data Loading: An Architectural Practice for Improving Mass Data Import Efficiency

Comments
6 min read
Solving Database Performance Bottlenecks in Node + MySQL

Solving Database Performance Bottlenecks in Node + MySQL

Comments
3 min read
Synchronizing Data from MySQL to PostgreSQL Using Apache SeaTunnel

Synchronizing Data from MySQL to PostgreSQL Using Apache SeaTunnel

Comments
6 min read
How to Connect MySQL Database with Selenium Tests in C#

How to Connect MySQL Database with Selenium Tests in C#

5
Comments 1
2 min read
MySQL Deadlock Detection: How to Find and Fix Transaction Conflicts

MySQL Deadlock Detection: How to Find and Fix Transaction Conflicts

5
Comments
8 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

4
Comments
4 min read
MariaDB failed to start because both Aria and InnoDB

MariaDB failed to start because both Aria and InnoDB

Comments
1 min read
My Dev Journey Began with a Music Site

My Dev Journey Began with a Music Site

Comments
2 min read
SQL Commands Guide

SQL Commands Guide

Comments 1
4 min read
Indexing, Hashing & Query Optimization

Indexing, Hashing & Query Optimization

1
Comments
2 min read
TRANSACTION

TRANSACTION

Comments
2 min read
What can go wrong when using database transactions?

What can go wrong when using database transactions?

Comments
3 min read
How to Import a MySQL Database Using Command Line

How to Import a MySQL Database Using Command Line

1
Comments
2 min read
"Database Normalization Explained: 1NF 3NF with SQL Example"

"Database Normalization Explained: 1NF 3NF with SQL Example"

Comments
2 min read
Cursor + Trigger in MySQL

Cursor + Trigger in MySQL

1
Comments
2 min read
NORMALIZATION

NORMALIZATION

1
Comments
3 min read
Lessons from a MySQL Migration: What We Learned and How to Do It Better Next Time

Lessons from a MySQL Migration: What We Learned and How to Do It Better Next Time

Comments
6 min read
Transactions, Deadlocks & Log-Based Recovery in MySQL

Transactions, Deadlocks & Log-Based Recovery in MySQL

Comments
2 min read
"Indexing, Hashing & Query Optimization with MySQL — Students Table Example"

"Indexing, Hashing & Query Optimization with MySQL — Students Table Example"

Comments
3 min read
Transactions, Deadlocks & Log-Based Recovery in MySQL

Transactions, Deadlocks & Log-Based Recovery in MySQL

Comments
2 min read
How I Optimized a Laravel API 287x Faster: From 27s to Under 100ms

How I Optimized a Laravel API 287x Faster: From 27s to Under 100ms

Comments
3 min read
ACID Properties

ACID Properties

Comments
2 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

8
Comments 2
3 min read
loading...