Understanding Kafka

What is Kafka : Kafka is publish and subscribe messaging system which is durable, fast , scalable and fault-tolerant with exceptional performance and high throughput. What Kafka is Used for : Kafka is used for stream processing, website activity tracking, metrics collection and monitoring, log aggregation, real-time analytics, ingesting data into Spark, ingesting data into […]

How to update million+ rows in MySQL

There are some use cases when we need to update a table containing more than million rows. There exist many solution To update row wise. We can do this by writing a script, making a connection to database and then executing queries. Another good way to create another table with data to be updated and […]

PL/SQL Programming MySQL

PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database. The Syntax for a PL/SQL Block DECLARE variable_declarations BEGIN program_code EXCEPTION exception_handlers END; CREATE PROCEDURE and CREATE FUNCTION Syntax in MySQL: DROP PROCEDURE IF EXISTS CALLS; DELIMITER ;; CREATE PROCEDURE […]

Design Patterns

Design patterns are the best practices to solve out specific problems that have evolved over time. Over the many years of practicing software development, experts have figured out ways of solving similar problems. These solutions have been encapsulated into design patterns. Design pattern is a reusable software solution to a specific type of problems. It […]

Getting started with Kafka

Kafka is a fast, scalable, durable, and fault-tolerant publish-subscribe messaging system. Kafka Fundamentals: Topic is a stream of records Records have a key , value and timestamp. Producer API to produce a stream of records.  Consumer API to consume a stream of records. Topic is like a feedname /shopping-cart. /user-signup which producers write to and […]