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 1 - MySQL vs PostgreSQL: Connection Architecture

Part 1 - MySQL vs PostgreSQL: Connection Architecture

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

Transactions, Deadlocks & Log-Based Recovery in SQL

Comments
2 min read
Database Normalization in MySQL (1NF 2NF 3NF) – Simple Example

Database Normalization in MySQL (1NF 2NF 3NF) – Simple Example

1
Comments
3 min read
Cursor and Trigger

Cursor and Trigger

Comments
2 min read
TRANSACTION IN DBMS

TRANSACTION IN DBMS

Comments
2 min read
Indexing, Hashing & Query Optimization in SQL

Indexing, Hashing & Query Optimization in SQL

Comments
4 min read
Cursors and Triggers

Cursors and Triggers

Comments
3 min read
Nextjs Todo Application Using Mysql and Terraform

Nextjs Todo Application Using Mysql and Terraform

Comments
6 min read
CRUD Operations in MongoDB: Hands-On with a Student Collection

CRUD Operations in MongoDB: Hands-On with a Student Collection

2
Comments
2 min read
Scaling to 300K+ Records Daily: How We Handle High Volume Data Processing with Lumen & MySQL

Scaling to 300K+ Records Daily: How We Handle High Volume Data Processing with Lumen & MySQL

Comments
3 min read
MySQL Storage Engines, Transactions, and Foreign Keys

MySQL Storage Engines, Transactions, and Foreign Keys

1
Comments
3 min read
mysqld Crashes with Signal 11 and Page Corrupt Error

mysqld Crashes with Signal 11 and Page Corrupt Error

Comments 1
4 min read
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
loading...