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.
🧨 The Hotel California of Managed Services: How DigitalOcean Trapped My 800GB Database

🧨 The Hotel California of Managed Services: How DigitalOcean Trapped My 800GB Database

Comments
4 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

5
Comments 2
5 min read
How to Connect a PHP Script to MySQL: A Step-by-Step Guide

How to Connect a PHP Script to MySQL: A Step-by-Step Guide

Comments
4 min read
Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Comments 2
4 min read
How to use EXPLAIN to fix slow queries in MySQL

How to use EXPLAIN to fix slow queries in MySQL

8
Comments
6 min read
SQLife - a new Oracle/PostgreSQL/MySQL Client

SQLife - a new Oracle/PostgreSQL/MySQL Client

1
Comments
2 min read
🧩 Questions about general web development. (Share your knowledge)

🧩 Questions about general web development. (Share your knowledge)

1
Comments
1 min read
Can PostgreSQL Be a Search Engine? Yes, You Might Not Need Elasticsearch

Can PostgreSQL Be a Search Engine? Yes, You Might Not Need Elasticsearch

6
Comments
10 min read
Create A Data Analyst Agent In PHP - NeuronAI MySQL Toolkit

Create A Data Analyst Agent In PHP - NeuronAI MySQL Toolkit

Comments 2
9 min read
SQL Fundamentals for Beginners

SQL Fundamentals for Beginners

Comments
4 min read
Health Check for MySQL in a Docker Container

Health Check for MySQL in a Docker Container

Comments
2 min read
Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

1
Comments
3 min read
Indexing in MySQL for PHP Developers: Do’s and Don’ts

Indexing in MySQL for PHP Developers: Do’s and Don’ts

1
Comments
6 min read
Build a Full Stack React CRUD App with Node.js, Express & MySQL: Step-by-Step Guide

Build a Full Stack React CRUD App with Node.js, Express & MySQL: Step-by-Step Guide

2
Comments 2
3 min read
A School Hub, My native PHP project!

A School Hub, My native PHP project!

Comments 2
1 min read
Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀

Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀

11
Comments 1
2 min read
🚀 Auto-Generate Sequelize Models and Migrations with StackRender

🚀 Auto-Generate Sequelize Models and Migrations with StackRender

4
Comments 2
2 min read
Understanding numeric types in Laravel migration schemas: Integer, Float, Decimal, Double

Understanding numeric types in Laravel migration schemas: Integer, Float, Decimal, Double

Comments
1 min read
Advanced Strategies for Proactive MySQL Performance Optimization

Advanced Strategies for Proactive MySQL Performance Optimization

5
Comments
7 min read
Tired of writing repetitive MySQL code in Node.js? Here’s a simple helper I built! - mysql2-helper-lite

Tired of writing repetitive MySQL code in Node.js? Here’s a simple helper I built! - mysql2-helper-lite

Comments
1 min read
Cracking MySQL Performance: What is Indexing and Why It Matters

Cracking MySQL Performance: What is Indexing and Why It Matters

2
Comments
2 min read
What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

What's New in MySQL 9 🧐 - a DBA's Perspective 🥸

8
Comments
9 min read
Implementing Role-Based Access Control (RBAC) in MySQL

Implementing Role-Based Access Control (RBAC) in MySQL

4
Comments
3 min read
How to Fix "MySQL Unexpected Shutdown" in XAMPP (Easy Step-by-Step Guide)

How to Fix "MySQL Unexpected Shutdown" in XAMPP (Easy Step-by-Step Guide)

1
Comments
2 min read
SQL JOINs Explained: Connecting Data Across Tables

SQL JOINs Explained: Connecting Data Across Tables

Comments
6 min read
loading...