Umair Abid

Traveling time with Postgres Range Columns

Case Studies

In Challenges of Time-Based Systems Without Proper Database Structures, we looked into everything that went wrong when we tried to build a temporal system without a compatible foundation. In this article, we will describe how we added that foundation to support temporal use cases. We will start by discussing how

7 min read

Challenges of Time-Based Systems Without Proper Database Structures

Case Studies

When we store information in our database, we normally store it without a time dimension even if it is only valid for a specific period of time. For example, people move around all the time, but most apps ask for your current address and rely on you to change it

7 min read

Automation Engine Refactor for Performance and Maintainability

Case Studies

Imagine starting your day with your mailbox full of outages due to all database connections being held up for an extensive period. Nobody likes it and our team went on a mission to ensure we never have such a day again, at least for the exact root cause. Situation The

5 min read