TL;DR: To make an Agent Skill, you start a conversation with AI, do exactly what you do in daily work, do ask and answer with the AI, and at the end, summarize everything into a markdown file (with...

At the time of writing this article, a lot of developers are using coding AI to help them write code. I’m one of them, and I use coding AI a lot, often hitting the five-hour limit. It’s a frustrati...

Having worked with databases for 9 years, I have collected some tips and tricks that help me design and operate database systems more effectively and easily. In this post, I will list them and expl...

Whenever we work on database optimization, the first solution that comes to mind is using indexes, right? It’s kind of a silver bullet that solves every performance bottleneck for us, until it harm...

TL;DR: I replaced AWS managed services with self-hosted solutions on UAT environments, resulting in a yearly savings of $37620. A brief history of our infrastructure Three years ago, at the begin...

An evolution of the way I create software versions: from a novice coder to my own definition of versioning. Self awareness Long ago, when I first entered the industry and began using Git as a ver...

Yesterday, I woke up early, as I do on many other days, and performed some checks on an alert system. While some alerts were annoying, a critical one appeared right in front of me - a SQL query tha...

The identity property of a database record, the ID, is the most important property to consider when designing your database. Without it, you may not be able to find the exact record you want, or ma...

In previous blog post titled The art of Export, I covered various aspects of the exporting data. In this post, we will discuss about the oposite workflow: importing data. The solution chosen for im...

Almost every system has a dataflow that involves exporting entities for various purposes. Having worked with these systems for eight years, I have encountered a variety of ways to implement them, b...