DEV Community

Hrishikesh Mallick
Hrishikesh Mallick

Posted on

PostgreSQL special features

Point-in-time recovery

PostgreSQL enables developers to use PITR (Point-In-Time Recovery) to restore databases to a specific moment in time when running data recovery initiatives. Because PostgreSQL maintains a write ahead log (WAL) at all times, it logs every database change. This makes it easy to restore file systems back to a stable starting point.

Third-party tools like pgBackRest (link resides outside ibm.com) make this easier to do and more reliable; most cloud-managed PostgreSQL services will handle this for you automatically.

Stored procedures

PostgreSQL features built-in support for multiple procedural languages, giving developers the ability to create custom subroutines called stored procedures. These procedures can be created and called on a given database. With the use of extensions, procedural languages can also be used for development in many other programming languages, including Perl, Python, JavaScript, and Ruby.

Deep language support

PostgreSQL is one of the most flexible databases for developers due to its compatibility and support of multiple programming languages. Popular coding languages such as Python, JavaScript, C/C++, Ruby, and others offer mature support for PostgreSQL, letting developers perform database tasks in whichever language they are proficient in without generating system conflicts.

Table Inheritance

PostgreSQL has table inheritance feature. This concept is from object-oriented databases. In PostgresSQL a table can inherit from one or more other tables. Child table inherits column(s) along with all check constraints and not null constraints from one or more parent tables. Some constraints (unique, primary key, and foreign key) are not inherited from parent table to child table (Official docs).

Want to extract all the benefits of PostgreSQL along with Graph Database features look at:
Apache AGE
Apache AGE Github

Top comments (0)