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.
PostgreSQL vs MySQL: 7 syntax differences that break migrations
sharefun2023 profile

PostgreSQL vs MySQL: 7 syntax differences that break migrations

#postgres #mysql #database #sql
Comments
4 min read
The Database Playground: Everything You Can Plug In and Tune in PostgreSQL and MySQL (Including AI Workloads)
anikethsdeshpande profile

The Database Playground: Everything You Can Plug In and Tune in PostgreSQL and MySQL (Including AI Workloads)

#postgres #ai #mysql #database
Comments
37 min read
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N
sharefun2023 profile

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

#sql #database #postgres #mysql
Comments
4 min read
The NOT IN trap: why your SQL query returns zero rows
sharefun2023 profile

The NOT IN trap: why your SQL query returns zero rows

#sql #database #postgres #mysql
Comments
3 min read
Moving off EventON: its timestamps aren't what they look like
jeffreyinman profile

Moving off EventON: its timestamps aren't what they look like

#wordpress #php #mysql #webdev
1
Comments
4 min read
Moving off WP Event Manager: what's in your database and what breaks
jeffreyinman profile

Moving off WP Event Manager: what's in your database and what breaks

#wordpress #php #mysql #webdev
Comments
3 min read
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
4 min read
Database Concurrency 101: Optimistic vs. Pessimistic Locking
saurav_tb_pandey profile

Database Concurrency 101: Optimistic vs. Pessimistic Locking

#optimisticlocking #database #node #mysql
Comments
3 min read
How I Structured a Java Library Management System with DAO and Service Layers
hamad_19 profile

How I Structured a Java Library Management System with DAO and Service Layers

#java #jdbc #mysql #oop
Comments
8 min read
How I Built a Java Hotel Reservation System with JDBC and MySQL
hamad_19 profile

How I Built a Java Hotel Reservation System with JDBC and MySQL

#jdbc #java #mysql #beginners
Comments
9 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
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
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.