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.
Moving off Modern Events Calendar: what's in your database and what breaks
jeffreyinman profile

Moving off Modern Events Calendar: what's in your database and what breaks

#wordpress #php #mysql #webdev
Comments 1
4 min read
Stop Killing Your Database: The Power of Connection Pooling
saurav_tb_pandey profile

Stop Killing Your Database: The Power of Connection Pooling

#connectionpooling #node #mysql #backend
Comments
2 min read
Installing phpMyAdmin on Ubuntu 24.04
sharmukh profile

Installing phpMyAdmin on Ubuntu 24.04

#phpmyadmin #mysql #apache #ubuntu
5
Comments 1
4 min read
Why Your Node.js App Crashes Under Traffic: The Magic of Connection Pooling
saurav_tb_pandey profile

Why Your Node.js App Crashes Under Traffic: The Magic of Connection Pooling

#connectionpooling #node #mysql #backend
Comments
3 min read
Supercharge Your Node.js App: Why You Need Database Connection Pooling
saurav_tb_pandey profile

Supercharge Your Node.js App: Why You Need Database Connection Pooling

#connectionpooling #node #mysql #backend
Comments
3 min read
Inventory reservation in MySQL: Shopify's row-lock design
axrisi profile

Inventory reservation in MySQL: Shopify's row-lock design

#mysql #redis #concurrency #systemdesign
2
Comments
7 min read
The ALTER TABLE that looked free and rebuilt the whole table
gregory_beauchamp_b462b4f profile

The ALTER TABLE that looked free and rebuilt the whole table

#mysql #aws #database #devops
1
Comments 1
7 min read
The Silent Database Killer: Understanding and Fixing the N+1 Query Problem
saurav_tb_pandey profile

The Silent Database Killer: Understanding and Fixing the N+1 Query Problem

#n1query #database #node #mysql
Comments
2 min read
Stop Crashing Your Database: A Developer's Guide to Connection Pooling
saurav_tb_pandey profile

Stop Crashing Your Database: A Developer's Guide to Connection Pooling

#connectionpooling #node #mysql #performance
Comments
3 min read
How I Added Page-Level Deep Linking to a WordPress PDF Search Plugin
web_equipe_6ce39cc961f26b profile

How I Added Page-Level Deep Linking to a WordPress PDF Search Plugin

#wordpress #php #mysql #webdev
Comments
3 min read
Six Rows Deleted. Three Decrements Applied. No Error.
mahmut_gndzalp_c736ac4b profile

Six Rows Deleted. Three Decrements Applied. No Error.

#mysql #sql #database #webdev
Comments
6 min read
Read your SQL back as one sentence before you run it
selene_nyx_ai profile

Read your SQL back as one sentence before you run it

#sql #database #postgres #mysql
Comments
6 min read
Load testing your database with your real query mix: from pg_stat_statements to a weighted load test
usespitfire profile

Load testing your database with your real query mix: from pg_stat_statements to a weighted load test

#postgres #mysql #performance #testing
Comments
5 min read
Cost-Effective Public Hosting for Typescript/MySQL Monorepo: Optimizing for Small User Base Without Unnecessary Expenses
serbyte profile

Cost-Effective Public Hosting for Typescript/MySQL Monorepo: Optimizing for Small User Base Without Unnecessary Expenses

#hosting #monorepo #typescript #mysql
Comments
8 min read
MySQL to PostgreSQL Migration: A Practical UK Guide for Decision-Makers
sairaaslam-coder profile

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

#cloudcomputing #mysql #postgressql #migration
2
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.