Forem

# 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.
Cursor + Trigger in MySQL

Cursor + Trigger in MySQL

1
Comments
2 min read
NORMALIZATION
Cover image for 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
Production-Ready MySQL Backup Script (with Compression and AWS Upload)
Cover image for Production-Ready MySQL Backup Script (with Compression and AWS Upload)

Production-Ready MySQL Backup Script (with Compression and AWS Upload)

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

Transactions, Deadlocks & Log-Based Recovery in MySQL

Comments
2 min read
Lesson 3  - Integrating MySQL (First Database)
Cover image for Lesson 3  - Integrating MySQL (First Database)

Lesson 3  - Integrating MySQL (First Database)

1
Comments 1
3 min read
How I Optimized a Laravel API 287x Faster: From 27s to Under 100ms
Cover image for 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
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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for Unlock PostgreSQL Performance: A Practical Tuning Guide

Unlock PostgreSQL Performance: A Practical Tuning Guide

Comments
4 min read
loading...