Oleg Elantsev

Software engineer posting random thoughts.
READ COMMITTED transaction isolation level

Transaction isolation in PostgreSQL

Recently I was reading “Designing Data-Intensive Applications” book. It covers lots of topics related to creation of reliable, scalable and maintainable data systems and one of the chapter covers a concept of transactions - its meaning, use cases, levels of isolation and reasons why application developers should choose the right one. While many books and articles cover transaction isolation level with pure SQL examples for database users, I decided to go a bit deeper and check how a theory gets connected with actual implementation....

October 2, 2023 · 7 min
VIM editor

I use VIM

9 years ago I became a VIM user (after coding 3 years in XCode), that significantly uplifted my coding skills, C++ knowledge and environment around it. Throughout my career I used different IDEs and code editors: Visual Studio, NetBeans, XCode for iOS & Mac, Eclipse, IDEs from JetBrains (Android Studio, Idea, CLion), Sublime, VS Code. Why did I started using VIM instead of full featured IDE? Responsiveness and minimal input lag (between key press and letter on screen)....

September 10, 2023 · 3 min
Zero donwtime app deployment with Azure App Service

Zero downtime app deployment with Azure App Service

One of the problems in DevOps is deployment of an app seamless for the user, i.e. with zero cold starts and zero downtime. This is how you can achieve zero-downtime deployment of a three tier application with frontend, API and a database, hosted in Azure cloud. Azure App Service is a PaaS for running .NET, .NET Core, Java, Ruby, Node.JS, PHP or Python apps. It provides managed production environment, so no need to patch or maintain OS yourself, and no need to explicitly provision the underneath infrastructure such as VMs....

May 2, 2022 · 2 min
go-pr-watcher tool listing open pull requests

Watch GitHub PRs

I try to cultivate a habit to regularly keep an eye on whats going on in the project, either on user story or code changes levels. User stories are relatively easy to track (still might be improved) with existing tooling, while code changes is a bit more challenging. The typical flow I had for months is checking a dedicated folder in the e-mail inbox, where notification messages were sent for the new comments, raised PRs and PR status changes....

October 24, 2021 · 2 min

Setting up the dev blog in Azure

Cloud technologies is sort of LEGO, I like to build the systems out of these blocks. That is why I decided to start my dev blog in the cloud and first article is about technical aspect of it. For the blog I decided to use static website hosted on cloud storage with connected CDN. It has a few advantages compared to VPS solutions I used before: no need to pay a for VPS and maintain it high availability - at least 99....

December 5, 2020 · 4 min