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.
Optimizing SQL Queries by 23x!!!

Optimizing SQL Queries by 23x!!!

202
Comments 38
8 min read
Node.js CRUD Operation with MySQL example

Node.js CRUD Operation with MySQL example

199
Comments 1
4 min read
Optimizing your MySQL queries

Optimizing your MySQL queries

187
Comments 2
8 min read
How To Build Rest API With NodeJS, Express, and MySQL

How To Build Rest API With NodeJS, Express, and MySQL

159
Comments 46
16 min read
Create a Netflix clone from Scratch: JavaScript PHP + MySQL

Create a Netflix clone from Scratch: JavaScript PHP + MySQL

104
Comments 8
2 min read
Monitor your LEMP server with Netdata

Monitor your LEMP server with Netdata

90
Comments 4
6 min read
React + Node.js + MySQL CRUD example

React + Node.js + MySQL CRUD example

85
Comments 4
3 min read
PHP - Create your own dotenv to loads environment variables from .env file

PHP - Create your own dotenv to loads environment variables from .env file

75
Comments 6
1 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

68
Comments 12
10 min read
Upload images with React, ExpressJS and mySQL

Upload images with React, ExpressJS and mySQL

68
Comments 7
5 min read
Node.js with MySQL database.

Node.js with MySQL database.

62
Comments 6
1 min read
Docker for Beginners: Crafting Your Backend Development Environment

Docker for Beginners: Crafting Your Backend Development Environment

59
Comments 3
6 min read
Setting up Ruby on Rails with docker and MySQL

Setting up Ruby on Rails with docker and MySQL

54
Comments 5
11 min read
How to properly retrieve Laravel models between two dates

How to properly retrieve Laravel models between two dates

53
Comments 2
5 min read
How to Create Dockerized NodeJS with MySQL Database

How to Create Dockerized NodeJS with MySQL Database

52
Comments 10
3 min read
4 MySQL traps

4 MySQL traps

52
Comments 2
3 min read
Advance Searching in Laravel for JSON Column type and using WHEN Method

Advance Searching in Laravel for JSON Column type and using WHEN Method

50
Comments 5
4 min read
Elementary OS - Dev Environment Setup

Elementary OS - Dev Environment Setup

46
Comments 3
8 min read
Blog Project with Go, Gin, MySQL and Docker - Part 1

Blog Project with Go, Gin, MySQL and Docker - Part 1

46
Comments 5
8 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
📚 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
Simple React JS and MySQL Integration -- CRUD App (Backend)

Simple React JS and MySQL Integration -- CRUD App (Backend)

44
Comments 2
3 min read
Creating a cloud-based Pokédex: overview

Creating a cloud-based Pokédex: overview

42
Comments
4 min read
Making the advanced query filter with Eloquent Filter in Laravel

Making the advanced query filter with Eloquent Filter in Laravel

42
Comments 20
4 min read
SQL: Timestamps

SQL: Timestamps

41
Comments 4
2 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

40
Comments 13
4 min read
Best Practice for Creating Indexes on your MySQL Tables

Best Practice for Creating Indexes on your MySQL Tables

39
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
How to Update the Database After a Drag-and-Drop Operation

How to Update the Database After a Drag-and-Drop Operation

39
Comments 5
7 min read
Why Not PHP?

Why Not PHP?

38
Comments 13
3 min read
How to use MySql with Django - For Beginners

How to use MySql with Django - For Beginners

38
Comments 7
3 min read
Build a custom MySQL Docker Container

Build a custom MySQL Docker Container

37
Comments 3
6 min read
How to Dockerize Your Application

How to Dockerize Your Application

37
Comments 2
6 min read
Garanta a Eficiência: Escolhendo entre tipos String no SQL

Garanta a Eficiência: Escolhendo entre tipos String no SQL

35
Comments 7
4 min read
Guide to Dockerize your Spring Boot application with MySQL database

Guide to Dockerize your Spring Boot application with MySQL database

35
Comments 1
3 min read
How to Create a Discussion Forum Using PHP and MySQL?

How to Create a Discussion Forum Using PHP and MySQL?

34
Comments 6
9 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
Solutions for storing state in a database

Solutions for storing state in a database

33
Comments 4
4 min read
Deploying your Laravel + MySQL application on Heroku

Deploying your Laravel + MySQL application on Heroku

33
Comments 8
7 min read
WSL2-Windows Linux Subsystem: A guide to install a Local Web Server Ubuntu-20.04 Apache,PHP8 y MySQL8

WSL2-Windows Linux Subsystem: A guide to install a Local Web Server Ubuntu-20.04 Apache,PHP8 y MySQL8

33
Comments 3
14 min read
Calculate Distance between 2 Geo Locations in PHP MySQL

Calculate Distance between 2 Geo Locations in PHP MySQL

33
Comments 3
2 min read
Designing SQL databases for rock solid data quality

Designing SQL databases for rock solid data quality

33
Comments 3
5 min read
Top 11 MYSQL monitoring tools in 2022 [open-source included]

Top 11 MYSQL monitoring tools in 2022 [open-source included]

32
Comments
7 min read
Dockerizing a Flask-MySQL app with docker-compose

Dockerizing a Flask-MySQL app with docker-compose

32
Comments 2
5 min read
From 0 to 5.000.000 monthly views

From 0 to 5.000.000 monthly views

31
Comments 6
6 min read
How to securely login to MySQL without providing password each time

How to securely login to MySQL without providing password each time

30
Comments 3
2 min read
Bulk Update Multiple Records with Separate Data — Laravel

Bulk Update Multiple Records with Separate Data — Laravel

30
Comments 4
2 min read
MySQL's Data Streaming : What is it & How it works ?

MySQL's Data Streaming : What is it & How it works ?

30
Comments
10 min read
Laravel Many-to-Many Pivot Relationship

Laravel Many-to-Many Pivot Relationship

30
Comments 1
3 min read
Cache-Aside Pattern

Cache-Aside Pattern

28
Comments 9
7 min read
A Simple Express Server and MySQL Database

A Simple Express Server and MySQL Database

28
Comments 4
4 min read
Testcontainers with MySQL and Redis with an Spring Boot Kotlin Application

Testcontainers with MySQL and Redis with an Spring Boot Kotlin Application

28
Comments 8
8 min read
React CRUD operations using PHP API and MySQL

React CRUD operations using PHP API and MySQL

27
Comments 2
8 min read
How to make Food Ordering Website?

How to make Food Ordering Website?

26
Comments 4
2 min read
How to Dump a Database using DBeaver

How to Dump a Database using DBeaver

26
Comments 3
1 min read
Database Design of a Restaurant Management System from user story to relational Model

Database Design of a Restaurant Management System from user story to relational Model

26
Comments 8
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)

26
Comments 5
5 min read
PHP - Create your own PHP Authentication

PHP - Create your own PHP Authentication

26
Comments 4
3 min read
React Redux & MySQL: CRUD example with Node.js Express

React Redux & MySQL: CRUD example with Node.js Express

26
Comments
5 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
loading...