Stop Using != deleted_at: Database Soft Delete Performance Guide
In the world of massive applications, "deleting" data is rarely simple. We almost never actually…
Database
Tips
Database
Top 10 Must-Know Facts About TiDB for Beginners
In the modern world of software development, data is growing at an unprecedented rate. Traditional…
Database
MySQL
MySQL Performance Pitfall: Querying a String Column with a Number
When working with MySQL, it’s common to have columns stored as strings (VARCHAR, CHAR, TEXT).But…
Database
MySQL
NodeJS
Avoid This Mistake with Bulk Insert in Node.js and MySQL
Last week, I ran into a serious performance issue while working on a bulk insert…
Database
NoSQL
Tips
Best Practices for Using Redis: Protect Your App, Reduce Costs, and Optimize Performance 2025
Using Redis efficiently can protect your app, lower costs, and enhance performance. This guide covers…
MySQL
SQL Performance Battle: GROUP BY vs. Self-Join in UPDATE Queries
Which SQL UPDATE query performs better: one using GROUP BY or a self-join? This in-depth…
MySQL
Optimizing GROUP BY in MySQL: Insights from Real-Life Query Analysis
My current query: SELECT eod.date, SUM(eod.stable_price) AS sumStablePrice FROM item_eod eod WHERE eod.date >= CURRENT_DATE…
Database
LIKE vs Full-Text Search: SQL Performance and Use Cases
Explore the differences between SQL’s LIKE operator and Full-Text Search. Learn their syntax, performance, use…
Database
Top 10 Database Optimization and Recovery Strategies for Senior Software Engineers
Master essential database concepts like indexing, query optimization, caching, partitioning, failover, and recovery strategies with…
Database
Database Mastery: Essential Knowledge for Senior Engineers
Unlock the core concepts and advanced techniques of database management tailored for senior engineers. This…