PostgreSQL Reviews & Product Details - Page 46

admin

PostgreSQL Overview

edit

What is PostgreSQL?

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

PostgreSQL Details

Discussions

PostgreSQL Community

Show LessShow More

Product Description

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

Seller

PostgreSQL

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:

Avi Ashkenazi

CTO at Coronys LTD.

PostgreSQL Integrations

(3)

Integration information sourced from real user reviews.

PostgreSQL Media

PostgreSQL

G2 reviews are authentic and verified.

Here's how.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

5/1/2018

"Best DB for Open Relational DB"

4/5

What do you like best about PostgreSQL?

I loved the Common table Extensions (CTE). This is one of the excellent feature you see in PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I really don't see anything dislike. Moreover i am loving its features Review collected by and hosted on G2.com.

Curtis M.

Senior Test Automation Engineer

Small-Business (50 or fewer emp.)

10/27/2017

"Simple to use, Easy SQL management tool."

5/5

What do you like best about PostgreSQL?

Coming from a MySQL background it is very similar and allows me to manage my data in any way I see fit. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The PostgreSQL management tools out there today aren't the best. It's hard to find a GUI tool that allows me to manage my data simply. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you are used to MySQL and are unable to use that for your database management needs, PostgreSQL is a great alternative. With all the other tools that are being offered right now, AWS and GAE, this is still light weight and open source. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I have a lot of data that I need to keep historical track of and PostgreSQL keeps that all in one place that allows me to keep track of it. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

1/22/2018

"We use PostgreSQL for enhancing our functionality pertaining to Data storage as compared to RDBMS. "

3.5/5

What do you like best about PostgreSQL?

The best feature about PostgreSQL is that it is open source software with easily available user defined types and concurrency control. Also the newly added features of tablespaces in recent versions has made it very much comparable to other popular RDBMS available in the market thus making this a good option for replacing traditional RDBMS at a low cost. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I dislike the fact that PostgreSQL is not very much user friendly and finding documentation on postgreSQL is bit tedious making it difficult for supporting daily operations of business. Review collected by and hosted on G2.com.

Alex S.

Trans. Engineer 2: Survey Party Chief

Government Administration

Small-Business (50 or fewer emp.)

6/1/2017

"Excellent (and FREE!) Enterprise-Level DB."

4.5/5

What do you like best about PostgreSQL?

Several items: 1) it's FREE; 2) the ability to program functions and triggers in a variety of languages; 3) it is ACID-compliant which is extremely important to me. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Although it will run on Windows machines, it does seem (to me) that PostgreSQL is much more at home on a *nix computer. I had some strange access/permissions issues with some Windows directories/files whereas on Linux it was a non-issue. Your mileage may vary. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It is FREE! Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

The NPO that I am assisting currently uses MS Access and has been doing so since circa 1992, with a very large number of data entry additions which were prone to error. Furthermore, their membership has grown from approximately 300 folks in 1992 to about 4,000 in 2017. This has made their existing setup a nightmare. I volunteered to normalize their data and streamline their data entry procedures with feedback from their current data manager with respect to possible refinements on the data entry forms. Essentially, we are implementing PostgreSQL as a back-end and because of the wide variety of tools available and its versatility, it should provide a large degree of DB future-proofing for the NPO. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

4/22/2018

"Great open source database"

4.5/5

What do you like best about PostgreSQL?

Extremely reliable, allows large amounts of data to be stored and accessed. Also very good documentation, great AWS RDS support. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Performance management tools are lacking. The database engine is quite opaque when performance issues occur. It is quite hard to diagnose issues like 100% CPU or why some SQL plan is selected rather than some seemingly faster ones. Review collected by and hosted on G2.com.

Verified User in Consumer Electronics

Small-Business (50 or fewer emp.)

4/19/2018

"Robust and Versatile"

5/5

What do you like best about PostgreSQL?

Very accurate system. It works more than well in most scenarios. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The installation process is not the most straightforward ever. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness

Enterprise (> 1000 emp.)

7/9/2018

"Good for medium application"

2.5/5

What do you like best about PostgreSQL?

Open source and free to use is one of the thing Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

No good UI and ancillary tools is available in the postgres world Review collected by and hosted on G2.com.

Dustin F.

Analyst, Insurance Analytics - Marketing and Fraud

Information Technology and Services

Enterprise (> 1000 emp.)

1/30/2018

"Regular SQL with some nifty documentation"

4/5

What do you like best about PostgreSQL?

Whenever I had any questions, the well organized documentation allowed me to find answers quickly. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

With so many versions of SQL, it is unavoidable to have some syntax differences. Not bab, but always takes some getting used to when switching. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

10/25/2017

"Great opensource relational database"

5/5

What do you like best about PostgreSQL?

As of yet, I haven't had any issues with Postgresql. I honestly don't think I've utilized it to its full potential. Some of the features that I've found very helpful are its upsert, or insert on conflict feature as well as the ability to have multiple schemas in order to support a multi tenant data model without having to use multiple databases. It is also quite easy to backup and restore, as well as create followers for high read capacity as well as automatic fallover. Also, we use Ruby on Rails coupled with Heroku for deployment, and Heroku has a great managed PostgreSQL service that makes utilizing all of its features really easy and painless. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I do wish there was a free tool similar to SQLPro for Postgresql on Mac. There are some paid tools. But I'm fairly cheap. The default management application PGAdmin is very featureful, but the UX isn't amazing, particularly for simple things. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

It works really well for us using Ruby on Rails and deploying to Heroku utilized Heroku Postgres. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We use PostgreSQL for almost all our relational database needs, typically for backend data storage for web and mobile applications. It has been fantastic and works great coupled with Ruby on Rails applications. Review collected by and hosted on G2.com.

Juan Carlos G.

Software Engineer

Information Technology and Services

Mid-Market (51-1000 emp.)

12/21/2017

"An alternative to traditional RDBM"

3/5

What do you like best about PostgreSQL?

It has a great performance, specially to handle big volumes of data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its query language is not the standard SQL, so a learning curve is necessary. Fewer tools that interact with it, and also less documentation is a concern. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Don't be afraid of the learning curve, it's a good first step to later enter the world of NoSQL databases. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

It was used as a demonstration of non traditional databases, it handled everything we throw at it. It has better support for json types. Review collected by and hosted on G2.com.