Let’s get familiar with PostgreSQL and its features

Reading Time: 3 minutes

We are living in the 20th century the century of technologies. Because of this, we come across a lot of data in our daily life. So it is important for us to have a database that can help in maintaining a huge amount of data. But the question is which one can satisfy our needs. Now, this blog is for you if you want to learn about one of the most popular database systems that are PostgreSQL.

What is PostgreSQL ?

Postgre SQL is one of the most powerful database management systems we have. It is an open-source relational database system that has been used for more than two decades. It is highly stable and very low effort is required to maintain this DBMS. One of the best features about it is that it can support both JSON (non-relational) and SQL (relational) querying. PostgreSQL has a rich history for support of advanced data types as a result it is one of the popular databases in the industry. It supports a level of performance optimization that is common across its commercial database counterparts, like Oracle and SQL Server.

System Architecture of Postgre SQL :

PostgreSQL follows the Client-server model of architecture. A Postgre session consists of the following process.

Server-side process: This application manages connections, operations, and static & dynamic assets.
Client-side process: This is the application that users use to interact with the database.

If you want to know more about the System Architecture of Postgre SQL then visit: www.geeksforgeeks.org/postgresql-system-architecture/

Language Supported by Postgre SQL :

PostgreSQL can support almost every popular programming language like Java, Scala, Python, both C and C++, Go, Ruby, C#, Perl, Rub, and many more.

Features of PostgreSQL :

Following are some important features of Postgre SQL :

  • It is ORDBMS (Object Oriented Relational Database Management System)
  • Foreign key referential integrity
  • User-defined types
  • Table inheritance
  • Views, rules, subquery
  • Multi-version concurrency control (MVCC)
  • Sophisticated locking mechanism
  • Asynchronous replication
  • Streaming Replication (as of 9.0)
  • Nested transactions (savepoints)

Difference between RDBMS and ORDBMS :

RDBMSORDBMS
RDBMS is based on the Relational model of data.ORDBMS is based on the Relational as well as Object-Oriented database model.
RDBMS has poor support for Object-Oriented programming.It supports the features of object-oriented programming.
It follows a table structure, it is simple to use
and easy to understand.
It is the same as RDBMS but in addition, has some extra confusing extensions because of the Object-Oriented concepts.
RDBMS supports Structured Query Language (SQL).ORDBMS supports Object Query Language (QOL).
It is capable of handling only simple data.It is capable of handling complex data.
RDMS is used for traditional applications
tasks such as data administration and data processing.
ORDMS is used for applications with complex objects
Example – MySQL, SQLiteExample – Postgre SQL

Conclusion :

So, this blog will help us in getting a basic idea of PostgreSQL and its feature. We now know about Postgre SQL its architecture, and also about the language which supports Postgre SQL. We get an idea of the object-relational database management system and why it is different from the relational database management systems.

Written by 

Divyansh Devrani is a Software Consultant having 1 year of experience in the Scala Ecosystem. He has worked on technologies like Scala, Akka, Play, and Postgre. He is recognized as a good team player who wants to interact with new technologies. He loves to learn new things and wants to share his knowledge with everyone.