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.
Sql Joins

Sql Joins

9
Comments 2
1 min read
Test automation for Laravel 7 and MySQL with GitHub Actions

Test automation for Laravel 7 and MySQL with GitHub Actions

26
Comments 13
6 min read
Laravel use or force index on a query

Laravel use or force index on a query

3
Comments 2
1 min read
I tried using CakePHP 4.0.8 🍓with Docker. (apach)

I tried using CakePHP 4.0.8 🍓with Docker. (apach)

5
Comments 2
4 min read
Empowering MySQL DB Access with MySqlConnector + RepoDb

Empowering MySQL DB Access with MySqlConnector + RepoDb

7
Comments
5 min read
MySQL vs. PostgreSQL vs. Redis

MySQL vs. PostgreSQL vs. Redis

5
Comments
2 min read
How to check the connection between mysql and memcached in php

How to check the connection between mysql and memcached in php

3
Comments
2 min read
MySQL to Postgres Migration using Docker with pgloader for Hasura

MySQL to Postgres Migration using Docker with pgloader for Hasura

24
Comments 9
4 min read
Mysql backups with node.js

Mysql backups with node.js

14
Comments
2 min read
Build A LAMP Server With Ansible

Build A LAMP Server With Ansible

5
Comments 3
1 min read
Playing with MySQL using Docker

Playing with MySQL using Docker

10
Comments
3 min read
How to change a foreign key constraint in MySQL

How to change a foreign key constraint in MySQL

25
Comments 1
3 min read
Django + MySQL, How to port your web application from SQLite to MySQL

Django + MySQL, How to port your web application from SQLite to MySQL

4
Comments 1
3 min read
SQL for dummies

SQL for dummies

10
Comments
5 min read
How to make forex Bots (signals) Using Programming

How to make forex Bots (signals) Using Programming

7
Comments 7
4 min read
How to Backup MySQL Databases on Ubuntu VPS Server Automatically

How to Backup MySQL Databases on Ubuntu VPS Server Automatically

8
Comments
2 min read
What makes MySQL LRU cache scan resistant

What makes MySQL LRU cache scan resistant

9
Comments
8 min read
MySQLDump.js

MySQLDump.js

4
Comments
1 min read
Docker Compose file for MySQL and phpMyAdmin

Docker Compose file for MySQL and phpMyAdmin

16
Comments
3 min read
Solution for "error: connect econnrefused [container_ip]:3306"

Solution for "error: connect econnrefused [container_ip]:3306"

3
Comments
1 min read
How to use MySQL on Docker for Rails local development (switching MySQL versions made easy!)

How to use MySQL on Docker for Rails local development (switching MySQL versions made easy!)

17
Comments 6
4 min read
Why Not PHP?

Why Not PHP?

38
Comments 13
3 min read
How to modify the size of a column in MySql from command line

How to modify the size of a column in MySql from command line

6
Comments
3 min read
Welcome to RepoDb.NET

Welcome to RepoDb.NET

7
Comments
3 min read
Java MYSQL Connection

Java MYSQL Connection

7
Comments 2
5 min read
Running node server with mysql on my smartphone

Running node server with mysql on my smartphone

7
Comments
5 min read
Banco de Dados Relacional (SQL) e Não Relacional (NoSQL) – O que são, para que servem e qual a diferença?

Banco de Dados Relacional (SQL) e Não Relacional (NoSQL) – O que são, para que servem e qual a diferença?

2
Comments
6 min read
SQL: Beyond The Basics

SQL: Beyond The Basics

6
Comments
4 min read
Why you simply don't drop a huge InnoDB table in production...

Why you simply don't drop a huge InnoDB table in production...

18
Comments 2
6 min read
Heroku: Go with MySQL Notes

Heroku: Go with MySQL Notes

7
Comments
3 min read
Bulk Uploading To A MySQL Database: A Quick Guide

Bulk Uploading To A MySQL Database: A Quick Guide

12
Comments
4 min read
Creating Professional Reports From MySQL Data

Creating Professional Reports From MySQL Data

13
Comments
3 min read
Querying MySQL from SQL Server using linked server

Querying MySQL from SQL Server using linked server

7
Comments
5 min read
Using data from MSSQL linked server with EF Core

Using data from MSSQL linked server with EF Core

7
Comments
4 min read
GeneXus application running on Kubernetes

GeneXus application running on Kubernetes

8
Comments 4
5 min read
Azure MySQL in App for App services

Azure MySQL in App for App services

6
Comments
2 min read
Setting up MySQL InnoDB cluster on Private Network

Setting up MySQL InnoDB cluster on Private Network

11
Comments
3 min read
How to Use Serverless with NestJS

How to Use Serverless with NestJS

21
Comments 1
1 min read
Fun interview question: How to update Saint Quartz stones with one line SQL statement in FGO?

Fun interview question: How to update Saint Quartz stones with one line SQL statement in FGO?

6
Comments
2 min read
Important Health Checks for your MySQL Master-Slave Servers

Important Health Checks for your MySQL Master-Slave Servers

8
Comments
5 min read
MySQL setup and Dancer2 Routes

MySQL setup and Dancer2 Routes

12
Comments 1
7 min read
Archiving large MySQL tables (part I - intro)

Archiving large MySQL tables (part I - intro)

24
Comments 4
5 min read
Archiving large MySQL tables (part II - initial migrations)

Archiving large MySQL tables (part II - initial migrations)

10
Comments
11 min read
Archiving large MySQL tables (part III - automation)

Archiving large MySQL tables (part III - automation)

8
Comments
4 min read
Connect NodeJS App With MySQL Database Hosted on a Digital Ocean Droplet (Server)

Connect NodeJS App With MySQL Database Hosted on a Digital Ocean Droplet (Server)

39
Comments 4
2 min read
Creating a cloud-based Pokédex: overview

Creating a cloud-based Pokédex: overview

45
Comments
4 min read
MySQL Schema Change Without Downtime

MySQL Schema Change Without Downtime

7
Comments
2 min read
Database Migration Plan

Database Migration Plan

2
Comments
1 min read
Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

3
Comments
6 min read
MySqlException (0x80004005): The Command Timeout expired before the operation completed

MySqlException (0x80004005): The Command Timeout expired before the operation completed

7
Comments 1
3 min read
Django 3 Tutorial & CRUD Example with MySQL and Bootstrap

Django 3 Tutorial & CRUD Example with MySQL and Bootstrap

8
Comments 1
1 min read
Solving a MySQL Deadlock

Solving a MySQL Deadlock

5
Comments
3 min read
PHP MYSQL URL Filtering

PHP MYSQL URL Filtering

5
Comments
1 min read
MySQL in PHP - how to deal with databases

MySQL in PHP - how to deal with databases

10
Comments 3
4 min read
SQL: Timestamps

SQL: Timestamps

41
Comments 4
2 min read
How to Reset MySql Root password on MacOS 10.13

How to Reset MySql Root password on MacOS 10.13

6
Comments
2 min read
MySQL DB backup using Bash script

MySQL DB backup using Bash script

14
Comments 3
1 min read
How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid

8
Comments
12 min read
How to Backup MySQL Database using mysqldump

How to Backup MySQL Database using mysqldump

8
Comments
1 min read
Using Python to create MySQL tables with random schema

Using Python to create MySQL tables with random schema

5
Comments
1 min read
loading...