Category: Uncategorized
-
Learning Notes #51 – Postgres as a Queue using SKIP LOCKED
Yesterday, i came across a blog from inferable.ai https://www.inferable.ai/blog/posts/postgres-skip-locked, which walkthrough about using postgres as a queue. In this blog, i jot down notes on using postgres as a queue for future references. PostgreSQL is a robust relational database that can be used for more than just storing structured data. With the SKIP LOCKED feature…
-
Learning Notes #50 – Fixed Partition Pattern | Distributed Pattern
Today, i learnt about fixed partition, where it handles about balancing the data among servers without high movement of data. In this blog, i jot down notes on how fixed partition helps in solving the problem. This entire blog is inspired from https://www.linkedin.com/pulse/distributed-systems-design-pattern-fixed-partitions-retail-kumar-v-c34pc/?trackingId=DMovSwEZSfCzKZEKa7yJrg%3D%3D Problem Statement In a distributed key-value store system, data items need to…
-
Learning Notes #49 – Pitfall of Implicit Default Values in APIs
Today, we faced a bug in our workflow due to implicit default value in an 3rd party api. In this blog i will be sharing my experience for future reference. Understanding the Problem Consider an API where some fields are optional, and a default value is used when those fields are not provided by the…
-
POTD #19 – Count the number of possible triangles | Geeks For Geeks
Problem Statement Geeks For Geeks – https://www.geeksforgeeks.org/problems/count-possible-triangles-1587115620/1 Given an integer array arr[]. Find the number of triangles that can be formed with three different array elements as lengths of three sides of the triangle. A triangle with three given sides is only possible if sum of any two sides is always greater than the third…
-
Learning Notes #48 – Common Pitfalls in Event Driven Architecture
Today, i came across Raul Junco post on mistakes in Event Driven Architecture – https://www.linkedin.com/posts/raul-junco_after-years-building-event-driven-systems-activity-7278770394046631936-zu3-?utm_source=share&utm_medium=member_desktop. In this blog i am highlighting the same for future reference. Event-driven architectures are awesome, but they come with their own set of challenges. Missteps can lead to unreliable systems, inconsistent data, and frustrated users. Let’s explore some of the…