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.
Music Studio Management & Booking Dashboard | PHP & MySQLi
janrosedev profile

Music Studio Management & Booking Dashboard | PHP & MySQLi

#backend #mysql #php #webdev
Comments
1 min read
One CAST made a view 13x slower in PostgreSQL. So I benchmarked MySQL 8.4 against PostgreSQL 17
aleksander_frolov profile

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

#performance #postgres #mysql #sql
Comments 3
6 min read
MySQL Overselling: Why SELECT Isn't Enough and How SELECT ... FOR UPDATE Solves It
mehradsadeghi profile

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

#database #mysql #backend #softwareengineering
Comments 1
5 min read
MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See
mahmut_gndzalp_c736ac4b profile

MySQL Will Quietly Eat Your Data If You Let It: Truncation, Charsets, and the 1366 You Never See

#mysql #php #database #webdev
2
Comments
6 min read
A Straightforward Guide for MVCC in MySQL
eyochen profile
Eyo

A Straightforward Guide for MVCC in MySQL

#mysql #database #backend #learning
4
Comments 2
8 min read
How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model
sampseiol1 profile

How We Evolved a Cultural Recommendation Feed From a Weighted SQL Ranker to a Narrative Affinity Model

#php #mysql #algorithms #softwareengineering
Comments
6 min read
Installing WordPress on Ubuntu 24.04
sharmukh profile

Installing WordPress on Ubuntu 24.04

#wordpress #nginx #mysql #ubuntu
6
Comments
6 min read
The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem
mahmut_gndzalp_c736ac4b profile

The Query That Ate 75% of Our Database CPU: A MySQL Full-Text Post-Mortem

#mysql #performance #database #webdev
5
Comments
6 min read
10 MySQL Performance Optimization Techniques Every PHP Developer Must Know
tapas_mahata profile

10 MySQL Performance Optimization Techniques Every PHP Developer Must Know

#php #mysql #webdev #sql
2
Comments
3 min read
Understanding Two-Phase Commit (2PC) by Building One in Go
ankitmalikg profile

Understanding Two-Phase Commit (2PC) by Building One in Go

#go #mysql #postgres #distributedsystems
Comments
11 min read
I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress
muhammad_suleman_095 profile

I built a free portable tool to import huge MySQL dumps on Windows (9GB+ tested) — with real-time progress

#mysql #opensource #database
Comments
1 min read
Track MySQL LTS Updates with Renovate
catatsuy profile

Track MySQL LTS Updates with Renovate

#renovate #mysql #docker #devops
Comments
4 min read
Getting Started on MOCO Part 2: Backup and Restore to MinIO (and the davfs2 Bug That Broke It)
mucheru profile

Getting Started on MOCO Part 2: Backup and Restore to MinIO (and the davfs2 Bug That Broke It)

#kubernetes #mysql #moco #devops
Comments
8 min read
A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands
dulannithilaliyanarachchi profile

A Complete Guide to Install XAMPP, Configure Apache & MySQL Services, and Deploy WordPress Using PowerShell Commands

#php #mysql #wordpress #powershell
1
Comments
4 min read
Fashion E-Commerce Store
ajith_5906ae8402d31b2d6d8 profile
Ajith

Fashion E-Commerce Store

#backend #fastapi #mysql #webdev
Comments 2
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.