Moving from MySQL JSON to Postgres arrays
Transitioning from JSON columns to native Postgres arrays provides a more efficient approach for handling simple list-based data structures through indexing and direct querying.
Read moreBlog
One thing I learn every day
Purge Problematic Files from Git History
Removing sensitive or problematic files from Git history requires a complete purge to ensure they do not reappear during future merges or rebases.
Read more
The Strange Case of a Broken Git Path
Exploration of how mixed directory separators between Unix and Windows lead to Git repository checkout failures and the necessary steps to restore a clean file history.
Read more
Deciphering the Dominance of Ashburn in Web Analytics
Tracing my blog traffic by IP revealed a surprising concentration of requests from Ashburn, Virginia, and the reason behind it turned out to be more interesting than expected.
Read more
Building a Threads or Instagram-like Feed System with Redis
Exploring the architectural patterns for building high-performance feed systems by leveraging Redis sorted sets, atomic operations, and efficient caching strategies.
Read more
Examine Division By Zero Behavior Across Programming Languages
Different programming languages handle division by zero in varied ways, ranging from throwing critical exceptions to generating special floating-point values like Infinity or NaN.
Read more