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 58

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.
Ralph S.
RS
Position Seeker
Information Technology and Services
Small-Business (50 or fewer emp.)
"Postgresql for the enterprise and to learn with"
What do you like best about PostgreSQL?

Elegance, intuitive feel. Great manual. Endless improvements. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

hard to keep up with all the enhancements! Review collected by and hosted on G2.com.

Dan J.
DJ
GIS Officer
Non-Profit Organization Management
Enterprise (> 1000 emp.)
"powerful open-source database option"
What do you like best about PostgreSQL?

PostgreSQL is well-documented, powerful, mature, and has a huge user base. Easy to find examples and forum postings when troubleshooting just about any scenario: the odd error message, problems using pgAdmin, figuring out how to integrate PostgreSQL into your node.js application. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For some use-cases, PostgreSQL isn't the best option. It's worth considering your needs and looking at SQLite, MongoDB, and others. Review collected by and hosted on G2.com.

Ian H.
IH
Programmer
Computer Software
Enterprise (> 1000 emp.)
"PostgreSQL is the best database system I've used"
What do you like best about PostgreSQL?

Coming from a MySQL background, I love the variety of data types in Postgres: JSON, arrays, etc, all fill a need that MySQL didn't. I especially like how easy it is to manipulate dates, something that has sped up development a ton in terms of automated testing. The ability to enforce checks on insertion is very helpful, too. I've used NoSQL before, and I much prefer the rigidity of an RDBMS. All too often I've had to deal with corrupt data because of the temptation to fool around directly in the database rather than using the application layer. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Probably the most difficult thing about Postgres is its permissions model. It's not very intuitive, in my opinion, and I think those issues need to be resolved before it can gain the sort of traction MySQL has. Right now it's just not easy for a beginner to get set up and secure. Review collected by and hosted on G2.com.

Verified User in Legal Services
AL
Small-Business (50 or fewer emp.)
"Great experience with PostGres"
What do you like best about PostgreSQL?

love the aggregate functions, also JSONB support, as well as views and materizlized views maintenance. very stable and secure. It is easy for me to maintain as an analyst Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

certain data types are not good. i find the admin tools to not be amazing either Review collected by and hosted on G2.com.

Hakim B.
HB
PhD Student
Higher Education
Enterprise (> 1000 emp.)
"A review of PostgreSQL"
What do you like best about PostgreSQL?

PostgreSQL seems to scale well compared to MySQL, which means that it's more capable than the latter to withstand a larger database and an increasing number of transactions and connections. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The learning curve seems a bit steep compared to MySQL. And therefore, a beginner might struggle to get started with it. Pgadmin is also not as intuitive as PhpMyAdmin for example and takes a bit of time to get used to. Review collected by and hosted on G2.com.

Verified User in Aviation & Aerospace
UA
Enterprise (> 1000 emp.)
"Works just fine"
What do you like best about PostgreSQL?

For the basic level of DB functionality that I need, I honestly see no difference between this or other similar software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, it works just fine for my needs. Review collected by and hosted on G2.com.

McCourt C.
MC
Systems Development Manager
Small-Business (50 or fewer emp.)
"A great Alternative to MS Sql"
What do you like best about PostgreSQL?

Postgresql is a very lightweight cross platform solution.

This makes it a perfect alternative to some of the larger commercial solutions out there right now.

The community behind it is also first class, loads of support is available via the forums when needed.

My favorite feature however is replication.

Although you will be editing text based config files to get set up, you can literally have one database replicating to another in half an hour(for basic configs).

I know this is possible with other commercial tools, but Postgres is free to use.

I use it for all of my personal projects when possible.

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its a little tricky to configure for those who are used to graphical interfaces like in MS SQL server. Review collected by and hosted on G2.com.

Anson A.
AA
Data Czar
Mid-Market (51-1000 emp.)
"Postgres"
What do you like best about PostgreSQL?

open source, large community, some nice functions that get updated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

parallel queries not available yet.

not as frequent w/ patches or new function releases Review collected by and hosted on G2.com.

Rob M.
RM
Director of Software Development
Health, Wellness and Fitness
Small-Business (50 or fewer emp.)
"Postgresql - the default database for new RoR projects"
What do you like best about PostgreSQL?

Solid SQL database, all standard SQL syntax supported with many nice extensions.

Stable

Excellent documentation and good develop support community

Full internationalization support

Good performance

Support for advanced SQL features, like "WITH" clauses and POSIX regular expressions

Built-in full text search (tsearch)

Support for distributed databases - master/slave replication

Lots of native "C" extensions

Right price - open source

Runs on Windows, OSX, and Unix

Installs on OSX using HomeBrew. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PgAdmin tends to crash, losing your query, when you resize the query window. That's been true for over 5 years now. I wish they'd fix that. It might have flaws as larger scales that I use it at, but I haven't seen any yet. Review collected by and hosted on G2.com.

chedi t.
CT
Consultant
Computer Software
Small-Business (50 or fewer emp.)
"postgresql review"
What do you like best about PostgreSQL?

I've worked with many relationnal databases over the years and mysql was my goto solution for web development for a while. Until I was forced to use postgis extension of postgresql for a geospatial data storage project. Since then, postgresql became my defacto databse.

Very reliable, great performance and advanced features make postgresql a solution for midium to large deployment. Advanced data types, especially spatial in my case, rich feature sets and the possibility to write stored procedures in python are a deal sealer.

It's also opensource, with a good support and a welcoming community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing really, but there is some known gotcha and behaviors that can be confusing for new users. Reading the documentation is a must even if you have a background with other RDBMS.

Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime. 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