PostgreSQL: Contrib Modules

Contrib Modules: In PostgreSQL, “contrib” stands for “contributed modules”. These are additional functionalities and features developed by the community that are not part of the core PostgreSQL distribution, but can be easily added to enhance the capabilities of the database. Contributed modules are distributed separately… Read More

Roles In MongoDB Part – 2

Roles In MongoDB Part – 2 User-Defined roles: MongoDB provides many built-in roles to manage the access to the database.but when the built-in roles did not meet your requirement privileges then you can go for creating your own roles. Creation of user-Defined role: To create… Read More

Logging mechanism in PostgreSQL

Logging mechanism in PostgreSQL: Logging is the process of recording events, actions, and error messages in a systematic manner for future analysis and reference. In PostgreSQL, the logging mechanism helps track various activities like SQL statements executed, connection attempts, query performance, and errors encountered during… Read More

Roles in MongoDB

Roles in MongoDB MongoDB uses Role Based Access Control (RABC) to provide access to any MongoDB system. MongoDB supports multiple authentication methods like x.509 Certificate Kerberos Authentication and may like these authentication methods and the access to the database granted through the role-based authorization. There… Read More

Replication In MongoDB

Replication In MongoDB ♦ Replication is the process of creating and maintaining the multiple copies of data across the different servers and also ensuring the copy of the data remains consistent and updated. ♦ Replica set is one of the ways of implementing the replication… Read More

Databases In MongoDB

Databases In MongoDB In MongoDB the databases are divided in to two types based on the data they store they are. 1. Default databases 2. Non default databases Non default databases: The databases that are created explicitly depend on the needs of the users. Default… Read More

Remote Connections in PostgreSQL

Remote Connections in PostgreSQL: Remote connections will allow you to connect to a PostgreSQL server from a different machine or network. In this article, we will explore the steps to establish remote connections in PostgreSQL and provide best practices for securing these connections. This article… Read More