Tag: programming

Hash (mis)usage: tales from the prod

Few observations in regards to hash usage, in projects where data volume and spikes in load shift engineering from the KISS paradigm to the extent where you have to really care about underlying technologies and data structures. There are different hash functions tailored for different use cases – quick pattern matching in Rabin-Karp algorithm, prefix …

Continue reading

Which type of database index you should use?

Overview of available type of indexes in different database engines and corresponding use cases. So, you have some data. Most likely you want to work with it – i.e. retrieve information according to some conditions = filtering what is important for you. Probably, even change the shape of this information – transform the data or …

Continue reading

Language of the data

My ultimate SQL Memo

LLM derive schema from unstructured data and build pyspark ETLs

still, understanding what you can do via plain SQL – allow you to choose what to ask and leverage insights from the data much more efficient

no magick wand – hard work 🙂

Architecture of modern startup

hype wave, pragmatic evidence vs need to move fast Tech side of startups sometimes can be very fluid and contain a lot of unknowns. What tech stack to use? Which components might be overkill for now but worth keeping an eye for in the future? How to balance the pace of business features development while …

Continue reading

On interview preparation: nuances of python

From my perspective mastering particular language is still secondary skills for programmer. For sure it will affects architecture of software and may add advantages for some use cases of handling data flows, but overall, in the long run, decent design of system coupled with carefully catered algorithms much more important. Nonetheless within this article I …

Continue reading

On interview preparation: algorithms and data structures recap

With this article I want to go a little bit further than widespread memos “X most common data structures for interviews”. I am not only interested in information about asymptotic complexity. The real value – understanding whether particular algorithms or data structure can be beneficial in particular case: real life tasks rarely given with hints …

Continue reading

Собеседование на программиста в 2019 – к чему готовиться

Осень-зима 2018-2019 года выдались у меня на редкость насыщенными: ориентировочно, с октября по февраль я поучаствовал в доброй сотне собеседований на позиции уровня Senior-Principal-Lead. Четыре из них были из России (ну мне честно было интересно как тут у нас сейчас), остальные Европа и Англия. Куда-то дальше по разным причинам не хотелось – хотя и пообщался …

Continue reading

How to stop being a junior – 7 hints of programmer productivity

0) If you don’t know something – don’t afraid to ask. Especially if you already checked first page of google search and pretty sure that no one ask that question at stackoverflow. Reinventing the wheel and breaking the stalemate can be a good exercise for your home projects, but in production environment better to check …

Continue reading

7 sins of blatant ignorance and how to avoid them

…You produce software for some time. In most cases it even works. Other developers tend to care about your opinion. Damn, you even wear some fancy title like senior\principal\architect. And here it is – suddenly you were offered to wear really posh title – CTO… This is moment when real troubles get started. I did …

Continue reading

Heterogeneous vector in c++ – overview of common approaches

heterogeneous container in c++

So, you are wondering about heterogeneous vector in c++? Maybe even dare to dream about any suitable substitution of such non-existent container? In another word, you need a generic-like container that can store different datatypes. If you just need a quick answer – stick with std::vector < boost::any> approach or read this, If you need …

Continue reading