blog

2025-06-05

Why email address should't be used as primary key?

Uniquely identifying users is a fundamental requirement in most software systems. While using email addresses as primary keys is common and often convenient, there are important reasons why this approach...

Read More πŸ‘‰

2025-05-12

How Do Servers Handle More Than 65,535 TCP Connections?

When working with TCP/IP, it’s commonly known that the source and destination ports are 16-bit numbers. That means the theoretical maximum number of TCP connections a server can have with...

Read More πŸ‘‰

2025-05-11

Test Containers : An Integration Testing Weapon

Testcontainers is a set of open source libraries that provides easy and lightweight APIs for bootstrapping local development and test dependencies with real services wrapped in Docker containers. Using Testcontainers,...

Read More πŸ‘‰

2025-05-09

Concurrency Redefined

At first glance, it may seem that two operations are concurrent if they occur at the same time on different systems or processes. However, in distributed systems, concurrency shouldn’t be...

Read More πŸ‘‰

2025-04-27

Kafka and Data Loss: What Most Engineers Miss

Kafka is designed to be durable by default. Every log message sent to kafka is written to disk and replicated across multiple brokers to ensure fault tolerance. However, under certain...

Read More πŸ‘‰

2025-04-24

MoSCoW Prioritization?

MoSCoW prioritization, also known as the MoSCoW method or MoSCoW analysis, is a popular prioritization technique for managing requirements.

Read More πŸ‘‰

2025-04-24

Write-Ahead Logging (WAL), Change Data Capture (CDC) & PostgreSQL

In this article, we dive into the core concepts of Write-Ahead Logging (WAL) and Change Data Capture (CDC) β€” two critical mechanisms for ensuring data durability, consistency, and real-time data...

Read More πŸ‘‰

2025-02-05

Building Consistent Audit Log System with Change Data Capture (CDC)

Capturing reliable and consistent audit logs is essential for traceability, compliance, and debugging. This blog explores how to build a consistent audit logging system using Change Data Capture (CDC). We’ll...

Read More πŸ‘‰

2024-06-18

A simple group scoped counter system (PostgreSQL/MongoDB/MySql)

Id of every new task in JIRA board starts with 1 and increments by 1 for each new task. There isn’t any database that supports group scoped auto increment. Let's...

Read More πŸ‘‰