All Medium Articles

PostgreSQL – CTE

In PostgreSQL, the CTE(Common Table Expression) is used as a temporary result set that the user can reference within another SQL statement like SELECT, INSERT,… Read More

postgreSQL-administration

PostgreSQL

PostgreSQL – Recursive Query

PostgreSQL provides the WITH statement that supports the designing of auxiliary queries also known as CTEs (Common Table Expressions). A recursive query is a query… Read More

postgreSQL-administration

PostgreSQL

Python – API.search_users() in Tweepy

Twitter is a popular social network where users share messages called tweets. Twitter allows us to mine the data of any user using Twitter API… Read More

Python-Tweepy

Python

Sum of all subsequences of length K

Given an array arr[]and an integer K, the task is to find the sum of all K length subsequences from the given array. Example: Input:… Read More

Permutation and Combination

subsequence

Arrays

Combinatorial

DSA

Mathematical

Introduction to OpenStack

It is a free open standard cloud computing platform that first came into existence on July 21′ 2010. It was a joint project of Rackspace… Read More

Cloud-Computing

Misc

Minimum Group Flips to Make Binary Array Elements Same

The problem statement asks us to find the minimum number of group flips required to convert a given binary array into an array that either… Read More

array-traversal-question

binary-string

Arrays

Bit Magic

DSA

Find distance between two nodes in the given Binary tree for Q queries

Given a binary tree having N nodes and weight of N-1 edges. The distance between two nodes is the sum of the weight of edges… Read More

Binary Tree

LCA

LCA.array-range-queries

Competitive Programming

DSA

Dynamic Programming

Recursion

Tree

Real time optimized KMP Algorithm for Pattern Searching

In the article, we have already discussed the KMP algorithm for pattern searching. In this article, a real-time optimized KMP algorithm is discussed. From the… Read More

Algorithms

Data Structures

DSA

Pattern Searching

Searching

Strings

Query to count odd and even parity elements in subarray after XOR with K

Given an array arr[] consisting of N elements and Q queries represented by L, R, and K. The task is to print the count of… Read More

array-range-queries

Bitwise-XOR

subarray

Algorithms

Arrays

Bit Magic

Competitive Programming

DSA

Permutation of given string that maximizes count of Palindromic substrings

Given a string S, the task is to find the permutation of the string such that palindromic substrings in the string are maximum.Note: There can… Read More

cpp-strings

palindrome

permutation

substring

DSA

Sorting

Strings

Minimum circular rotations to obtain a given numeric string by avoiding a set of given strings

Given a numeric string target of length N and a set of numeric strings blocked, each of length N, the task is to find the… Read More

BFS

rotation

C++

C++ Programs

Competitive Programming

DSA

Mathematical

Queue

Strings

Probability of getting all possible values on throwing N dices

Given an integer N denoting the number of dices, the task is to find the probability of every possible value that can be obtained by… Read More

Probability

Arrays

Combinatorial

DSA

Dynamic Programming

Mathematical

Count of the non-prime divisors of a given number

Given a number N, the task is to find the count of non-prime divisors of the given number N. Examples: Input: N = 8 Output: 3 Explanation: Divisors… Read More

divisors

Prime Number

Articles

C++

C++ Programs

Competitive Programming

DSA

Mathematical

Check if there exists a permutation of given string which doesn’t contain any monotonous substring

Given a string S of lowercase English alphabets, the task is to check if there exists an arrangement of string S such that it doesn’t… Read More

permutation

substring

DSA

School Programming

Strings

Priority queue of pairs in C++ with ordering by first and second element

Priority Queue: Priority queue is the extension of the queue in which elements associated with priority and elements having higher priority is popped first. Priority… Read More

cpp-pair

cpp-priority-queue

STL

Articles

C++

DSA

Queue

Sorting

An Introduction to Software Development Design Principles

This introductory article talks about the things a software developer must keep in mind while developing any software. It also talks about what are some… Read More

Software Development

Write From Home

Count of integers up to N which represent a Binary number

Given an integer N, the task is to count every number i from 1 to N (both inclusive) such that i is a binary representation… Read More

binary-representation

maths-power

Bit Magic

Combinatorial

DSA

Mathematical

What is Edge Computing and Its Importance in the Future?

I’m sure you all use voice assistants like Alexa, Siri, etc. Suppose you ask Alexa what is the weather today? Alexa will handle your request… Read More

GBlog

Remove all even parity nodes from a Doubly and Circular Singly Linked List

Given a Doubly linked list and Circular singly linked list containing N nodes, the task is to remove all the nodes from each list which… Read More

circular linked list

doubly linked list

Bit Magic

DSA

Linked List

Searching

Write From Home

Encoding and Decoding Base64 Strings in Python

The Base64 encoding is used to convert bytes that have binary or text data into ASCII characters. Encoding prevents the data from getting corrupted when… Read More

Picked

python-string

Python