Data Lake vs Data Warehouse vs Data Mart
The term "Data Lake", "Data Warehouse" and "Data Mart" are often times used interchangbly. But what are exactly the differences between these …
The term "Data Lake", "Data Warehouse" and "Data Mart" are often times used interchangbly. But what are exactly the differences between these …
Why and how we built a multi-tenant job queue system for our B2B SaaS Application with PostgreSQL and Ruby
As business owners, understanding your customers’ behaviour is among the key things that will help you grow your business. If you’re …
Cohort Retention Analysis is a powerful thing that most business owners need to look at. In this post, I'm going to give …
Below are some useful Postgres queries for both troubleshooting, monitoring and analytics purpose. Note: if you're looking for a simple tool to …
As I'm writing this, we've just removed the last line of AngularJS code from our application codebase, ending a 4-month non-intrusive effort …
As you progress in your business, it's becoming more and more difficult to keep track of the small or big events that …
Recently one of our customers, Grab - the Uber's competitor in SEA, unicorn startup - published a blog post on how they …
In this article I will show you how to build daily user growth report with cumulative number (running total) using mostly SQL, …