Handling large datasets efficiently requires careful consideration of three key factors: Input – Where the data originates (CSV, Oracle, etc.). Process – How the data is processed (Spring Boo...

Lock mode The numeric values for this column map to these text values for the lock modes for table locks: 0- NONE: lock requested but not yet obtained 1- NULL 2- ROWS_S (RS): Row Share Loc...

Tables that provide Stats pg_stat_activity : shows information related to the current activity of that process. pg_class : catalogs tables that shows information about table, view, index, etc...

Using an index is one of the common ways to optimize performance. And there are things, need to be considered while creating it. Like, what happens when multiple fields need to be used for inde...

The @TestConfiguration is one of the annotations, which can be used for writing unit tests or integration tests in a Spring Boot Application. Since, @TestConfiguration is not a new thing, and it ha...

In this article, we are going to look at the spring-boot internals, which explains how it start-up and how does component scanning work. Although, spring boot itself is huge, and many areas might n...

Don't Repeat Yourself for sake of others. So, there is nothing new in here, that hasn’t been elaborated on by many other authors. I am just noting it down and extracting major parts of it. So, let...

Dependency <dependency> <groupId>org.springframework.kafka</groupId> <artifactId>spring-kafka</artifactId> <version>2.7.2</version> </depend...

Startup First, you need to download Apache Kafka. And extract it to your desired folder. If you go inside the Kafka directory, something like this kafka_2.13-2.8.0, you will more likely see config...

To follow the below sections, you need to set up the Apache Kafka. And for that, you can follow the steps define in startup section. After the installation, go to the Kafka directory, something li...