Jatin Jain Saraf — Engineering Blog

# PostgreSQL 18: A Paradigm Shift for Modern Data Workloads PostgreSQL has long been the gold standard for relational databases, robust, reliable, and continuously evolving.

# Cloud‑to‑Cloud Database Migration: A Practical Guide for Large PostgreSQL Systems Migrating infrastructure from one cloud provider to another is already a complex process.

# The Hidden Architecture Behind Six Degrees of Separation How a social theory quietly explains modern engineering, system failures, and high-impact collaboration. * * * We usually hear Six Degrees of Separation as a social idea, the belief that any two p…

# The Complete Developer’s Guide to Indexing Assets on Supra & Aptos (Coins, FAs, NFTs) As a developer building on a high-performance blockchain like Supra, you’ll soon encounter a critical challenge: indexing and understanding… * * * ### The Complete Dev…

# The PostgreSQL Elephant in the Room: A Deep Dive Into the Architecture That Powers Giants PostgreSQL’s reputation for resilience, consistency, and performance isn’t accidental.

# From Lag to Leading: A Deep Dive into Fixing a 2-Hour PostgreSQL Replication Lag Every engineer responsible for a large database fears the “big one” — a problem so severe it brings operations to a crawl.

# Taming PostgreSQL Replication Lag in Real-Time Blockchain Indexers In distributed systems that process massive volumes of real-time data, such as blockchain indexers, database replication is essential for… * * * ### Taming PostgreSQL Replication Lag in…

# Understanding Source Code vs Bytecode in Move-Based Blockchains In Move-based blockchains such as Aptos or Sui, smart contracts are written and deployed using the Move language.

# 🔍 Demystifying API Gateway Patterns: Design Choices, Real-World Use Cases & When to Use What In today’s rapidly evolving software world, especially where microservices and distributed systems dominate, API gateways have become more… * * * ### 🔍 Demystif…

# Handling Large Datasets & High-Traffic Queries: Optimizing Pagination, Sorting & Filtering Performance optimisation becomes a critical challenge when dealing with millions of records in a database.

# The Ultimate Git Command Guide: Streamline Your Development Workflow Introduction * * * ### The Ultimate Git Command Guide: Streamline Your Development Workflow ### Introduction Git is a vital tool for developers, offering effective version control, tea…

# Strings in JavaScript: An In-Depth Guide Strings are a fundamental part of programming in JavaScript, representing textual data.

# Choosing Between Type and Interface in TypeScript: A Detailed Guide When working with TypeScript in Node.js, you often need to define the shape of objects.

# Unveiling the Power of Descriptive Naming Conventions in JavaScript Introduction: * * * ### Unveiling the Power of Descriptive Naming Conventions in JavaScript **Introduction:** In the world of programming, clarity and readability are paramount.

# Navigating Your Career: Deciding Which Skills to Develop at Each Stage As a Full-stack developer with 4 years of experience, I’ve learned firsthand the importance of strategic skill development at every stage… * * * ### Navigating Your Career: Deciding…

# Next Js 14 The most recent version of the popular React Framework for building and developing web applications, Next.js 14, was released on October… * * * ### Next Js 14 The most recent version of the popular React Framework for building and developing…

# Linux Terminal Basics Commands: File and Directory Commands: ls: List files and directories.

# ES Conventions ES6 * * * ### ES Conventions **ES6** - [The let keyword](https://www.w3schools.com/js/js_es6.asp#mark_let) - [The const keyword](https://www.w3schools.com/js/js_es6.asp#mark_const) - [Arrow Functions](https://www.w3schools.com/js/js_es6.a…

# 40 Best Practices for Writing Clean JavaScript, React, and Node.js Code When working on JavaScript, React, or Node.js projects, following best practices is essential for code readability, maintainability, and… * * * ### 40 Best Practices for Writing Cle…

# Branching Guidelines and Conventions There are many excellent naming conventions regarding git branches and commits.

# Clustering In NodeJs When multiple CPU cores are available, Node.js does not utilize them all by default.

# Sequelize using Postgres dialect Introduction to Sequelize * * * ### Sequelize using Postgres dialect * * * ### **Introduction to Sequelize** > [**Sequelize**](https://sequelize.org/) _is a popular Object-Relational Mapping (ORM) library for Node.js, wh…