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.
Is your WHMCS charging last year's EU VAT rate?
vainamoinen profile

Is your WHMCS charging last year's EU VAT rate?

#whmcs #php #mysql #sysadmin
Comments
7 min read
WHMCS 9.0: check your custom reports for double-counting
vainamoinen profile

WHMCS 9.0: check your custom reports for double-counting

#whmcs #mysql #php #sysadmin
Comments
6 min read
Specialization and Generalization in DBMS: Explained with Simple Examples
siddhu_kumar_fd7a80402b7e profile

Specialization and Generalization in DBMS: Explained with Simple Examples

#database #webdev #programming #mysql
Comments
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
Jev was the tipping point - I built the last MySQL search statement
maayanlevy profile

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

#showdev #mysql #jev
Comments
3 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
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
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 1
6 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.