@krishnapro

SQL COALESCE vs CASE: Why COALESCE is Better for Handling NULL Values

Oct 19, 2024 · 2 min read · In SQL, dealing with NULL value is a common task especially when querying large datasets with missing or incomplete data. Generally, we use CASE expression and COALESCE to handle NULL value. While both can achieve similar goals, COALESCE is typically...

System Design: Load Balancing

Aug 10, 2024 · 5 min read · Load balancing is a crucial component of system design, especially for ensuring that applications can handle high traffic and remain available and responsive. Let's break it down step by step. What is a Load Balancer? Load balancing is the process of...

Scaling: Horizontal vs Vertical Scaling

Jul 7, 2024 · 2 min read · What is scaling? In system Design terms, scaling is the process of increasing the system's performance and resources to handle more traffic or load without making it more complex. There are two types of scaling: Vertical Scaling (Scaling-up) Horizo...

How to Implement User Authentication and Authorization with SpringBoot and JWT

Jun 15, 2024 · 5 min read · If you do a quick search on how to secure REST API in SpringBoot using JWT you will find a lot of the same results. These results contain a method that involves writing a custom filter chain and using third party library for encoding and decoding JWT...

A Beginner's Guide to ProcessBuilder in Java

Feb 4, 2023 · 4 min read · Introduction ProcessBuilder is a class in Java that enables developers to start and manage operating system processes from within their Java applications. This can be useful for executing shell commands, scripts or other applications from your Java c...