PostgreSQL on Ubuntu 16.04
Supported Images | 20210403Linux/Unix, Ubuntu 16.04 LTS - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
Simple to use, Easy SQL management tool.
What do you like best about the product?
Coming from a MySQL background it is very similar and allows me to manage my data in any way I see fit.
What do you dislike about the product?
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.
What problems is the product 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.
Recommendations to others considering the product:
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.
- Leave a Comment |
- Mark review as helpful
PostgreSQL - OpenSource DB
What do you like best about the product?
It's free and easy to use. We had software that would use this DB to keep and modify data.
What do you dislike about the product?
Could be more intuitive, the graphical user interface could be improved.
What problems is the product solving and how is that benefiting you?
Quick to install if you need to whip up a DB
Simple and easy to use
What do you like best about the product?
I like how simple this software is. It doesn't try to get you with a fancy UI or anything crazy intricate. it's straight forward and it is easy to use for anyone who has SQL experience. Whether in the classroom or at the workplace, it's a really great program for database work. It's user friendly in the sense that is is basic and easy. It may not have all the bells and whistles of other software but that's kind of what I like about it. The output pane when doing queries is nice and simple to read. it's easy to make sure you can see all of the data you need to see in your databases. I also like that the SQL editor gives you color differences on the words so you know that you are entering the correct information. It will come up red if it thinks something is wrong.
What do you dislike about the product?
It's hard to tell sometimes which DB on your server you are in, as it doesn't highlight it very well. It also is somewhat annoying to have to open a separate screen for actually running SQL.
What problems is the product solving and how is that benefiting you?
We are able to look up information quickly when a user needs to know about data that we can only find within the database. It's great for when we are looking into defects and also for writing automation tests. There are a lot of benefits.
Recommendations to others considering the product:
Learn up on SQL!
Great opensource relational database
What do you like best about the product?
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.
What do you dislike about the product?
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.
What problems is the product 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.
Recommendations to others considering the product:
It works really well for us using Ruby on Rails and deploying to Heroku utilized Heroku Postgres.
One of the BEST PL/SQL development tools
What do you like best about the product?
I love how easy it is to set up PostgreSQL and connect it to a Database.
What do you dislike about the product?
The gui is not user friendly for a layperson. You must have some knowledge of Database programming to use.
What problems is the product solving and how is that benefiting you?
PostgreSQL has made it possible for us to maintain and report on smaller databases that the users create via Access.
Scalable, flexible databases for any use
What do you like best about the product?
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!
What do you dislike about the product?
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!
What problems is the product solving and how is that benefiting you?
We use Postgres to host our primary application database. It's given us massive scalability by allowing us to tie multiple microservices together into one application.
Recommendations to others considering the product:
Keep your data structures clean and ensure your relations don't blend across schemas too often. While cross-schema queries are possible, building your application to use them will limit you in terms of scalability should you ever wish to spread your database across multiple servers/instances.
Postgres is a great example of great OSS
What do you like best about the product?
The amount of updates, and support by the community is amazing.
What do you dislike about the product?
Nothing in particular, only that replication could take a page out of mysql.
What problems is the product solving and how is that benefiting you?
Our entire BI database is primarily on Postgresql, it is easy to maintain and does not require a lot of resources to run an efficient database.
Easily Manageable RDBS
What do you like best about the product?
CTEs – Common Table Expressions - which allow us to do awesome things like recursive queries but even the most simple form of them. A nice feature that we can easily achive
What do you dislike about the product?
Its replication was implemented at the storage engine level, that makes it bit expensive interms of reoplication
What problems is the product solving and how is that benefiting you?
SMALL query based tables
Recommendations to others considering the product:
Implements the SQL standard very well and supports lots of advanced data types, inclusing multi-dimensional arrays, user-defined types, etc.
PostgreSQL review
What do you like best about the product?
Although the speed of response may seem deficient in small databases, that speed is maintained by increasing the size of the database, which is not the case with other programs, which slow down brutally.
Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs.
Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance.
Stability and Reliability: No database crashes.
Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs.
Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state.
Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups
Graphic design and database management tools.
It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL.
It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X.
Good security system through the management of users, groups of users and passwords.
Great storage capacity.
Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly.
Unlimited installation: You can not sue a company for installing it on more computers than the license allows, as there is no cost associated with the software license. This allows for a more profitable business with large scale installations, we should not worry about being audited to see if we comply with the license, and there is flexibility and development without additional licensing costs.
Considerable savings in operating costs: PostgreSQL has been designed to have lower maintenance and adjustment than products of commercial suppliers, retaining all the features, stability and performance.
Stability and Reliability: No database crashes.
Extensible: The source code is available for free, so that whoever needs to extend or customize the program can do so without costs.
Multiplatform: Available on almost any Unix, with 34 platforms in the latest stable version, plus a native version of Windows in test state.
Designed for high-volume environments: Using a row storage strategy called MVCC, it gets better response in large volumes. In addition, MVCC allows read-only accesses to continue reading consistent data while updating records, allowing hot backups
Graphic design and database management tools.
It supports the SQL92 / SQL99 standard and standard type data, clauses, functions, and extended commands of PostgreSQL.
It can operate on different platforms, including Linux, Windows, Unix, Solaris and MacOS X.
Good security system through the management of users, groups of users and passwords.
Great storage capacity.
Good scalability as it is able to adjust to the number of CPUs and the amount of memory available optimally, supporting a greater number of concurrent requests to the database correctly.
What do you dislike about the product?
Compared to MySQL it is slower in insertions and updates because it has intersection headers that does not have MySQL.
Online support: There are official forums, but there is no obligatory help.
Consume more resources than MySQL.
The syntax of some of your commands or statements is not at all intuitive.
Online support: There are official forums, but there is no obligatory help.
Consume more resources than MySQL.
The syntax of some of your commands or statements is not at all intuitive.
What problems is the product solving and how is that benefiting you?
Multiversion concurrency control; the MVCC; this method adds an image of the state of the database to each transaction. This allows transactions to be made consistently, offering great performance advantages. For example, it is not necessary to use read locks when performing a transaction, which provides greater scalability. thus solving scalability problems.
Recommendations to others considering the product:
YES
An easy, reliable, embeddable database engine
What do you like best about the product?
Simplicity and how easy it was to set up.
What do you dislike about the product?
The product is lacking some features that are norm these days for a database engine.
What problems is the product solving and how is that benefiting you?
An in house application was using this database to store the results persistently.
Recommendations to others considering the product:
When you need a database engine/storage which is easy to integrate into the logic of your in-house application, capable of supporting SQL alike queries - PostgreSQL is the way to go.
showing 481 - 490