PostgreSQL Reviews & Product Details - Page 38

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.

John R.

Co-founder, lead developer

Small-Business (50 or fewer emp.)

1/2/2018

"By far the most powerful and advanced open source database software"

4.5/5

What do you like best about PostgreSQL?

The developer community behind Postgres is phenomenal. Not only do they keep the software active, they give their time speaking and teaching about the software. The speed and reliability of the software is also great. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres number one priority is data reliability, then speed, which causes some features like COUNT() to be slower than I'd like. While this is ideal 99% of the time, there is that 1% when I wish there was an option to configure the software to make COUNTs faster, even if it meant less reliability for that qeury's result. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Setup and configuration are not easy, but it's mostly system administrators and DBAs using it so that is to be expected. Admin tools, such as pg_basebackup, have improved. Review collected by and hosted on G2.com.

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

Postgres powers our web based software, Intervals. It's been the best choice we could have possibly made for over 11 years since we first adopted it. We have benefited most from the speed improvements and replication features. Review collected by and hosted on G2.com.

Juan M.

Project Manager

Information Technology and Services

Small-Business (50 or fewer emp.)

9/7/2018

"Relational database for professionals"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is the best open source relational database system. It is the most complete and it gives you the best performance and functionality. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It is a bit complex at the beggining. There are a lot of options even in the query interface PgAdmin. You need a lot of database background to take it for Bussiness. Review collected by and hosted on G2.com.

Jose Antonio G.

Mid-Market (51-1000 emp.)

9/3/2018

"Easy database manager"

4/5

What do you like best about PostgreSQL?

Open source and free to use.

PostgreSQL allows you to make backups and exports of your databases very easily, what is very important if you wan t to keep your work safe. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

When working with huge databases, PostgreSQL can be slow and sometimes it seems to be crashed, even though it's working. Review collected by and hosted on G2.com.

Verified User in Military

Mid-Market (51-1000 emp.)

1/4/2019

"Great Product, especially for small projects"

3.5/5

What do you like best about PostgreSQL?

Easy to spin up a simple database, free to start, open source community Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much, but the wrappers for Postgres can be somewhat complicated. Review collected by and hosted on G2.com.

Daniel R.

Software Engineer Intern

Computer Software

Enterprise (> 1000 emp.)

7/30/2018

"PostgreSQL used with Ruby on Rails"

5/5

What do you like best about PostgreSQL?

It packs all the features you need in a simple to use interface. It has several GUI tools and you can install it either in windows or UNIX OS. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

So far there is nothing I dislike. I haven't come up with any problems so far. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I really recommend PostgreSQL, I think is the best relational database out there and it packs the most modern technology too. Review collected by and hosted on G2.com.

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

It's free and we find it really useful even when storing information in JSON columns. Review collected by and hosted on G2.com.

Ashish G.

Software Engineer

Information Technology and Services

Enterprise (> 1000 emp.)

12/26/2017

"Open source object-relational database management system for Web Developers"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL or simply Postgres implements the SQL standard very well. Postgres provides a easy to understand tool called pgAdmin to interact and manipulate database. It provides support for complex data types like Array and Json. It can handle workloads ranging from small web applications to large data warehousing with many concurrent users. It is available till 10,000 rows on Heroku. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL query syntax for some complex queries like array,string functions and case operator are is not easy to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as MySQL and it is bit harder to google search results. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

I recommend PostgreSQL to all web application who are looking for cost effective database. It supports almost all types of backend server like, Java, Ruby, Python etc. Postgre SQL provides high level of parallel queries. It support very useful types like array and JSON. Review collected by and hosted on G2.com.

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

From last one year we moved from MySQL to Postgres for database needs reason being of its support for multiple concurrent connections in affordable price. We are now using Postgres database for our new projects. I got benefit using PostgreSQL in term of price, speed, support of complex type and easy to learn query syntax. Review collected by and hosted on G2.com.

Verified User in Government Administration

Enterprise (> 1000 emp.)

11/13/2018

"PostgreSQL MPP database review"

4/5

What do you like best about PostgreSQL?

Performance. This is the promise of a MPP and PostGreSQL lives up to its promise. Also frequent releases adds more and more features. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not much. A little more UI tools would be useful. Also the provision to support more external tables will definitely help. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/27/2019

"Review for Postgre"

5/5

What do you like best about PostgreSQL?

The interface and usability is very good Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is nothing that i don't like about this now Review collected by and hosted on G2.com.

Dorian Patricia T.

Coordinador de Monitoreo y Control

Telecommunications

Enterprise (> 1000 emp.)

7/30/2018

"Speed and open source"

4.5/5

What do you like best about PostgreSQL?

The first of its attractions is the speed with which it works, the larger the database at speed and the performance does not decrease, apart from the fact that it can be installed on the computer that does not have to pay for it. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Many of its instructions are complicated and not supported as should be the case for any database manager. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Small-Business (50 or fewer emp.)

7/31/2018

"Decent Open Source Database Platform"

4/5

What do you like best about PostgreSQL?

As with all things open source, you can't get much better than free. PostgreSql does the job, and does it well. New features are being developed all the time, so you won't be too far behind the SQL standard if you went to this product. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

If you are expecting top of the line software here, like Microsoft SQL Server or Oracle, you will be wrong. Microsoft spends millions of dollars in R&D to move their SQL Server product forward. You won't be getting that level of tech WOW in PostgreSQL. So you will end up having to follow traditional design patterns to accomplish what you are looking for. Review collected by and hosted on G2.com.