Blog
Technical articles about databases, cloud infrastructure, and software development
What is WAL - Write Ahead Log?
WAL is a mechanism for ensuring data durability, consistency, and crash‐recovery in databases by writing changes to a log before applying them to on‐disk files.
When Indexing Doesn't Help: Issues with RDS Performance
While indexing can speed up queries, in cases like high write rates, low‐cardinality or skewed columns, and large text fields it may provide little benefit or even slow down performance.
Monitoring Kafka Consumers and Publishers: Best Practices
Covers key Kafka metrics—consumer lag, throughput, error rates, end‐to‐end latency, and broker health—and recommends using built‐in tools or platforms like Prometheus/Grafana for real‐time monitoring.
Technical Architecture for Realtime Candlestick Pattern Recognition
Details a serverless AWS Lambda + Python stack with MySQL/Redis for real‐time OHLC ingestion, pattern detection, SNS‐based event publishing, history persistence, and monitoring/security best practices.
End to End Deployment of JavaScript Application to Kubernetes - Part 2
Shows how to define Deployment and Service YAMLs, apply them via kubectl, verify pods/services, and access the app through a LoadBalancer or Minikube IP.
End to End Deployment of JavaScript Application to Kubernetes - Part 1
Walks through creating a simple Express server, writing a Dockerfile and .dockerignore, building/testing the Docker image, and preparing for Kubernetes deployment.