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.
Automated AWS Receipt Processing System using Textract, Lambda & MySQL

Automated AWS Receipt Processing System using Textract, Lambda & MySQL

Comments
2 min read
How to Connect and Query MySQL Data in SSMS

How to Connect and Query MySQL Data in SSMS

Comments
7 min read
Praktikum Keamanan Web: SQL Injection di MySQL & Website PHP 😱🔒🚀

Praktikum Keamanan Web: SQL Injection di MySQL & Website PHP 😱🔒🚀

Comments
3 min read
New to a Large Project? This Is How I Decode Complex Databases

New to a Large Project? This Is How I Decode Complex Databases

1
Comments
2 min read
Building a Multi-Container App using Docker

Building a Multi-Container App using Docker

2
Comments
2 min read
1148. Article Views I | LeetCode | SQL 50 | Interview Questions | MySQL

1148. Article Views I | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

1068. Product Sales Analysis I | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
1683. Invalid Tweets | LeetCode | SQL 50 | Interview Questions | MySQL

1683. Invalid Tweets | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
1378. Replace Employee ID With The Unique Identifier | LeetCode | SQL 50 | Interview Questions | MySQL

1378. Replace Employee ID With The Unique Identifier | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
584. Find Customer Referee | LeetCode | SQL 50 | Interview Questions | MySQL

584. Find Customer Referee | LeetCode | SQL 50 | Interview Questions | MySQL

Comments
1 min read
PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

Comments
4 min read
1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

1757. Recyclable and Low Fat Products | LeetCode | SQL 50 | Interview Questions | MySQL

5
Comments
1 min read
Developing a PHP Project Across Windows and Mac on Your Home Network

Developing a PHP Project Across Windows and Mac on Your Home Network

Comments
2 min read
Overview of Real-Time Data Synchronization from MySQL to VeloDB

Overview of Real-Time Data Synchronization from MySQL to VeloDB

5
Comments
5 min read
HackerRank 'The Pads' MySQL

HackerRank 'The Pads' MySQL

Comments
3 min read
How a Cache Invalidation Bug Nearly Took Down Our System - And What We Changed After

How a Cache Invalidation Bug Nearly Took Down Our System - And What We Changed After

Comments 1
4 min read
A (very) Short Look at How MySQL Joins Work

A (very) Short Look at How MySQL Joins Work

2
Comments
2 min read
MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

1
Comments
1 min read
MySQL COUNT Scalar Subquery Optimization: The Complete Guide

MySQL COUNT Scalar Subquery Optimization: The Complete Guide

Comments
4 min read
What’s New At Releem - October 2025

What’s New At Releem - October 2025

Comments
3 min read
I'm Building a LinkedIn Alternative for Developers (And Sharing Everything I Learn)

I'm Building a LinkedIn Alternative for Developers (And Sharing Everything I Learn)

1
Comments
7 min read
Build a Complete Data Pipeline from Scratch: CSV to Dashboard Using Python, MySQL, and Airflow”

Build a Complete Data Pipeline from Scratch: CSV to Dashboard Using Python, MySQL, and Airflow”

2
Comments 1
3 min read
HNG Portal DevOps Technical Documentation

HNG Portal DevOps Technical Documentation

7
Comments
13 min read
Google Cloud SQL: x86 N2 vs ARM C4A

Google Cloud SQL: x86 N2 vs ARM C4A

Comments
7 min read
5 Database Query Optimization Tips That Actually Work

5 Database Query Optimization Tips That Actually Work

1
Comments
1 min read
loading...