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…
All topics
Database
MySQL
Others
PostgreSQL
Ruby
Tips
Tools
Laragon: The Ultimate Lightweight Development Environment for Windows
Introduction Setting up a local development environment is often a daunting task for developers. Tools…
Database
Interview Question
MySQL
NoSQL
Tips
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
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…
Database
Interview Question
MySQL
NoSQL
PostgreSQL
Database Mastery: Essential Knowledge for Senior Engineers
Unlock the core concepts and advanced techniques of database management tailored for senior engineers. This…