Spreadsheet magic

I once stumbled upon a quote “if people knew how to use grep, awk, sed, and xargs, half of the applications would never need to be created.” I think roughly the same can be said about spreadsheets - knowing how to use just a few features and functions allows handling quite complex use cases within just a few hours. In this post, I’ll cover a few of those most-useful-but-a-bit-complex spreadsheet’s functions and features and show how they combine to build a “habit tracker” spreadsheet.

Correct by design

Building software is hard. Building correct software - the one that does what it is supposed to do - is even harder. There are many well-known tools to achieve correctness after writing the code: manual QA, linters, tests, code reviews, etc. However, ensuring correctness during or even before writing the code - or making it very hard to produce incorrect code - is also possible. There isn’t a single tool, technique, or framework that magically makes your software correct. Achieving it requires some discipline and adherence to a design principle: “design for correctness.”

Tech Lead - things to do, not to do, and delegate

So, you now have a mysterious Tech Lead role. It might have happened due to a promotion (congrats!), team reorganization, changing jobs, or in a few dozens of other ways. No matter which path took you here, things will never be the same. The most substantial change is that you’re not a 100% individual contributor anymore - your scope of responsibility is broader than one person can handle alone. To be successful, you’ll need to undertake a psychological change - let go of controlling (or even doing yourself) many things and trust the team you have to get them done. On the other hand, there are some subtle, easy-to-overlook aspects of work you should influence and shape to make the team effective and efficient. I’m offering my views on what a Tech Lead should and should not do in this post.

Journey through eventsourcing: Part 5 - Support and Evolution

Journey through eventsourcing: Part 5 - Support and Evolution

The launch we covered in the previous post was a major milestone, but not the final destination. In fact, it was a solid foundation for the many improvements made later - from small bugfixes and tuning, to supporting new business initiatives. The design choices we made - eventsourcing, statefulness, distributed system, etc. - affected all of those changes; most often making hard things easy, but sometimes making easy things complex.

Journey through eventsourcing: Part 4 - Pre-flight checks and launch

Journey through eventsourcing: Part 4 - Pre-flight checks and launch

The previous post took us through the implementation phase - the next step was to launch the product. The stakes were high - our new system managed a critically important business process (described in the first post), so we needed to make sure everything runs well. To better understand how the system would behave under production traffic, we have put it through a series of load tests of increasing complexity and load. It allowed us to capture a few issues that, if manifested in production, could have caused significant downtime and losses.


© 2021 Eugeny Kolpakov. All rights reserved.

Powered by Hydejack v9.1.5