PostgreSQL Performance Tuning: Visualizing Bottlenecks with EXPLAIN (ANALYZE, BUFFERS)When your application slows down, the culprit often lies somewhere in your database queries — whether it’s CPU time, disk I/O, or memory…1d ago1d ago
Foundations of Linear Algebra for Machine Learning BeginnersDemystifying vectors, matrices, and linear transformations for aspiring machine learning practitioners2d ago2d ago
SQL UNION Doesn't Sort the Way You Think — Here's a Simple FixWhile working on a feature in my Rails app, I noticed that combining two queries using UNION didn’t sort the results the way I expected…Jun 3Jun 3
Stop Copying Branch Names Manually: Use fzf to Switch Git Branches EffortlesslyIf you’re like me, you’ve probably found yourself repeatedly copying and pasting branch names just to run git checkout or git pull. This…May 22May 22
Why Sora Stood Out in My AI Image Generation ShowdownIntroduction Over the past month, I put four leading AI image generators — OpenArt.ai, Leonardo.ai, Sora, and Recraft.ai — through their…May 12May 12
How to Enhance the Performance of CursorWorking with modern JavaScript/TypeScript projects often means dealing with a massive node_modules directory. While Cursor’s code-search…Apr 28A response icon1Apr 28A response icon1
Automating Gmail Deletion with GoManaging an overflowing inbox can be challenging, especially when old emails pile up over the years. Fortunately, with the Gmail API and…Feb 10Feb 10
Adopting a Modular Monolith with Event-Driven Architecture to Handle Time-Consuming APIsHandling time-consuming APIs in a monolithic architecture can be a significant challenge, often leading to server timeouts and poor user…Jan 12Jan 12
