What is MariaDB

MariaDB Logo

In this MariaDB Tutorial, we will learn about MariaDB. Additionally, we will cover the following topics What is MariaDB History of MariaDB Features of MariaDB MariaDB Vs MySQL Why use MariaDB over MySQL Companies using MariaDB What is MariaDB MariaDB is a relational database management system (DBMS) that is an open-source alternative to the commonly …

Read more

SocketException: Address already in use MongoDB

socketexception-address already in use

In this MongoDB tutorial, I will explain how I managed to resolve the error “Failed to set up listener: socketexception: address already in use MongoDB”. Socketexception: address already in use MongoDB When I run the command mongod in my terminal I get the following error message: From the error, It is clear that the address or …

Read more

MongoDB get collection size

MongoDB get collection size

In this MongoDB tutorial, we will understand how to get collection size in MongoDB. Furthermore, We will cover the following list of topics: MongoDB get collection size MongoDB get collection size example MongoDB get size of a document from collection MongoDB get collection size in GB MongoDB get collection size in Ubuntu MongoDB get collection size using …

Read more

Postgresql now() function

Postgresql now set()

In this PostgreSQL tutorial, we will study the use of Postgresql now() that will allow us to create functions. And we are going to discuss the following list of topics. Postgresql now() Postgresql now() +30 days Postgresql now() -interval Postgresql now() utc Postgresql now() vs current_timestamp Postgresql now() – 1 day Postgresql now() format Postgresql now() …

Read more

Postgresql Average + Examples

Postgresql average

In this PostgreSQL tutorial, we are going to cover the “Postgresql average” and cover the following topics. Postgresql average Postgresql average count Postgresql average group by Postgresql average multiple columns Postgresql average precision Postgresql average query time Postgresql average date Postgresql average row size Postgresql average There is an AVG() function in Postgresql to calculate the …

Read more

Postgresql unique constraint

Postgresql unique constraint

In this PostgreSQL tutorial, we will learn about “Postgresql unique” and cover the following topics. Postgresql unique constraint Postgresql unique constraint multiple columns Postgresql unique select Postgresql unique index Postgresql unique constraint name Postgresql unique constraint multiple columns null Postgresql unique constraint null postgresql unique two columns Postgresql unique constraint In Postgresql, we want to ensure …

Read more

Postgresql replace + Examples

Postgresql replace special characters

In this PostgreSQL tutorial, we will learn about the “Postgresql replace() function” to replace the string or character of columns or rows. The following topics will be covered in this tutorial. Postgresql replace Postgresql replace null with empty string Postgresql replace null with 0 Postgresql replace first occurrence Postgresql replace multiple characters Postgresql replace first character …

Read more

$in MongoDB Example

$in MongoDB

In this MongoDB tutorial, we will discuss the $in operator MongoDB. Additionally, we will also discuss the various examples where we will use the $in operator in MongoDB. $in MongoDB The $in operator in MongoDB is used to select the documents where the value of a field is equal to any value in the specified array. Syntax: …

Read more

PostgreSQL Subquery with Examples

PostgreSQL Subquery

In this PostgreSQL tutorial, we will study the usage of the PostgreSQL subquery that will allow us to create queries within the query. And we are going to discuss the following list of topics. PostgreSQL subquery PostgreSQL subquery in select PostgreSQL subquery return multiple columns PostgreSQL subquery as column PostgreSQL subquery alias PostgreSQL subquery vs …

Read more

PostgreSQL Update Join + Examples

Postgresql update self join after updation

In this PostgreSQL tutorial, we are going to learn about Postgresql update join. Here we will learn how to update join in PostgreSQL, and we will also cover the following list of topics. Postgresql update join Postgresql update join subquery Postgresql update join with alias Postgresql update join group by Postgresql update join same table Postgresql …

Read more