Best of MySQL — July 2025

1. 1
   Article

   strongdm·47w

   PostgreSQL vs. MySQL: Differences for Tech Leaders & Teams

   PostgreSQL excels at complex, write-heavy workloads with advanced SQL features, rich data types like JSONB, and strict ACID compliance, making it ideal for financial systems and analytics. MySQL prioritizes speed and simplicity for read-heavy applications, offering lightweight architecture perfect for web apps, CMSs, and MVPs. PostgreSQL provides superior extensibility, query optimization, and enterprise features, while MySQL delivers faster performance for simple queries and lower resource consumption. The choice depends on workload complexity, data consistency requirements, and scalability needs.

   260

   11
2. 2
   Article

   Towards Dev·43w

   MySQL + CDC (without Kafka) to update configs in real-time

   A technical implementation guide for setting up real-time configuration updates using MySQL Change Data Capture (CDC) with Debezium in embedded mode, streaming to AWS Kinesis instead of Kafka, and updating Redis configurations. The solution uses AWS services like DynamoDB for offset storage, Secrets Manager for credentials, and ECS for deployment, with comprehensive monitoring through Prometheus, Grafana, and ELK stack.

   19
3. 3
   Article

   Groww Engineering·43w

   Making a Real-Time Stock Screener in Groww

   Groww built a real-time stock screener handling 2+ million writes per minute using a single 4-core MySQL instance. The system uses in-memory aggregation to reduce database writes, CDN-based hash caching to handle 50K reads per minute, and a custom query language for extensible filtering. Key optimizations include buffering tick data in memory, selective persistence of minute-level aggregates, and 30-second CDN caching that reduced backend load by 80%. The modular architecture powers multiple screener types and enables rapid feature development.

   17