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.
How to Connect MySQL Database with Selenium Tests in C#

How to Connect MySQL Database with Selenium Tests in C#

5
Comments 1
2 min read
MongoDB vs MySQL: A Real-World Performance Showdown Using Disneyland Data

MongoDB vs MySQL: A Real-World Performance Showdown Using Disneyland Data

Comments
4 min read
How to Deploy Your Node.js + MySQL App for Free Using Render and TiDB Cloud

How to Deploy Your Node.js + MySQL App for Free Using Render and TiDB Cloud

3
Comments
4 min read
Memilih Primary Key, INT Auto Increment vs UUID

Memilih Primary Key, INT Auto Increment vs UUID

1
Comments
2 min read
Part 2 - MySQL vs PostgreSQL: Storage Architecture

Part 2 - MySQL vs PostgreSQL: Storage Architecture

Comments
10 min read
Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

5
Comments 2
3 min read
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

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

1
Comments 1
14 min read
🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

Comments
2 min read
🌏 Nusantara-API 🇮🇩 — from MySQL dump to a tiny 420 KB library

🌏 Nusantara-API 🇮🇩 — from MySQL dump to a tiny 420 KB library

Comments
1 min read
SQL Commands Guide

SQL Commands Guide

Comments 3
4 min read
How MySQL Actually Works: A Deep Dive into Database Internals

How MySQL Actually Works: A Deep Dive into Database Internals

5
Comments
16 min read
100 Days of DevOps: Day 66

100 Days of DevOps: Day 66

1
Comments
3 min read
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
How We Built a White-Label Travel Portal Using Real-Time APIs

How We Built a White-Label Travel Portal Using Real-Time APIs

1
Comments
1 min read
(III) Full Analysis of ODS to DWS Layer Design Standards, Covering Data Sync/Storage/Quality Essentials

(III) Full Analysis of ODS to DWS Layer Design Standards, Covering Data Sync/Storage/Quality Essentials

1
Comments
3 min read
HAVING Condition Pushdown: Optimizing Query Performance

HAVING Condition Pushdown: Optimizing Query Performance

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)

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

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

Comments
3 min read
Brighter: Migrating MySQL outbox to V10

Brighter: Migrating MySQL outbox to V10

Comments
4 min read
Brighter: Migração do MySQL Outbox para a V10

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

Comments
5 min read
Tesla Financial Analysis Dashboard using Python, SQL & Power BI

Tesla Financial Analysis Dashboard using Python, SQL & Power BI

Comments
1 min read
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

1
Comments
5 min read
MySQL Views & Window Functions: Advanced Data Analysis Techniques

MySQL Views & Window Functions: Advanced Data Analysis Techniques

Comments
2 min read
loading...