Efficient way to select the first row from each group in PostgreSQL
November 29, 2023Recently, I encountered a situation where I had to optimize an SQL query due to PostgreSQL’s excessive CPU utilization. The query itself…
Using ResourceAccount context key to scope down IAM role permissions
November 27, 2023AWS Identity and Access Management (IAM) is a service that allows to control access to AWS resources. IAM supports various identities…
Running Microsoft Orleans in AWS ECS
October 05, 2020Microsoft Orleans is a great framework for building distributed systems. It runs many little silos that do their bit of work. In order to…
Robust caching with Redis
December 25, 2019Sometimes querying the database can be slow. Especially, if the tables are large and it’s not possible to take advantage of existing indices…
Automatic code formatting for .NET projects
September 29, 2019Every programmer has its own coding style preferences, but software development teams should have a well defined standards. It makes it…
Living the Full-Stack Life
September 25, 2019An obligatory welcome post.