Introducing G2.ai, the future of software buying.Try now
Product Avatar Image

PostgreSQL

Show rating breakdown
638 reviews
  • 1 profiles
  • 1 categories
Average star rating
4.4
Serving customers since

All Products & Services

Profile Filters

Profile Name

Star Rating

425
178
33
1
1

PostgreSQL Reviews

Review Filters
Profile Name
Star Rating
425
178
33
1
1
Jainesh K.
JK
Jainesh K.
Lead Software Engineer
08/31/2023
Validated Reviewer
Review source: G2 invite
Incentivized Review

An opensource and reliable DB with essential functionalities

- It's open-source which means without paying a penny we can leverage a variety of database features with regular improvements and bug fixes provided by community members. - It's a scalable database that can be used for a variety of applications. -Its JSONB support makes It easier to work with JSON types and we can work on relational as well as non-relational data on the same system. - Full text search feature is also provided by PostgreSQL which can help in a variety of applications.
Alexandre G.
AG
Alexandre G.
Analytics Engineer | Data Analyst | Azure Analyst | Business Intelligence
08/29/2023
Validated Reviewer
Verified Current User
Review source: Organic Review from User Profile
Translated Using AI

PostgreSQL: A Balanced Assessment of Its Strengths and Challenges

PostgreSQL is recognized as one of the most advanced and robust open-source relational database management systems available. Strengths: Open Source: Being under an open-source license allows the community to actively contribute to its development, which accelerates the introduction of new features and fixes. SQL Compliance: PostgreSQL offers a high degree of compliance with the ANSI SQL standard, which facilitates migration from other database management systems. Extensibility: PostgreSQL supports the definition of custom types, functions, and operators. This allows developers to expand its capabilities according to specific needs. Advanced Features: It offers advanced features such as the ability to store JSON data, support for full-text search, partitions, triggers, materialized views, and geospatial extensions (PostGIS). Security: It offers a variety of security mechanisms, including authentication, role-based access control, and encryption of data at rest and in transit.
Verified User in Computer Software
UC
Verified User in Computer Software
08/28/2023
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review

Postgres - Open source RDBMS solution

The PostgreSQL relational database is a open source database system - which is free to use, easily configurable and carry overs all the basic SQL principles and Syntax.

About

Contact

HQ Location:
United States

Social

@postgresql

What is PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL: 008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation. An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Details