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…
All topics
Database
MySQL
Tips
All topics
Architecture & Design
Database
MySQL
NodeJS
Others
Tips
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…
All topics
Database
MySQL
NoSQL
Others
PostgreSQL
Security
Tools
🔐 sqlmap: Automate SQL Injection Testing Like a Pro in 2025
Table of Contents What is sqlmap? Why SQL Injection Still Matters Installing sqlmap Basic Usage…
All topics
Database
Gems
MySQL
Others
PostgreSQL
Ruby
Ruby on Rails
Tips
How a Simple Migration Took Down Our System for 20 Minutes — And How to Never Let That Happen Again
"ALTER TABLE looked harmless. On staging, it ran in 0.4s. In production, it locked the…
All topics
MySQL
Tips
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…
All topics
Database
MySQL
Others
Tips
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
Interview Question
MySQL
NodeJS
NoSQL
PostgreSQL
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…
All topics
7 Essential Caching Strategies to Boost Backend Performance and Scalability
Discover 6 powerful caching strategies to enhance backend performance and scalability. From in-memory and distributed…
All topics
Database
MySQL
Enhancing Text Search in MySQL: A Comparison of SOUNDEX and Full-Text Search
In many applications, efficient text search capabilities are critical for delivering fast and relevant results…
All topics
Database
PostgreSQL
Postgres Index Methods: Things you need to know
In PostgreSQL, different types of index methods are used to optimize query performance, especially for…