Histograms in SQL

A histogram is an approximate representation of the distribution of numerical data. In other words, histograms show the number of data points that fall within a specified range of values (typically called “bins” or “buckets”). In this post, I’m exploring options for querying data as histogram by using SQL.

Written on December 30, 2020
Read More

Reading in November

November was full of books, new and old. I had quite a lot of time for reading, plus I’ve finally managed to put away my old habit of “If I pick a book I must finish it”. So lots of content is left unfinished. As a side effect, I developed a habit of reading a sample of the book before purchasing it - cost effective and saves a lot of time.

Written on November 25, 2020
Read More

How do I maintain my daily journal

My day is full of context switches, meetings with varying scopes, pending tasks to go through and desperate attempts to clean the email inbox. Rare are the days when I wrap up my working day with an empty to-do list. It is a big challenge to keep things running smooth. Keeping a daily journal is essential for me to get things done and have a sustainable work-life integration.

Written on October 6, 2020
Read More

Arrays - Why O(1) time access?

I was mock interviewing a friend of mine and a question came up: why can you access an element in an array in O(1) time? To answer the question, let’s step back and see how RAM works in computers.

Written on August 1, 2020
Read More