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.
Dockerizing a Flask-MySQL app with docker-compose

Dockerizing a Flask-MySQL app with docker-compose

32
Comments 2
5 min read
Database designer for web developers and beginner

Database designer for web developers and beginner

15
Comments
2 min read
Monitor your LEMP server with Netdata

Monitor your LEMP server with Netdata

90
Comments 4
6 min read
Project Spotlight - Introducing KikCMS

Project Spotlight - Introducing KikCMS

4
Comments
6 min read
.Net Core 3 + EFCore

.Net Core 3 + EFCore

14
Comments 2
4 min read
How to access MySQL DB behind two ssh host using MySQL Workbench

How to access MySQL DB behind two ssh host using MySQL Workbench

7
Comments
1 min read
How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost

5
Comments
13 min read
How I Build a MySql plugin for QT5 (Windows, MinGW32)

How I Build a MySql plugin for QT5 (Windows, MinGW32)

7
Comments
2 min read
Backups with rdiff-backup and mysqldump

Backups with rdiff-backup and mysqldump

8
Comments
2 min read
📚 Awesome links from dev.to and around the web #2

📚 Awesome links from dev.to and around the web #2

44
Comments
2 min read
Spring Embedded MySQL Server

Spring Embedded MySQL Server

6
Comments
4 min read
PHP as a Pain Reliever

PHP as a Pain Reliever

8
Comments
4 min read
.Net Core 3 - Part 2 - MySQL

.Net Core 3 - Part 2 - MySQL

16
Comments 1
3 min read
Flexible data types with the JSON field

Flexible data types with the JSON field

10
Comments
5 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

6
Comments
3 min read
How to Transfer MySQL Databases

How to Transfer MySQL Databases

5
Comments
1 min read
How to get the list of all the affected columns in a SQL query

How to get the list of all the affected columns in a SQL query

7
Comments 1
1 min read
Install and setup Apache + MySQL + PHP on Windows

Install and setup Apache + MySQL + PHP on Windows

14
Comments 3
3 min read
How to access the MySQL CLI With MAMP

How to access the MySQL CLI With MAMP

21
Comments 4
1 min read
Using MySQL with Rails 6 and installing MySQL on Mac (macOS Mojave)

Using MySQL with Rails 6 and installing MySQL on Mac (macOS Mojave)

23
Comments 5
5 min read
A simple user permission model for sophisticated systems

A simple user permission model for sophisticated systems

14
Comments
14 min read
Add a LAMP Stack to a server with Centos OS

Add a LAMP Stack to a server with Centos OS

8
Comments 2
2 min read
A definitive guide to SQL in NodeJS with Objection.js + Knex — Part 1

A definitive guide to SQL in NodeJS with Objection.js + Knex — Part 1

69
Comments 12
10 min read
Why I don't use a database for my blog

Why I don't use a database for my blog

7
Comments 1
4 min read
Problem when line feed code is mixed when csv in import into varchar column with AWS Aurora.

Problem when line feed code is mixed when csv in import into varchar column with AWS Aurora.

8
Comments
1 min read
Improve query performance for polymorphic relationships in Laravel

Improve query performance for polymorphic relationships in Laravel

8
Comments
3 min read
How To Install WordPress with a Managed Database on Ubuntu 18.04

How To Install WordPress with a Managed Database on Ubuntu 18.04

34
Comments 8
17 min read
Query Optimization with MySQL

Query Optimization with MySQL

10
Comments
7 min read
Playing with Django Models

Playing with Django Models

22
Comments 1
10 min read
Understanding timezones

Understanding timezones

11
Comments
1 min read
Advanced usage of yum-config-manager with setopts

Advanced usage of yum-config-manager with setopts

8
Comments 5
1 min read
How to automatically backup MYSQL to Amazon S3?

How to automatically backup MYSQL to Amazon S3?

11
Comments 3
3 min read
Form Processing in CFScript Part Two: Saving Form Entries to the Database

Form Processing in CFScript Part Two: Saving Form Entries to the Database

9
Comments
4 min read
How to Setup a WordPress MySQL Database in the Cloud

How to Setup a WordPress MySQL Database in the Cloud

3
Comments
10 min read
C#言語APIメモ

C#言語APIメモ

4
Comments
1 min read
A Basic MySQL Tutorial

A Basic MySQL Tutorial

7
Comments
2 min read
To do or not to do, whats more good of a practice.

To do or not to do, whats more good of a practice.

5
Comments 5
1 min read
PHP MySQLi Library Pt2

PHP MySQLi Library Pt2

4
Comments
4 min read
PHP MySQL Library Pt3

PHP MySQL Library Pt3

5
Comments
2 min read
what is better to remove a column or make it null in MySQL.

what is better to remove a column or make it null in MySQL.

8
Comments 4
1 min read
How to write optional filters in SQL

How to write optional filters in SQL

10
Comments
1 min read
The Best Way to Host MySQL on Azure Cloud

The Best Way to Host MySQL on Azure Cloud

5
Comments
9 min read
PHP MySQLi Library Pt1

PHP MySQLi Library Pt1

3
Comments
4 min read
Run MySQL on Docker and use in your Java App

Run MySQL on Docker and use in your Java App

19
Comments 9
3 min read
2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence

2
Comments
15 min read
4 MySQL traps

4 MySQL traps

52
Comments 2
3 min read
Creating a ZFS Image of a MySQL Data Directory

Creating a ZFS Image of a MySQL Data Directory

10
Comments
2 min read
Beginning MySQL for Data Analysts

Beginning MySQL for Data Analysts

4
Comments
7 min read
Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

Import MySQL to MongoDB in 5 Steps (Plus SQL Server, PostgreSQL, Oracle)

8
Comments 1
3 min read
Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

5
Comments
4 min read
Toggle NOT NULL constraint with Rails migration

Toggle NOT NULL constraint with Rails migration

10
Comments 1
1 min read
MySQL 8 en Docker de manera fácil y para toda la familia

MySQL 8 en Docker de manera fácil y para toda la familia

9
Comments 4
3 min read
MySQL High Availability Framework Explained – Part III: Failover Scenarios

MySQL High Availability Framework Explained – Part III: Failover Scenarios

11
Comments
5 min read
Create a Web Server and save form data into MySQL database using PHP (Beginners Guide)

Create a Web Server and save form data into MySQL database using PHP (Beginners Guide)

27
Comments 5
5 min read
MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

MySQL/MariaDB: like a Petya ransomware for MySQL and ‘root’@’%’ access

9
Comments 2
3 min read
TestRail: QA Test Case Management installation on Linux

TestRail: QA Test Case Management installation on Linux

8
Comments 2
8 min read
Building a file sharing app with Node.js, Vue.js, Cloudinary, and MySQL - Part 2

Building a file sharing app with Node.js, Vue.js, Cloudinary, and MySQL - Part 2

12
Comments
2 min read
Debugging queries - lazy vs eager loading in Laravel

Debugging queries - lazy vs eager loading in Laravel

15
Comments 1
3 min read
Welcome to SQL 3: Building Relationships and Combining Data Sets

Welcome to SQL 3: Building Relationships and Combining Data Sets

11
Comments 1
10 min read
MySQL vs MySQLi vs PDO Performance Benchmark, Difference and Security Comparison - 2022

MySQL vs MySQLi vs PDO Performance Benchmark, Difference and Security Comparison - 2022

15
Comments 3
6 min read
loading...