PostgreSQL on Windows Server by GlobalSolutions with 24/7 Support
The Globalsolutions | PostgreSQL GS_v2.7Windows, Windows Server 2012 R2 - 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.
postgresql review
What do you like best about the product?
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.
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.
What do you dislike about the product?
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.
Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime.
What problems is the product solving and how is that benefiting you?
Postgresql is really the most advanced and reliable database that we have used yet. We are using it in conjunction with Django web framework and a geospatial systems using the postgis extension.
The cost/quality ration is just unparalleled with any other solution.
The cost/quality ration is just unparalleled with any other solution.
Recommendations to others considering the product:
Postgresql is a very advanced database system with an emphasis on extensibility and customization. The documentation is quiet large and the options multiple and you will likely take you a long time to figure it all out but it's all worth it in the end.
- Leave a Comment |
- Mark review as helpful
ACID transcations for the Win
What do you like best about the product?
ACID is one of the main features that you will need when programming mission critical applications and postgres has it inbuilt. We can also change the transaction isolation level which is very needed for performance. Consistency is also very good you will never have data corrupution or data lost. JSON support in the latest version has made it very easy for us now since we don't need to migrate the schema always like before.
What do you dislike about the product?
Scalability and High availability are major issues in sql databases and in postgres its even harder since there no proper tool to do it. It locks the row on serializale transactions which is really a problem in certain cases. Many databases have other means to solve this.
What problems is the product solving and how is that benefiting you?
We Are solving Customer Engagement and Employee Engament. We Have Created a Cloud based gamification system where users can build and wire up their business rules and logic and then integrate it into their systems. We don't have any random errors anymore and programming has become easier since we don't need to handle some edge cases anymore.
Recommendations to others considering the product:
Yes. If you really don't want uncertainities in your data and want ease of coding then postgres is one of the best. Its also open source and the development work on it is really good.
Powerful free open source Database
What do you like best about the product?
I like that is very powerful and also free. It has a lot of interfaces for almost every programming language and lets you storage big objects, like pictures, videos and sound files.
What do you dislike about the product?
I don't like the tool pgAdmin, that lets you manage your databases graphically. It doesn't work well, is really slow, doesn't have prediction when you are writing queries and also stops working without any reason.
Another thing that I don't like is that you have to use LIMIT x instead of TOP x to get some x quantity of rows
Another thing that I don't like is that you have to use LIMIT x instead of TOP x to get some x quantity of rows
What problems is the product solving and how is that benefiting you?
I had to manage the databases of my university, so we move from MySQL to PostgreSQL because it was free, allowing the university save some money, but also it is very useful and potent database manager.
Recommendations to others considering the product:
Really give it a try. It is very powerful and easy to install and setup. Also it has a graphic tool that let you see how the data is storage in rows and columns
Great Tool for using SQL at a novice level
What do you like best about the product?
It is a super powerful tool with the ability to get the job done with work with your database. I am newer to SQL and have found this tool to be great with my skill level. I love the ability to export the files I need and the speed in query execution.
What do you dislike about the product?
Sometimes it can run a little slow and that can be unpredictable without reason. Most times it's very fast, but when it bugs out, you have to restart and it just can be a pain.
What problems is the product solving and how is that benefiting you?
Working through different databases building out reports for customers based on the different tables.
PostgreSQL has been the perfect tool
What do you like best about the product?
Postgres has been an incredible open source tool for our company as we've grown. We switched from MySQL, which we quickly outgrew, and have been going strong on a Python+PostgreSQL build ever since. It's easy to get new DB users up and running on simple tasks, and has great flexibility with its user defined functions.
What do you dislike about the product?
All the graphical query tools that are also free are mediocre at best. There are some really good ones, but they require a subscription.
What problems is the product solving and how is that benefiting you?
Proprietary and client data storage in an easily accessible form as well as powering our software interface by building out data tables on the back end.
Recommendations to others considering the product:
Its open source, give it a shot, you won't regret it.
Data scientist reviewing my favourite SQL database
What do you like best about the product?
Native JSON support (data storage and querying), geo spatial queries through Post GIS and
What do you dislike about the product?
Somewhat cumbersome initial installation, no multicore querying.
What problems is the product solving and how is that benefiting you?
Data Common SQL tasks: data storage, querying, aggregations. Plus storing JSON, and geo spatial calculations on database level.
Realized benefits are JSON functions in Postgres.
Realized benefits are JSON functions in Postgres.
Recommendations to others considering the product:
It is an open source software with excellent user management, access control and fantastic set of extensions like spatial queries, full text search and
A Workhorse
What do you like best about the product?
This database can do just about anything. For a modern web application the support for JSON, and JSONB columns is incredible. The addition of native upsert in 9.5 is huge, too.
What do you dislike about the product?
Managing PostgreSQL is generally not quite as much "fun," or as simple as SQL Server, or MariaDB.
What problems is the product solving and how is that benefiting you?
With JSON and JSONB columns we have been able to use PostgreSQL as a document store, in addition to leveraging its conventional relational qualities.
A great database to use over most competitors
What do you like best about the product?
The features in PostgreSQL are excellent, other competing products are years behind in the tools that are already available. It is very configurable for almost any kind of environment and product you are building, if you need high availability, redundancy, clustering, etc. it is supported. Lots of granularity in the data being stored.
What do you dislike about the product?
Coming from a product like MySQL that is much simpler than PostgreSQL can seem a little overwhelming as you get up to speed on documentation and configuration guides.
What problems is the product solving and how is that benefiting you?
Needing an open source and free database solution that was more reliable than MySQL but had most of the functionality that exists in Oracle. Our database is rock solid and performs very well, it's been easy to customize as our needs change.
Recommendations to others considering the product:
Get past the initial hurdle of learning how PostgreSQL works and enjoy using it - it offers a lot of great functionality.
A powerful flavor of SQL
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!
Fast, reliable and scalable open source database
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.
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.
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.
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.
showing 561 - 570