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 37

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.
Verified User in Information Technology and Services
UI
Enterprise (> 1000 emp.)
"Really easy to use"
What do you like best about PostgreSQL?

Very user friendly, can easily query large datasets in an efficient manner Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Reading a file as input is cumbersome and not intuitive. Review collected by and hosted on G2.com.

Verified User in Financial Services
IF
Enterprise (> 1000 emp.)
"Efficient query language"
What do you like best about PostgreSQL?

Simple syntax and usefull for large volumes of data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Query behaves sometimes very strangely which i dont like Review collected by and hosted on G2.com.

Mark S.
MS
Accessibility Software Developer
Information Technology and Services
Enterprise (> 1000 emp.)
"PostgreSQL best in business"
What do you like best about PostgreSQL?

Postgres makes tracking and sorting data easy while also being able to creat complicated data Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The dashboard for pgadmin is somewhat difficult to use Review collected by and hosted on G2.com.

Michal M.
MM
Analityk Systemowy
Information Services
Small-Business (50 or fewer emp.)
"Free and really good database not only for scientists but also for business applications"
What do you like best about PostgreSQL?

This is free

big community

a lot of extensions

the ability to use Python

it just works Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Limiting the number of columns in the table. However, other databases have similar limitations.

Older versions had very nice tools, in particular the SQL client. In newer versions, it has been replaced by a nicer graphical solution that is slow and sometimes slightly annoying. Review collected by and hosted on G2.com.

JG
Mid-Market (51-1000 emp.)
"Robust and powerful database"
What do you like best about PostgreSQL?

What I like most about PostgreSQL is that it maintains its speed at any database size and its license has no cost, making it a good choice for any company. Additionally, it is cross-platform. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I like least about PostgreSQL is that it is not one of the fastest on the market, although its speed is the same in any database regardless of the number of rows. The support is also one of the disadvantages. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Simple yet powerful"
What do you like best about PostgreSQL?

Simplicity and ease of use and operation. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is good for small scale data storage and analysis but may not be suitable for big data operations. Review collected by and hosted on G2.com.

Verified User in Education Management
UE
Mid-Market (51-1000 emp.)
"PostgreSQL"
What do you like best about PostgreSQL?

its a nice easy database to use with simple, easy to understand design Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

SQL is probably one of the harder languages, can make coding more tedious than needs to be Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Enterprise (> 1000 emp.)
"Most advanced and efficient open-source database "
What do you like best about PostgreSQL?

Extensible, efficient, supports SQL, Mongo and NoSQL as well. It is open-source so there is no cost involved. Online community for PostgreSQL is excellent, leading to better support. It is second to none in terms of reliability and stability. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Slower than MySQL. Installation and configuration can be difficult to grasp at first. Review collected by and hosted on G2.com.

Verified User in Civil Engineering
AC
Enterprise (> 1000 emp.)
"The best db hands down "
What do you like best about PostgreSQL?

The extensibility, stability, and spatial capability Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

GUI interface is not as well developed as the CLI and intimidates newer users Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Mid-Market (51-1000 emp.)
"Great Database to work with"
What do you like best about PostgreSQL?

Easy to setup and works well with Sequelize Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not great with performance compared to Oracle or teradata 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