Personal notes on systems engineering and IT: guides, deep dives, dissections, and sometimes reflections.

RDS-Style Point-in-Time Recovery for Self-Hosted PostgreSQL

One of the features I always found most impressive in RDS was point-in-time recovery. Throughout my career I'd never had an opportunity to work deeply with database administration, so the ability to roll back the state of a database to an exact moment seemed at least magical. Recently I finally had a chance to set up such a feature for our own databases, and today I'm going to share my experience with it and how it's done.

Continue reading →

AWS Lambda MicroVMs

Several days ago AWS announced the launch of Lambda MicroVMs -- a new way of running short-term workflows. Unlike Lambda Functions, a MicroVM spins up a whole micro virtual machine, introducing more use cases, more capabilities, enhanced security and longer execution time (finally!). In this article we will go through new features, differences from Lambda Functions, and new possibilities.

Continue reading →

What's inside the pkpass file?

As a long-time smartphone user, I always found the idea of storing a hefty amount of cards in a single convenient place mighty impressive. Instead of cluttering the whole wallet with plastic, you just add a virtual card to an app -- and it's right there when you need it. After all, the data remains the same -- only the format changes. It's especially convenient (and cool -- I just like the feature so much) for storing temporary data -- cinema tickets, boarding passes, museum tickets, etc. But what's inside these magic pkpass files, exactly? Today we're gonna dive deep into the topic and figure out what convenience looks like under the hood.

Continue reading →

"I think I suck at my job"

I think some of us thought the same at least once. Me, I've thought this hundreds of times. And today, instead of a usual strict technical format, I want to talk a bit and share my thoughts on feeling like an impostor.

Continue reading →

2025 in review

The New Year is nigh, and it's time to look back at the past year. Let's take a look at some numbers and noticeable changes, however big or small they might be. Mostly related to this blog, though some may be personal.

Continue reading →

Advent of Sysadmin 2025

Advent season is here! And that means advent challenges as well!

After a disastrous attempt at Advent of Code last year, this year I was very happy to see that Sad Servers started an Advent challenge of their own -- Advent of Sysadmin! At last, a challenge I can (hopefully) progress further than task 3. And this means more challenges for us to tackle. The Advent will consist of 12 challenges. To keep things slightly more interesting, I will publish the solution to each task the day after it's released: for example, today, on December 2, I will solve the task from December 1, and so on. Have fun!

All tasks are available!

Continue reading →