DEV Community

Cover image for Understanding PostgreSQL
patrick
patrick

Posted on

Understanding PostgreSQL

***PostgreSQL* - is a popular OPen -Source Object-Relational Database Management System.That is used to store data and allowing them to be restored when their need arises.

PostgreSQL is a cross-platform and runs on various operating systems such as _Microsoft,Windows ,UNIX,Mac OS ,linux and so on.

          **Features Of PostgreSQL**
Enter fullscreen mode Exit fullscreen mode

1.It is compatible with various languages such as JAVA,Python,Ruby,Perl, C++.

2.It is an open-source,hence easy to download from the official PostgreSQL.

3.It is compatible on several operating systems.

4.It is secure since it supports and follows several aspects of security.

          ** Advantages of PostgreSQL**
Enter fullscreen mode Exit fullscreen mode
  1. It is very easy to use
  2. It requires low maintenance
  3. PostgreSQL manages data in relational database hence its very powerful. Disadvantages of PostSQL
  4. it is not very first compared to MySQl
  5. Does not support some open-source applications compared to MySQL

Conclusion
it is now clear that you have understood what is PostgreSQL,its features, advantages and drawbacks.Happy Learning

Top comments (0)