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.
Run MySQL in Docker on Windows

Run MySQL in Docker on Windows

Comments
3 min read
WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

2
Comments
2 min read
Comment installer et faire tourner mediawiki Avec Xampp

Comment installer et faire tourner mediawiki Avec Xampp

5
Comments
4 min read
Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

Comments
2 min read
How I can order the returned results by relevance in mysql or mariadb when I use like statement in where?

How I can order the returned results by relevance in mysql or mariadb when I use like statement in where?

1
Comments 2
1 min read
Quick MySQL Table Creation: A Developer's Guide

Quick MySQL Table Creation: A Developer's Guide

Comments
1 min read
Replacing Planetscale

Replacing Planetscale

Comments
8 min read
Ultra High-Performance Database OpenM(ysq)LDB: Seamless Compatibility with MySQL Protocol and Multi-Language MySQL Client

Ultra High-Performance Database OpenM(ysq)LDB: Seamless Compatibility with MySQL Protocol and Multi-Language MySQL Client

Comments
6 min read
PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

42
Comments 11
6 min read
Create Local MySQL using Docker Run

Create Local MySQL using Docker Run

Comments
1 min read
How to sync your MySQL database with Salesforce in Docker using Boomi

How to sync your MySQL database with Salesforce in Docker using Boomi

1
Comments
11 min read
How to Install MySQL / MariaDB on Linux Ubuntu

How to Install MySQL / MariaDB on Linux Ubuntu

Comments
2 min read
What is MySQL Throughput?

What is MySQL Throughput?

Comments
3 min read
Automate daily MySQL and PostgreSQL database backups

Automate daily MySQL and PostgreSQL database backups

3
Comments 2
2 min read
Como permitir valores nulos do Golang na Base de Dados?

Como permitir valores nulos do Golang na Base de Dados?

Comments
1 min read
JaVers: Periodic Maintenance of the Audit Tables

JaVers: Periodic Maintenance of the Audit Tables

1
Comments
2 min read
Como normalizar banco de dados?

Como normalizar banco de dados?

9
Comments
2 min read
MySQL Latency. Breaking Down MySQL Latency – What It Is and Why It Matters

MySQL Latency. Breaking Down MySQL Latency – What It Is and Why It Matters

Comments
4 min read
Best practices for DB modifications MySQL

Best practices for DB modifications MySQL

Comments
9 min read
Improving the performance of LIMIT,OFFSET in MySQL

Improving the performance of LIMIT,OFFSET in MySQL

1
Comments 1
4 min read
Inserting Data from a Large CSV in Laravel Over 10x Faster

Inserting Data from a Large CSV in Laravel Over 10x Faster

1
Comments
2 min read
Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

Supercharge Your Database: 25 Essential MySQL Query Optimization Techniques

Comments
8 min read
Deploying WordPress with MySQL, Redis, and NGINX on Docker

Deploying WordPress with MySQL, Redis, and NGINX on Docker

2
Comments
8 min read
E-Commerce with React Node Mysql

E-Commerce with React Node Mysql

Comments
2 min read
How to dump and restore a Postgres DB with new table ownership

How to dump and restore a Postgres DB with new table ownership

1
Comments 1
4 min read
Harnessing Kubernetes for Hosting MySQL and Laravel Applications

Harnessing Kubernetes for Hosting MySQL and Laravel Applications

Comments
8 min read
Concurrency Control in Go with Ent ORM and MySQL

Concurrency Control in Go with Ent ORM and MySQL

5
Comments
10 min read
Adding sequence duplicate records in MySQL without a window function

Adding sequence duplicate records in MySQL without a window function

21
Comments
3 min read
(Docker) Criando um ambiente LAMP utilizando Docker Compose

(Docker) Criando um ambiente LAMP utilizando Docker Compose

Comments
5 min read
How to connect your Boomi Atom runtime and MySQL on Docker

How to connect your Boomi Atom runtime and MySQL on Docker

1
Comments
7 min read
How we handled MySQL deadlocks in Productive - Part 1

How we handled MySQL deadlocks in Productive - Part 1

46
Comments
6 min read
Migrating your data from PlanetScale to Neon

Migrating your data from PlanetScale to Neon

1
Comments
7 min read
Best PlanetScale alternative: TiDB Serverless

Best PlanetScale alternative: TiDB Serverless

1
Comments
3 min read
Indexing Best Practices

Indexing Best Practices

Comments
4 min read
Navigating the Landscape of Data Modeling: Current Challenges and a Modern Solution

Navigating the Landscape of Data Modeling: Current Challenges and a Modern Solution

Comments
5 min read
MySQL MongoDB Important Question

MySQL MongoDB Important Question

Comments
14 min read
Top Asking SQL vs Mongo Queries

Top Asking SQL vs Mongo Queries

Comments
12 min read
🔄 How to Synchronize Database SchemasđŸ”„đŸš€

🔄 How to Synchronize Database SchemasđŸ”„đŸš€

7
Comments 1
5 min read
Migrating to ClickHouse: Releem's Journey

Migrating to ClickHouse: Releem's Journey

Comments 3
3 min read
How to CONCAT in MySQL

How to CONCAT in MySQL

Comments
6 min read
Test your mySQL / Aurora database with Lambda

Test your mySQL / Aurora database with Lambda

1
Comments
1 min read
A Beginner-friendly Approach to Developing a REST API with Go, Gin and MSQL

A Beginner-friendly Approach to Developing a REST API with Go, Gin and MSQL

5
Comments
9 min read
Ecto order by a dynamic fragment

Ecto order by a dynamic fragment

1
Comments
2 min read
Demystifying Data Persistence: Where Docker Stores Your MySQL data?

Demystifying Data Persistence: Where Docker Stores Your MySQL data?

Comments
2 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

1
Comments
3 min read
O que Ă© sigla ACID em banco de dados relacional ?

O que Ă© sigla ACID em banco de dados relacional ?

1
Comments
2 min read
Self-hosting Ghost with Docker and PlanetScale

Self-hosting Ghost with Docker and PlanetScale

1
Comments
10 min read
Interview Question MongoDB

Interview Question MongoDB

1
Comments 8
18 min read
Finding the best SQL query for the task.

Finding the best SQL query for the task.

Comments
4 min read
Capitalisation of table name generated by Hibernate when using MySQL server

Capitalisation of table name generated by Hibernate when using MySQL server

Comments 2
2 min read
O que é a normalização em um banco de dados ?

O que é a normalização em um banco de dados ?

3
Comments
2 min read
Node Backend Developer Important Packages

Node Backend Developer Important Packages

1
Comments
7 min read
1 billion rows challenge in MySQL

1 billion rows challenge in MySQL

Comments
4 min read
Optimizing SQL Queries by 23x!!!

Optimizing SQL Queries by 23x!!!

202
Comments 38
8 min read
A Closer Look: Exploring the Functions of Apache HTTP Server and Apache httpd

A Closer Look: Exploring the Functions of Apache HTTP Server and Apache httpd

Comments
2 min read
Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

2
Comments
2 min read
Unleash the searching power of MySQL by with Full-Text Search

Unleash the searching power of MySQL by with Full-Text Search

4
Comments
5 min read
How to Deploy your Django Web App and connect a MySQL Database in cPanel

How to Deploy your Django Web App and connect a MySQL Database in cPanel

1
Comments 2
7 min read
The 2 Best No-Code Backend Builders

The 2 Best No-Code Backend Builders

2
Comments
7 min read
Deploy Ghost with MySQL DB replication using helm chart

Deploy Ghost with MySQL DB replication using helm chart

Comments
2 min read
loading...