Advanced SQL - window frames
Deep dive into more advanced use of window functions with window frames
Michał Konarski
My own space on the Internet
Latest posts
Git aliases I can’t live without
A list of handy Git aliases inspired by oh-my-zsh suite.
I got infected with malware and appreciated by its author
A story about how I got infected with malware, analyzed its machine code and got appreciated by its author.
Advanced SQL - Common Table Expressions
This is the second article in my series discussing advanced SQL concepts. I want to describe features that are well supported in popular database management systems for quite some time, but somehow many people still don’t know about their existence. I’d like to explain them with examples, first giving a problem to solve using “plain old” SQL and then showing a better solution using advanced SQL.
Advanced SQL - window functions
This post starts a series of articles discussing advanced SQL concepts that are well supported in popular database management systems for quite some time, but somehow many people still don’t know about their existence. I’d like to explain them with examples, first giving a problem to solve using “plain old” SQL and then showing a better solution using advanced SQL.
5 things about programming I learned with Go
Go has been gaining a significant popularity over last few months. Language-related articles and blog posts are written every day. New Go projects are started on Github. Go conferences and meetups attract more and more people. This language certainly has its time now. It became a language of the year 2016 according to TIOBE and recently even made its way to their elite club of 10 most popular…
How to avoid inheritance in Ruby?
What’s wrong with the inheritance? Let me illustrate it with an example.