Forem

# 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.
Unlock PostgreSQL Performance: A Practical Tuning Guide
Cover image for Unlock PostgreSQL Performance: A Practical Tuning Guide

Unlock PostgreSQL Performance: A Practical Tuning Guide

Comments
4 min read
The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)
Cover image for The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

Comments
3 min read
CDC in AWS: Content Data Capture from AWS RDS MySQL into AWS MSK Kafka topic using Debezium
Cover image for CDC in AWS: Content Data Capture from AWS RDS MySQL into AWS MSK Kafka topic using Debezium

CDC in AWS: Content Data Capture from AWS RDS MySQL into AWS MSK Kafka topic using Debezium

Comments
5 min read
MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis
Cover image for MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

MySQL Path: 4 Hands-On Challenges for Data Entry, User Management, Multi-Table Queries & Sales Analysis

Comments
2 min read
MySQL ALTER TABLE: A Developer’s Guide to Schema Changes
Cover image for MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

MySQL ALTER TABLE: A Developer’s Guide to Schema Changes

Comments
2 min read
🚀 Supercharge Your Laravel App: Master Multiple Databases in Laravel 12!
Cover image for 🚀 Supercharge Your Laravel App: Master Multiple Databases in Laravel 12!

🚀 Supercharge Your Laravel App: Master Multiple Databases in Laravel 12!

Comments
1 min read
MySQL Shutdown Unexpectedly: Causes and Fixes for Developers
Cover image for MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

MySQL Shutdown Unexpectedly: Causes and Fixes for Developers

Comments
2 min read
Indexing and Query Optimization in Laravel
Cover image for Indexing and Query Optimization in Laravel

Indexing and Query Optimization in Laravel

2
Comments
2 min read
Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

5
Comments
3 min read
SQL Database Concepts:

SQL Database Concepts:

Comments
1 min read
concat() vs Group_concat()

concat() vs Group_concat()

1
Comments
1 min read
Scaling Read Tracking with Redis Bitmaps
Cover image for Scaling Read Tracking with Redis Bitmaps

Scaling Read Tracking with Redis Bitmaps

5
Comments
2 min read
Memilih Primary Key, INT Auto Increment vs UUID

Memilih Primary Key, INT Auto Increment vs UUID

1
Comments
2 min read
SQL LIKE Operator: What It Is, How It Works, and Best Practices
Cover image for SQL LIKE Operator: What It Is, How It Works, and Best Practices

SQL LIKE Operator: What It Is, How It Works, and Best Practices

Comments
2 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains
Cover image for SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

1
Comments 1
14 min read
Building Altus 4: Why I Created an AI-Enhanced MySQL Search Engine (Instead of Just Using Elasticsearch)
Cover image for Building Altus 4: Why I Created an AI-Enhanced MySQL Search Engine (Instead of Just Using Elasticsearch)

Building Altus 4: Why I Created an AI-Enhanced MySQL Search Engine (Instead of Just Using Elasticsearch)

Comments
6 min read
HAVING Condition Pushdown: Optimizing Query Performance
Cover image for HAVING Condition Pushdown: Optimizing Query Performance

HAVING Condition Pushdown: Optimizing Query Performance

2
Comments
3 min read
SQL Mini project :WC24 T20 Data Analytics

SQL Mini project :WC24 T20 Data Analytics

Comments
1 min read
Top 6 MySQL Database Management Struggles for Laravel Developers (And Smart Fixes)
Cover image for Top 6 MySQL Database Management Struggles for Laravel Developers (And Smart Fixes)

Top 6 MySQL Database Management Struggles for Laravel Developers (And Smart Fixes)

Comments
7 min read
ShannonBase — The Next-Gen HTAP Database for the AI Era
Cover image for ShannonBase — The Next-Gen HTAP Database for the AI Era

ShannonBase — The Next-Gen HTAP Database for the AI Era

Comments
3 min read
Brighter: Migração do MySQL Outbox para a V10
Cover image for Brighter: Migração do MySQL Outbox para a V10

Brighter: Migração do MySQL Outbox para a V10

Comments
5 min read
Brighter: Migrating MySQL outbox to V10
Cover image for Brighter: Migrating MySQL outbox to V10

Brighter: Migrating MySQL outbox to V10

Comments
4 min read
Tesla Financial Analysis Dashboard using Python, SQL & Power BI
Cover image for Tesla Financial Analysis Dashboard using Python, SQL & Power BI

Tesla Financial Analysis Dashboard using Python, SQL & Power BI

Comments
1 min read
MySQL Views & Window Functions: Advanced Data Analysis Techniques
Cover image for MySQL Views & Window Functions: Advanced Data Analysis Techniques

MySQL Views & Window Functions: Advanced Data Analysis Techniques

Comments
2 min read
August 2025 At Releem - Recommendations Impact & Redundant Index Detection
Cover image for August 2025 At Releem - Recommendations Impact & Redundant Index Detection

August 2025 At Releem - Recommendations Impact & Redundant Index Detection

Comments
2 min read
loading...