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.
WHMCS 9.0: check your custom reports for double-counting

WHMCS 9.0: check your custom reports for double-counting

Comments
6 min read
OCI - Connecting to an OCI Always Free MySQL DB System: Installing MySQL Shell and Building a "Poor Man's VPN"

OCI - Connecting to an OCI Always Free MySQL DB System: Installing MySQL Shell and Building a "Poor Man's VPN"

1
Comments
6 min read
Laravel's New whereBinary(): Simple Case-Sensitive Queries in MySQL

Laravel's New whereBinary(): Simple Case-Sensitive Queries in MySQL

1
Comments 3
5 min read
Academic social network developed to connect students through knowledge exchange.

Academic social network developed to connect students through knowledge exchange.

Comments
1 min read
Docker, Index, and a very expensive lesson in reading pricing tables

Docker, Index, and a very expensive lesson in reading pricing tables

Comments
2 min read
Circular Foreign Keys: Why the First Row Cannot Be Inserted

Circular Foreign Keys: Why the First Row Cannot Be Inserted

Comments
10 min read
How to Replicate MySQL to BigQuery with Sling

How to Replicate MySQL to BigQuery with Sling

Comments
9 min read
I Thought MSSQL and MySQL Were the Same. I Was Wrong.

I Thought MSSQL and MySQL Were the Same. I Was Wrong.

Comments
20 min read
Jev was the tipping point - I built the last MySQL search statement

Jev was the tipping point - I built the last MySQL search statement

Comments 1
3 min read
How I Built a Blog Recommendation Engine Using Spring Boot & MySQL

How I Built a Blog Recommendation Engine Using Spring Boot & MySQL

Comments
7 min read
MySQL to PostgreSQL Migration: A Practical UK Guide for Decision-Makers

MySQL to PostgreSQL Migration: A Practical UK Guide for Decision-Makers

3
Comments
6 min read
Modern IT Helpdesk & Ticketing System Built with PHP Native & MySQL

Modern IT Helpdesk & Ticketing System Built with PHP Native & MySQL

Comments
1 min read
Music Studio Management & Booking Dashboard | PHP & MySQLi

Music Studio Management & Booking Dashboard | PHP & MySQLi

Comments
1 min read
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17

Comments 3
6 min read
MySQL Overselling: Why SELECT Isn't Enough and How SELECT ... FOR UPDATE Solves It

MySQL Overselling: Why SELECT Isn't Enough and How SELECT ... FOR UPDATE Solves It

Comments 1
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.