Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

PostgreSQL Reviews & Product Details - Page 44

PostgreSQL Overview

What is PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL Details
Show LessShow More
Product Description
PostgreSQL is a powerful, open source object-relational database system.

Seller
Description

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.

Overview Provided by:
CTO at Coronys LTD.

PostgreSQL Integrations

(3)
Integration information sourced from real user reviews.

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Product Avatar Image

Have you used PostgreSQL before?

Answer a few questions to help the PostgreSQL community

638 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
638 PostgreSQL Reviews
4.4 out of 5
638 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Marco P.
MP
Co-founder / CTO
Small-Business (50 or fewer emp.)
"Performant, reliable and scalable"
What do you like best about PostgreSQL?

We use PostgreSQL in production since 8 years now, in a multi-nodes HA setup based on the built-in streaming replication. PostgreSQL is a great database, offering high performances and allowing to easily scale read-replicas with the built-in streaming replication. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The major issue with PostgreSQL is the complexity of doing a major version upgrade with nearly zero downtime. Starting from PostgreSQL 10 this issue has been largely reduce thanks to the logical replication. Review collected by and hosted on G2.com.

Arturo J.
AJ
Director de Tecnología
Computer Software
Small-Business (50 or fewer emp.)
"Great database for cloud software"
What do you like best about PostgreSQL?

PostgreSQL is a great database for cloud development Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Documentation is a nit tricky to understand at first Review collected by and hosted on G2.com.

Manjushri S.
MS
Java Software Developer
Information Technology and Services
Enterprise (> 1000 emp.)
"PostgreSQL database review"
What do you like best about PostgreSQL?

PostgreSQL is an open source database and in that way has a great advantage over other licensed databases like Oracle. Currently, we have been trying to migrate all legacy applications from Oracle to postGRESQL.PostgreSQL database works very well with hibernate JPA and we have been using it extensive along with the Spring framework. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no good client to use the database been using pg admin and I am not really a big fan of the interface provided by pgadmin, we cannot "pin" any query results unlike the SQL developer. Review collected by and hosted on G2.com.

Justin H.
JH
Carrier Sales / Switch Technician
Telecommunications
Small-Business (50 or fewer emp.)
"PostgreSQL usually gets the job done"
What do you like best about PostgreSQL?

Data integrity, wide variety of column types, great documentation Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Data import can be difficult, usually needs a 3rd party tool even with the simplest CSV files. Review collected by and hosted on G2.com.

Sorabh S.
SS
Head Of Development
Enterprise (> 1000 emp.)
"Best for Any medium scale sized project"
What do you like best about PostgreSQL?

ANSI Compliant SQL, Verbose logging, Replication ease, Indexing performance Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such , would recommend for further projects also. Review collected by and hosted on G2.com.

Verified User in Computer Software
AC
Small-Business (50 or fewer emp.)
"Postgres is the best"
What do you like best about PostgreSQL?

Fast secure frequently updated and plenty of drivers available. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not as popular as some other solutions so which can make it hard to debug strange errrs Review collected by and hosted on G2.com.

Verified User in Higher Education
UH
Enterprise (> 1000 emp.)
"Great Versatile DBMS software"
What do you like best about PostgreSQL?

The ability to create databases without any price requirement and allowing to run SWL commands on those databases dynamically is great Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no GUI to check the created databases and their values for a quick glance. Review collected by and hosted on G2.com.

Verified User in Higher Education
UH
Enterprise (> 1000 emp.)
"Great database system"
What do you like best about PostgreSQL?

I enjoyed the capability to use other programming languages within it to allow for easy data modifications and more. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The thing that was the hardest to get comfortable with was all the short hand notation. Most are single character, which can get confusing. Review collected by and hosted on G2.com.

Verified User in Insurance
UI
Enterprise (> 1000 emp.)
"Fantastic Database for all use cases"
What do you like best about PostgreSQL?

It's free, and I can install it on any of my VMs and make it work for me. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing in particular. There isn't enough on Stackoverflow for this product as compare to Oracle. Review collected by and hosted on G2.com.

Verified User in Telecommunications
UT
Mid-Market (51-1000 emp.)
"PostgreSQL, the best fusion between SQL and programming"
What do you like best about PostgreSQL?

The immense possibility of programming allowed by the code, allowing the generation of interfaces from SQL code. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

None, it is a very good alternative to the fusion of any programming language that works with SQL. Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
PostgreSQL