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 […]

Starting with React

React is a JavaScript library for building user interfaces. React has a few different kinds of components, that are part of React.Component subclasses. Install npm and then run following commands on terminal to start with react. npm install -g create-react-app create-react-app my-app cd my-app npm start It will take you to browser on URL localhost:3000. First call is in […]

Web Frameworks

“Web frameworks” are the de facto way to build web-enabled applications. So basically how the web “works”.  A web browser initiates a request to webserver and then webserver sends the content in response. HTTP Browsers download websites from web servers (or “application servers”) using the HTTP protocol (a protocol, in the realm of programming, is […]