-
Postgres from a Developer Lens – Part 1

If you are currently on a team using Postgres as your primary database and using ORM, then there is a high chance that the developers miss out on some of the nuances of how Postgres executes the queries generated by the ORM and may end up discovering things in production. In this series, I will…
-
Vectors and Similarities

Given, we understand what vectors are from previous blog and what magnitude and direction represent, We will see how to measure the “closeness” or “similarity” between vectors with simple example. Two of the most common metrics are Cosine Similarity and Dot Product. While both are derived from the same mathematical operations, they capture different aspects…
-
Vectors: The Unsung Heroes Powering Machine Learning

Have you ever wondered how Netflix recommends your next binge-worthy show, how Google understands your search queries, or how your phone recognizes faces in photos? The magic behind these seemingly complex feats of artificial intelligence often boils down to a surprisingly simple yet incredibly powerful mathematical concept: vectors. In the world of Machine Learning (ML),…
-
The Database Dilemma: Factors to consider when choosing a Database for your application

Selecting the right database for your application is crucial for ensuring optimal performance, scalability, and maintainability. With a plethora of databases available today, making an informed decision can be overwhelming. This blog post aims to provide valuable and relevant information to developers and architects, helping them make better decisions when choosing a database for their…
-
Navigating Postgres- A guide to Identify bottlenecks

Have you been in a situation, where your database is becoming a bottleneck with growing data? API latency increases due to DB bottleneck?You are close to hitting the threshold of vertically scaling up your database? Well, I hope this guide will help you identify the bottlenecks and what you can do to mitigate it. Here…
-
Postgres from a Developer’s lens – Part 2

Case study A team was building a stock-keeping system which was responsible to manage stocks of products in a facility. The system should be able to decrement the stocks as part of order demand and give an visibility into which stock is available in which facility. As part of this system design, they team designed…
