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.
Why Your Slow-Query Log Is Lying to You (a Little)

Why Your Slow-Query Log Is Lying to You (a Little)

Comments
6 min read
Find the indexes your Laravel app is missing, without touching the database

Find the indexes your Laravel app is missing, without touching the database

Comments
2 min read
Building 5 Client-Side Developer Utilities for Laravel & MySQL 8.4 (Zero Backend, Web Crypto API)

Building 5 Client-Side Developer Utilities for Laravel & MySQL 8.4 (Zero Backend, Web Crypto API)

Comments
2 min read
Zero-Rewrite Multi-Tenant SaaS MVP in Laravel 13: Composite Indexes, Redis-Locked Stripe Webhooks & Pest Isolation Tests

Zero-Rewrite Multi-Tenant SaaS MVP in Laravel 13: Composite Indexes, Redis-Locked Stripe Webhooks & Pest Isolation Tests

2
Comments 2
7 min read
5 MySQL Connection Errors in Laravel (and How I Fix Each One)

5 MySQL Connection Errors in Laravel (and How I Fix Each One)

Comments
3 min read
MySQL Group Replication needs node identity, not just encryption

MySQL Group Replication needs node identity, not just encryption

Comments
3 min read
SW Connector 2.0.5: Adding MySQL Support Alongside PostgreSQL

SW Connector 2.0.5: Adding MySQL Support Alongside PostgreSQL

1
Comments 1
2 min read
MySQL to DuckDB: A Binlog CDC Walkthrough Where the Last Step Is ATTACH

MySQL to DuckDB: A Binlog CDC Walkthrough Where the Last Step Is ATTACH

Comments
10 min read
Why the WooCommerce orders page gets slow with 100K orders (and what actually fixes it)

Why the WooCommerce orders page gets slow with 100K orders (and what actually fixes it)

Comments
2 min read
Google Cloud Datastream pricing explained, with examples

Google Cloud Datastream pricing explained, with examples

Comments
2 min read
BigQuery vs MySQL: differences and when to use each

BigQuery vs MySQL: differences and when to use each

Comments
2 min read
How to connect MySQL to BigQuery: 5 ways, including real time

How to connect MySQL to BigQuery: 5 ways, including real time

Comments
2 min read
MySQL to Redshift Without DMS: A Binlog CDC Tutorial Through AWS Glue

MySQL to Redshift Without DMS: A Binlog CDC Tutorial Through AWS Glue

Comments
10 min read
The BIGINT Problem Explained

The BIGINT Problem Explained

1
Comments
4 min read
UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through

UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through

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