The EXPLAIN ANALYZE command in SQL is a powerful tool for optimizing query performance by providing insights into query execution plans and resource usage. In this post, we explore how to use EXPLAIN ANALYZE effectively to identify and resolve performance bottlenecks in SQL queries.
Read moreMy Blog
Thoughts, ideas, and learnings from my journey in software development
Watch is a neat new feature of Docker compose that allows to monitor for file changes and automatically execute actions like sync the modified files to the container or restart the service. This feature can be a great alternative to traditional livereload solutions, and in this article I will show you a practical example of how to use it.
Read moreDevenv is a tool that allows to create Fast, Declarative, Reproducible and Composable Developer Environments using Nix. In this article we will explore how to use Devenv to manage development environments with a real world example.
Read moreIn an age dominated by social media and algorithm-driven content, I find solace in the simplicity and reliability of RSS feeds. This article explores how I use RSS to curate my news consumption, ensuring I stay informed without the noise and distractions of modern platforms.
Read moreThe modern web is flawed. Ads are everywhere, social media algorithms prioritize engagement over truth, and tracking has become the norm. But it doesn't have to be this way. It this article I will explore how we can reclaim the web, by rediscovering the core protocols and technologies that powered the early web, and modernizing them for today.
Read more