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.
HadiDB: A Lightweight, Horizontally Scalable Database in Python

HadiDB: A Lightweight, Horizontally Scalable Database in Python

Comments
3 min read
How to Reset PostgreSQL Password

How to Reset PostgreSQL Password

1
Comments
2 min read
MySQLTuner for Windows: Common Issues and Better Alternatives

MySQLTuner for Windows: Common Issues and Better Alternatives

2
Comments
4 min read
Is PostgreSQL Better Than MySQL?

Is PostgreSQL Better Than MySQL?

5
Comments
2 min read
Scaling down the storage of a MySQL RDS database with zero downtime using AWS Blue/Green Deployment

Scaling down the storage of a MySQL RDS database with zero downtime using AWS Blue/Green Deployment

3
Comments
3 min read
What is SQLite? A Comprehensive Overview

What is SQLite? A Comprehensive Overview

7
Comments
4 min read
Introduction To MySQL & SQL QUERIES

Introduction To MySQL & SQL QUERIES

2
Comments
2 min read
Postgres vs. MySQL

Postgres vs. MySQL

109
Comments 21
7 min read
How to Check Which Tables Contain Data in a Database

How to Check Which Tables Contain Data in a Database

1
Comments 4
2 min read
Building a Wishlist App: My Journey with Room Database, DAO, and Entity Integration

Building a Wishlist App: My Journey with Room Database, DAO, and Entity Integration

Comments
3 min read
Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Query optimization in MySQL is crucial for improving database performance, especially when dealing with large datasets

Comments
2 min read
Resolving MySQL Port Conflicts: A Step-by-Step Guide

Resolving MySQL Port Conflicts: A Step-by-Step Guide

6
Comments
2 min read
MySQL ONLY_FULL_GROUP_BY Error: Easy Fixes and Best Practices

MySQL ONLY_FULL_GROUP_BY Error: Easy Fixes and Best Practices

Comments
3 min read
Getting started on MOCO, the MySQL Operator for Kubernetes Part 1

Getting started on MOCO, the MySQL Operator for Kubernetes Part 1

1
Comments
5 min read
MySQL ONLY_FULL_GROUP_BY

MySQL ONLY_FULL_GROUP_BY

Comments
1 min read
JSqlParser-5.0 problem with MySQL Convert(expr,type) function

JSqlParser-5.0 problem with MySQL Convert(expr,type) function

Comments
1 min read
Configuring a Virtual IP (VIP) ensures seamless failover and high availability for MariaDB Galera Cluster on Ubuntu 24.04 LTS

Configuring a Virtual IP (VIP) ensures seamless failover and high availability for MariaDB Galera Cluster on Ubuntu 24.04 LTS

1
Comments
4 min read
Why Is MySQL the Best Database?

Why Is MySQL the Best Database?

Comments
3 min read
Building a PHP CRUD Application with OOP and MySQL: A Best Practice Guide

Building a PHP CRUD Application with OOP and MySQL: A Best Practice Guide

28
Comments
4 min read
CRUD With Flask And MySql #2 Prepare

CRUD With Flask And MySql #2 Prepare

Comments
3 min read
Configure MariaDB Galera Cluster in ubuntu 24.04 LTS

Configure MariaDB Galera Cluster in ubuntu 24.04 LTS

1
Comments
3 min read
Choosing the Right Time Series Database for Your Use Case

Choosing the Right Time Series Database for Your Use Case

2
Comments 1
2 min read
Working with JSON in MySQL

Working with JSON in MySQL

4
Comments
3 min read
Boost MySQL Performance with Data Partitioning

Boost MySQL Performance with Data Partitioning

Comments
2 min read
Deploy a Node.js Application Using MySQL and Prisma on a Raspberry Pi

Deploy a Node.js Application Using MySQL and Prisma on a Raspberry Pi

1
Comments
8 min read
loading...