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 Performance: Real Benchmarks Compared

PostgreSQL vs MySQL Performance: Real Benchmarks Compared

Comments
8 min read
There Is No Maintained dbt Adapter for MySQL. Here Is What That Means for Your Pipeline

There Is No Maintained dbt Adapter for MySQL. Here Is What That Means for Your Pipeline

1
Comments 1
3 min read
Storage Engines Explained: B-Tree vs LSM Tree

Storage Engines Explained: B-Tree vs LSM Tree

Comments
5 min read
What Is MySQL? How the Popular Database Works, Explained Simply

What Is MySQL? How the Popular Database Works, Explained Simply

Comments
6 min read
Readyset vs Read Replicas: Which Should You Use to Scale Reads?

Readyset vs Read Replicas: Which Should You Use to Scale Reads?

Comments
10 min read
Building a niche CRM + ERP on plain PHP and MySQL: lessons from DGA CRM

Building a niche CRM + ERP on plain PHP and MySQL: lessons from DGA CRM

Comments
2 min read
MySQL ENUM vs CHECK Constraint: Which Value List Changes Copy the Table

MySQL ENUM vs CHECK Constraint: Which Value List Changes Copy the Table

Comments
10 min read
MariaDB to MySQL Migration: Which Schema Features Break, and How to Find Them First

MariaDB to MySQL Migration: Which Schema Features Break, and How to Find Them First

Comments 2
12 min read
Telling apart 3 reasons MySQL isn't using your index

Telling apart 3 reasons MySQL isn't using your index

Comments
8 min read
SaaS App Data Backups — Managed Database Recovery and Object Storage for Postgres/MySQL

SaaS App Data Backups — Managed Database Recovery and Object Storage for Postgres/MySQL

Comments
6 min read
How Sentinel's Database Autopilot Decides What to Fix (And When to Leave Things Alone)

How Sentinel's Database Autopilot Decides What to Fix (And When to Leave Things Alone)

Comments
3 min read
SQL WHERE vs HAVING: Differences, Execution Order and When to Use Each (Tested Examples)

SQL WHERE vs HAVING: Differences, Execution Order and When to Use Each (Tested Examples)

Comments
11 min read
How to add typo tolerance to a MySQL product search without scanning every word

How to add typo tolerance to a MySQL product search without scanning every word

Comments
3 min read
Modeling hospital procurement bidding: lessons from my graduation project

Modeling hospital procurement bidding: lessons from my graduation project

Comments
8 min read
What Is Database Sharding, and When Should You Shard?

What Is Database Sharding, and When Should You Shard?

Comments
12 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.