Database

Wednesday, 23 February 2022 15:30

8 Most Important features of PostgreSQL

Written by 
Rate this item
(0 votes)

PostgreSQL is one of the most widely used relational database management systems today. It is object oriented, it is multisystem, so you can use it on any operating system and under a free license.

It has been developed since 1996 by a community of developers (not a company or foundation) based on DBMS POSGRES, which emerged (like many other technologies) from a US military research project (DARPA, ARO) with civilian participation.

Characteristics
For this reason, we are going to list the most important features of PostgreSQL for you:

  1. The SQL language it uses is very close to the ISO/IEC standard, making it relatively easy to port queries and scripts from other database systems, and thus easily learn the variants of this language.
  2. It complies with ACID, that is, it provides atomicity, consistency, isolation and durability for its operations.
  3. It allows you to create schemas, inherited tables and event-oriented triggers that other engines do not have.
  4. It allows you to define procedures, not only in PostgreSQL, but also in many other languages ​​such as Pearl, TCL or Python. Even if the language we want to use is not supported, we can define it with new extensions.
  5. If we need some type of data that is not supported as standard, we can also define them.
  6. We can extend the functionality with extensions, provided by PostgreSQL itself, by third parties or even programming on our own.
  7. It has native master-slave replication support, but it is also possible to add other types through free or paid third-party products.
  8. It also provides excellent vertical scalability.
Read 15223 times Last modified on Wednesday, 23 February 2022 15:32