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.
How to use EXPLAIN to fix slow queries in MySQL
Cover image for How to use EXPLAIN to fix slow queries in MySQL

How to use EXPLAIN to fix slow queries in MySQL

8
Comments 1
6 min read
SQLife - a new client for Oracle, PostgreSQL, MySQL, SQLServer and more databases.
Cover image for SQLife - a new client for Oracle, PostgreSQL, MySQL, SQLServer and more databases.

SQLife - a new client for Oracle, PostgreSQL, MySQL, SQLServer and more databases.

1
Comments
3 min read
Can PostgreSQL Be a Search Engine? Yes, You Might Not Need Elasticsearch
Cover image for 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
Indexing in MySQL for PHP Developers: Do’s and Don’ts
Cover image for 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
Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀
Cover image for Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀

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

11
Comments 1
2 min read
Collation Confusion: How to Search in MySQL
Cover image for Collation Confusion: How to Search in MySQL

Collation Confusion: How to Search in MySQL

1
Comments 1
4 min read
Building a Reasoning Platform, Together
Cover image for Building a Reasoning Platform, Together

Building a Reasoning Platform, Together

Comments
4 min read
Cracking MySQL Performance: What is Indexing and Why It Matters
Cover image for 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
Implementing Role-Based Access Control (RBAC) in MySQL

Implementing Role-Based Access Control (RBAC) in MySQL

5
Comments 2
3 min read
What's New in MySQL 9 🧐 - a DBA's Perspective 🥸
Cover image for 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
New in Releem: Live MySQL Process List for Instantly Spotting Long Queries
Cover image for New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

5
Comments
2 min read
How to Fix "MySQL Unexpected Shutdown" in XAMPP (Easy Step-by-Step Guide)
Cover image for 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
Three practical ways to create a database in MySQL
Cover image for Three practical ways to create a database in MySQL

Three practical ways to create a database in MySQL

Comments
2 min read
🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)

🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)

12
Comments 2
2 min read
How To Set Up Multiple Datasources in Spring Boot 3
Cover image for How To Set Up Multiple Datasources in Spring Boot 3

How To Set Up Multiple Datasources in Spring Boot 3

6
Comments
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.