A practical look at MySQL CTEs, recursive queries, and the mental model behind WITH RECURSIVE.
WITH RECURSIVE: One MySQL Function to Rule Them All
dr@strangelog:~$whoami
anand siva
dr@strangelog:~$echo $WELCOME
Hi my name is Anand!
Welcome to my personal blog.
I will be writing about
tech, table tennis, and my cats
dr@strangelog:~$echo $CATLIFE
/\\_/\\
( o.o )
> ^ <
Midnight Rollback to Nowhere: MySQL Crash Recovery and Rollback Hell
A practical look at MySQL crash recovery, massive transaction rollbacks, and why an OOM-killed database can get stuck in rollback hell.
Letting Go: The Hardest Skill I Didn’t Know I Needed
A reflection on burnout, control, and why learning to step away from work can make you more effective
Rise of the DBSentinel
Starting an open-source database monitoring tool to bring DBA insights into one place.
Why Redis Doesn’t Ship an RPM (and How to Build One)
Why Redis offers an official APT repo but not a YUM repo, plus a practical guide to RPM packaging and building with spec files on RHEL-based systems.
Why Redis Streams Will Quietly Crash Your System
cover photo credit - https://lightning.ai/pages/community/tutorial/redis-for-machine-learning/
Redis Streams feels safe. Messages get processed, you ACK them, and everything keeps moving. Nothing backs up, dashboards look clean, and your workers stay busy.
Then one day Redis starts behaving badly — not because of traffic, not because of a bug, but because memory quietly grew without anyone noticing. This post is about the assumption that caused that, and how Redis Streams actually behaves in production.
Docker Debugging Playbook: When Builds and Containers Fail (Part I)
A practical, real-world approach to debugging Docker builds and containers that fail before they even start.
Pursuit of Happyness Perfection
My constant quest for happiness keeps getting interrupted by perfection
Ansible Fundamentals
How to use ansible for the first time
Post With Picture
Best Meme