$ cd ~
Background image
Avatar

Sergei Gannochenko

Business-oriented fullstack engineer, in ❤️ with Tech.
Golang, React, TypeScript, Docker, AWS, Jamstack.
15+ years in dev.
Image by Caspar Camille Rubin on Unsplash

Latest in Blog

14.11.2023
Create database fixtures for unit testing: a Golang kata
In todays brief kata I wanted to share my views on how fixtures for unit tests must be managed.Read the post
09.11.2023
The hooks pattern in Go: a Golang kata
Not so long ago I had to solve a performance issue. When reading an enormous amount of records I had to filter it by another massive left join. I started to play around with the query, trying to optimise it, but ultimately the query time was still way above the tolerable.Read the post
24.10.2023
Accessing GCP BigQuery: a Golang kata
Recently I got a task of scraping some data from one of our BigQuery tables. It could be easily done through the GCP console, however, my personal account has not had the necessary access. On the other hand, a service account that was at my disposal, had it. So, an obvious solution was to make a small Golang script that makes a query to the desired BQ table.Read the post
01.09.2023
Dependency management for the dependency injection pattern: a Golang kata
I made a kata on the dependency injection pattern before. The way I managed the dependencies was fine at that time. However, in a real life project, when the amount of dependencies grows, this may, and will turn into a hassle. The amount of imports and the boilerplate size becomes crazy high, and it basically gets repeated in every file!Read the post
15.08.2023
Scripting for better devops: a Python kata
I like automating things, so I try cutting edges where possible. One of the tiny annoying troubles bugging me was figuring the right live database to connect to, or the right cluster to select with kubectl, while knowing only a country name. Surely, if someone has just 2-3 countries, or even regional deployment, this does not turn into a problem at all. But if the deployment has 30, 40, 70 countries?Read the post
See all posts →