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 43

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.
Samuel C.
SC
Originations Specialist
Financial Services
Mid-Market (51-1000 emp.)
"Essential Tool"
What do you like best about PostgreSQL?

Easy to learn; Widely used in our company Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Little keyboard shortcuts available; browser program does not have ability to save macro Review collected by and hosted on G2.com.

Verified User in Computer Software
CC
Mid-Market (51-1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Pros and cons of PostgreSQL"
What do you like best about PostgreSQL?

The first thing to highlight is that it is open source, therefore it has no licensing costs. It is undoubtedly the best free option. Its GIS extensions are also worth mentioning. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its performance in handling large volumes leaves much to be desired, and the administrative tools are not as powerful as we would like. Review collected by and hosted on G2.com.

Eduardo H.
EH
Ingeniero informático
Consumer Goods
Small-Business (50 or fewer emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"Great"
What do you like best about PostgreSQL?

Excellente software to manage databases. Is oriented to obejects and the best of all is that is free. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Don't have a official support from the depeloper of the software. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
CI
Enterprise (> 1000 emp.)
"A very versatile database"
What do you like best about PostgreSQL?

Has various extensions and a very wide dev base.

supports foreign data wrappers. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Could support more efficient caching and in-memory Review collected by and hosted on G2.com.

Ramon B.
RB
Senior Software Engineer, R&D
Broadcast Media
Enterprise (> 1000 emp.)
"Use as PostgreSQL not as MySQL; get to know it the philosophy behind it first!"
What do you like best about PostgreSQL?

Awesome built in data types, JSON with indexing to then work with triggers and locks!

Best of both NoSQL and SQL. The community is very active, as well as several commercial enterprise offerings. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I found there to be a steep initial learning curve to be able to build an application effectively to use all the built-in magic if the development team come from using MySQL or MSSQL. Once the brain wraps around some of the over loaded terminology Review collected by and hosted on G2.com.

Thanh P.
TP
Software Engineer
Information Technology and Services
Small-Business (50 or fewer emp.)
"Object-relational database management system, free and open source"
What do you like best about PostgreSQL?

A simple database server: store and query data

Multiversion concurrency control (MVCC) per "transaction"

Support JSON data type from version 9.2

Developer can define their objects, inherit from default system defined.

Has full text search and asynchronous notifications Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Performance and slow on older version. Need update at least 9.4 for better performance Review collected by and hosted on G2.com.

PG
Mid-Market (51-1000 emp.)
"One of the best services"
What do you like best about PostgreSQL?

Efficiency, power, easy of use and environment. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The environment may be a bit powerful and with more functions. Review collected by and hosted on G2.com.

Verified User in Civil Engineering
AC
Small-Business (50 or fewer emp.)
"Great DB, lots of community support"
What do you like best about PostgreSQL?

It's very easy to setup with cloud hosting providers like Heroku and GCP Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

command line tools for mac are unintuitive Review collected by and hosted on G2.com.

Eric M.
EM
Principal Software Engineer
Computer Software
Small-Business (50 or fewer emp.)
"Scalable, flexible databases for any use"
What do you like best about PostgreSQL?

Data of almost any format fits well in Postgres. You can use one database instance to house multiple databases, but also host multiple discrete schemas in each database (each with its own set of tables). The scope with which you can shape and manage data structures is remarkable! Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Some key features from other database systems (like UUIDs for identifiers) are not included by default and require installing separate extensions (pgcrypto for UUIDs). Forgetting to install an extension before importing data can lead to data loss and errors all over the place! Review collected by and hosted on G2.com.

Verified User in Food & Beverages
CF
Enterprise (> 1000 emp.)
Business partner of the seller or seller's competitor, not included in G2 scores.
"PostGresql for database"
What do you like best about PostgreSQL?

The abilty to quickly frame the ddl and form the databases and various tables Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing that I dislike about PostGreSql 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