Sign in
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

PostgreSQL

Jetware | 9.6

Reviews from AWS Marketplace

0 AWS reviews
  • 5 star
    0
  • 4 star
    0
  • 3 star
    0
  • 2 star
    0
  • 1 star
    0

External reviews

608 reviews
from G2

External reviews are not included in the AWS star rating for the product.


    Gary L.

A powerful flavor of SQL

  • March 31, 2016
  • Review verified by G2

What do you like best about the product?
PostgreSQL has some great features. In particular, window functions make challenging (in other flavors of SQL) tasks a breeze.
What do you dislike about the product?
I have found that the programs available to execute PostgreSQL (that I am aware of) are lacking compared to SQL Server.
What problems is the product solving and how is that benefiting you?
I used PostgreSQL to pull health care data from a database.
Recommendations to others considering the product:
It's solid, has a lot of features, and widely used. Also, it's open source so you can't beat the price!


    Roberto D.

Fast, reliable and scalable open source database

  • March 29, 2016
  • Review verified by G2

What do you like best about the product?
I like PostgreSQL because it's a robust alternative to commercial databases. It stands very well against other open source competitors, like the more popular MySQL. It's fast and reliable, managing inserts and updates of tens of thousands of rows flawlesly.

Besides that, it's easy to install and to manage, and it has some handy non-standard SQL commands. Documentation in the official website covers most of the common and advanced tasks with a lot of examples of querys.
What do you dislike about the product?
Managing everything from the command line can be a little bit cumbersome. There are a lot of third party graphical interfaces to access the databases from the desktop (pgAdmin) or via browser (phpPgAdmin) but you have to install them and learn to use then on your own.

The same with reporting tools, there are a lot of nice ones but you have to search and try what is the best for you.
What problems is the product solving and how is that benefiting you?
I have used PostgreSQL for ten years now on a very active client-server configuration without any issue. We have experienced power losses and hadware failures but there has never been a single row of data corrupted. Updating to a new version was achieved with a simple export-import command.

Being able to create, alter or delete tables while the company is live in full production is a great feature. Our main data managing app has grow over the years and the original design has changed a lot but PostgreSQL has always cover our needs.

And as always in open source, at zero costs.
Recommendations to others considering the product:
If you are searching for an open source relational database, with no licensing issues, full of features, secure and reliable, choose PostgreSQL.


    Vitor H.

Great, free and open source database for any project

  • March 28, 2016
  • Review provided by G2

What do you like best about the product?
PostgreSQL is free and open source and fits great in any project size.
It's easy to connect to PostgreSQL with any technology.
It has a strong and active community.
What do you dislike about the product?
Lacks popularity.
Performance in read-heavy operations.
What problems is the product solving and how is that benefiting you?
Needed a scalable database for a large project.
Recommendations to others considering the product:
It's free and open source and contains most of the resources of other large and popular databases such as Oracle and MS SQL Server.


    Alex M.

Postgres - Great for GeoSpatial

  • March 24, 2016
  • Review provided by G2

What do you like best about the product?
Geospatial data is very handled by the PostGIS extensions.
What do you dislike about the product?
The command line interface is quite foreign from the conventions of other systems, and lacks many useful features like tab completion for identifiers.
What problems is the product solving and how is that benefiting you?
Open source, web based mapping products
Recommendations to others considering the product:
There is no better free database available currently, and it gives many commercial products a run for their money.


    Information Technology and Services

postgres developer

  • March 23, 2016
  • Review provided by G2

What do you like best about the product?
easy to install, open source, active community, lightweight but powerful SQL database
What do you dislike about the product?
replication options are limited as well as a REST API interface is also lacking
What problems is the product solving and how is that benefiting you?
I help customers replace Oracle and MS databases with Postgres as a cheaper alternative.
Recommendations to others considering the product:
a great database for Linux hosts and typical SQL based applications


    Computer Software

Great and much more friendly alternative to MySQL

  • March 18, 2016
  • Review verified by G2

What do you like best about the product?
It follows the syntax of standard SQL, quite closely related with MySQL, and it has wide variety of features not present in MySQL . . . . also is friendly with languages like Python and the likes. The existence also of a local database management software (pgAdmin) and command line tool makes everything much easier for first time users, and for experienced developers as well.
What do you dislike about the product?
Nothing so far, in particular. All in all it is a whole package as an SQL language. I have yet to delve deeper into back-end development and look further into what the PostgreSQL lacks as an SQL language. But so far it satisfied my basic needs in an SQL and back-end language.
What problems is the product solving and how is that benefiting you?
Database management through SQL with the whole package and features needed by a back-end developer.
Recommendations to others considering the product:
A must-use especially if you are a newbie in the field of back-end development. Very developer friendly and complete-packaged.


    Financial Services

The best open source ORDBMS there is.

  • March 14, 2016
  • Review verified by G2

What do you like best about the product?
PostgreSQL is by far the most fast advancing and promising open source database there is. It has an ongoing development agenda and a very active community. Performance keeps increasing and new functionalities are released with increasing frequency. It's a very robust and trustful solution for any database dependent project.
What do you dislike about the product?
The most likeable thing about PostgreSQL might be the fact that its core developers and general contributors might be more inclined to come up with new features than to address possible underlying bugs.
What problems is the product solving and how is that benefiting you?
Being in a very demanding ever-changing extendable and agile environment, working with applications that supports both structured and unstructured data, I consider PostgreSQL a life saviour. It can actually act as a document database when needed.
Recommendations to others considering the product:
It has never failed me and I bet it won't fail you either. It's reliable and has a very large user base. Typical solutions and general help can easily be found online when problems arise.


    Information Technology and Services

The best relational database

  • March 14, 2016
  • Review verified by G2

What do you like best about the product?
This is RDBMS that i use the most. I like the performance and and also hstore.
What do you dislike about the product?
Its relational database, its not specific to postgres. But when im working in research project i will not use RDBMS because in research schema change often.
What problems is the product solving and how is that benefiting you?
Mainly transactional data and when i need to use RDBMS postgres always be my first choice


    Research

PostgreSQL

  • March 14, 2016
  • Review verified by G2

What do you like best about the product?
PostgreSQL is an open source relational object-orieneted data management system. It has been improved, and provide a variety of features that I need at my work.
What do you dislike about the product?
The system scalability, and capability for big data
What problems is the product solving and how is that benefiting you?
I use it to create a data management system.


    Israel F.

The only RDBMS you will need

  • March 13, 2016
  • Review verified by G2

What do you like best about the product?
Highly extensible, several PL implementations, easy to write stored procedures if you already know python, perl or C because it implements them as procedural languages, tons of addons to extend its functionality, functional indexes to improve performance if you need to search by computed values and it makes it really easy to perform queries based on data stored in JSON fields and it supports master-slave replication natively.

It has a lot of tools to check the performance of your queries, the consistency and the health of your database and to collect garbage and clean up your database (EXPLAIN and Vacuum)

If you want a NoSQL data sture, Postgres also have you covered, you can try HStore.
What do you dislike about the product?
It is too large and has thousands of features, so documentation sometimes is outdated and you can get lost very easily if you don't know exactly what you're looking for
What problems is the product solving and how is that benefiting you?
Data storage and retrieval with great performance and a lot of tuning options if you model your data correctly.

We could also migrate some logic to the DBMS layer to optimize our application performance.
Recommendations to others considering the product:
Don't use it as a simple data store, that way you won't see the performance improvements