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

PostgreSQL

TurnKey GNU/Linux | 1

Reviews from AWS Marketplace

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

External reviews

603 reviews
from G2

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


    Mohit S.

Best open source database to achieve high performance and scalability.

  • September 01, 2023
  • Review provided by G2

What do you like best about the product?
It is a open source application and allows to scale whenever needed. It is very fast and secure to manipulate data. Database creation, updation is very easy in PostgreSQL.
What do you dislike about the product?
Learning PostgreSQL is challenging in beginning because it is complex and documentation is not that much easy to understand. The documentation should have examples for reference.
What problems is the product solving and how is that benefiting you?
I have huge real time data to manipulate. When I used other framework the performance of data transfer was low. With the help of PostgreSQL I achieved data manipulation faster.


    Jainesh K.

An opensource and reliable DB with essential functionalities

  • August 31, 2023
  • Review provided by G2

What do you like best about the product?
- It's open-source which means without paying a penny we can leverage a variety of database features with regular improvements and bug fixes provided by community members.
- It's a scalable database that can be used for a variety of applications.
-Its JSONB support makes It easier to work with JSON types and we can work on relational as well as non-relational data on the same system.
- Full text search feature is also provided by PostgreSQL which can help in a variety of applications.
What do you dislike about the product?
- There are some opensource apps that might not support PostgreSQL but MySQL because It is not owned by a single entity and hence lacks the recognition It deserve.
- Might not be a good solution for the shared dataset as there is no out of the box approach available for it in PostgreSQL.
- It might have a steep learning curve for beginners.
What problems is the product solving and how is that benefiting you?
- Using relational and non-relational data on the same system as It handles JSON data type very gracefully thanks to JSONB.
- It can significantly help in improving your application cost as Its available free of cost.
- Works well with large data/applications as well.
- Strong support from a larger developers community makes It reliable and easy to use.


    Alexandre G.

PostgreSQL: Uma Avaliação Equilibrada de Suas Forças e Desafios

  • August 29, 2023
  • Review verified by G2

What do you like best about the product?
O PostgreSQL é reconhecido como um dos sistemas de gerenciamento de bancos de dados relacionais de código aberto mais avançados e robustos disponíveis.
Pontos Fortes:

Código Aberto: Estar sob a licença de código aberto permite que a comunidade contribua ativamente para o seu desenvolvimento, o que acelera a introdução de novas funcionalidades e correções.

Conformidade com SQL: O PostgreSQL oferece alto grau de conformidade com o padrão ANSI SQL, o que facilita a migração a partir de outros sistemas de gerenciamento de bancos de dados.

Extensibilidade: O PostgreSQL suporta a definição de tipos, funções e operadores personalizados. Isso permite que os desenvolvedores expandam suas capacidades de acordo com as necessidades específicas.

Recursos Avançados: Oferece recursos avançados como a capacidade de armazenar dados JSON, suporte para pesquisa de texto completo, partições, triggers, views materializadas e extensões geoespaciais (PostGIS).

Segurança: Oferece uma variedade de mecanismos de segurança, incluindo autenticação, controle de acesso baseado em funções e criptografia de dados em repouso e em trânsito.
What do you dislike about the product?
Desempenho em Cargas Extremamente Altas: Em comparação com algumas soluções comerciais, o PostgreSQL pode não ser tão otimizado para cenários de carga extrema, embora, para a maioria das aplicações, ele seja mais do que adequado.

Ferramentas de Gerenciamento: Enquanto o PostgreSQL possui o PgAdmin como interface gráfica principal, pode não ser tão refinado ou tão repleto de recursos quanto algumas ferramentas comerciais disponíveis para outros sistemas de gerenciamento de bancos de dados.

Replicação e Alta Disponibilidade: Embora o PostgreSQL ofereça soluções para replicação e alta disponibilidade, a configuração e gerenciamento dessas soluções pode ser mais complexa em comparação com algumas soluções comerciais integradas.

Documentação: Embora a documentação do PostgreSQL seja abrangente, ela pode ser densa e, às vezes, difícil para os iniciantes. Poderia beneficiar-se de mais tutoriais práticos ou exemplos de uso.

Complexidade: Devido à sua extensibilidade e riqueza de recursos, o PostgreSQL pode ser percebido como complexo para novos usuários ou para aqueles que vêm de soluções mais simples.
What problems is the product solving and how is that benefiting you?
Economia de Custos: Como solução de código aberto, o PostgreSQL oferece uma alternativa robusta a sistemas de gerenciamento de bancos de dados comerciais, muitas vezes caros. Isso permite que empresas e desenvolvedores individuais tenham uma opção poderosa sem os custos associados.

Extensibilidade: O PostgreSQL permite que desenvolvedores criem tipos, funções e operadores personalizados. Isso é extremamente valioso para aplicações que necessitam de personalização profunda ou que trabalham com tipos de dados não convencionais.

Conformidade com Padrões: Sua alta conformidade com o padrão ANSI SQL torna mais fácil para os desenvolvedores trabalhar com o PostgreSQL e transferir conhecimento de outros sistemas de gerenciamento de bancos de dados.

Recursos Avançados: O PostgreSQL oferece suporte a recursos avançados, como dados JSON, pesquisa de texto completo e extensões geoespaciais (PostGIS). Isso o torna adequado para uma variedade de aplicações modernas, desde sistemas de gerenciamento de conteúdo até soluções de geolocalização.

Segurança: O PostgreSQL possui várias camadas de segurança, incluindo autenticação, controle de acesso baseado em funções e criptografia de dados. Isso beneficia aplicações que exigem um alto nível de segurança para dados sensíveis.

Escala e Desempenho: Embora haja outros sistemas de gerenciamento de bancos de dados que se destacam especificamente em cenários de alta carga, o PostgreSQL é adequado para uma ampla variedade de aplicações, desde pequenos projetos até sistemas empresariais de médio porte.


    Computer Software

Postgres - Open source RDBMS solution

  • August 28, 2023
  • Review verified by G2

What do you like best about the product?
The PostgreSQL relational database is a open source database system - which is free to use, easily configurable and carry overs all the basic SQL principles and Syntax.
What do you dislike about the product?
There is a downside of the PostgreSQL that it is not able to handle multiple idle connections, it loses the ability for new connections to reconnect. If that can be fixed, it's awesome.
What problems is the product solving and how is that benefiting you?
It enables organizations and users to create, manipulate and configure a relational database into a business use case. It is free to use, and the saves licensing costs while providing reliability.


    Kaustubh K.

Great services and simple db to use

  • August 24, 2023
  • Review provided by G2

What do you like best about the product?
PostgreSQL is open source database management solution. For SQL queries, it supports both SQL and JSON. Also we can use complex data types and performance optimisation tools that we would normally only find in pricey commercial databases. And as per the develoeprs view we can create custom data types , functions and all and if configured correctly , we can perform complex data operation , recursive queries and many more.
What do you dislike about the product?
If we talk. About the speed then mysql is works beeter in that but PostgreSQL works more on compatibility. And also just one thing that many open source application support needs to be given in PostgreSQL.to add this just one thing if it is not configured correctly , it can give issues while optimisation.
What problems is the product solving and how is that benefiting you?
I've used that in web apps and websites.As it is open source so we can use it it without any limitation without any restrictions.Also I didn't get too much of training to use PostgreSQL. As it is very easy to use.


    Piyush G.

Best Cloud DB.

  • July 28, 2023
  • Review provided by G2

What do you like best about the product?
The best part about PostgreSQL is it is very easy to use in comparison with other SQL Databases.I use Aurora PostgreSQL which is cloud DB provided by AWS. It is very much powerful and the query response time is blazingly fast. Like it can fetch millions of records in seconds only. As a backend nodejs developers I heavily use it by integrating it with the pg node module or dependency. It very easy to setup as it provides pool and client connection object to be attached.
What do you dislike about the product?
It can be a little complicated for someone who is new to SQL Database or for begginers because of it's deep learning Curve. But there are so many resources and it's official documentation that helps a lot to start.
What problems is the product solving and how is that benefiting you?
I use Aurora PostgreSQL which is cloud DB provided by AWS. It is very much powerful and the query response time is blazingly fast. Like it can fetch millions of records in seconds only. As a backend nodejs developers I heavily use it by integrating it with the pg node module or dependency. It very easy to setup as it provides pool and client connection object to be attached. As we are developing a enterprise application and the data is huge so it's the ideal choice because it very secure,reliable and it can be scaled up at any time. It's top notched DB Management System


    Amir R.

Postgres review

  • July 28, 2023
  • Review provided by G2

What do you like best about the product?
It is a flexible, fast RDBMS, with a lot of features
What do you dislike about the product?
There is nothing wrong with this databased server.
What problems is the product solving and how is that benefiting you?
Serving as a data concentrator to keep all data from various database servers.


    Ayush G.

Postgres: Flexible SQL/NOSQL Database

  • July 05, 2023
  • Review provided by G2

What do you like best about the product?
-It has the ability to store NOSQL data as well such as JSON
-Well suited when data is transactional as well as informative
-Free to use
-Postgres's ORM is available For almost all major programming language
-Installation is very straightforward
-Easy to maintain compared to other SQL databases
What do you dislike about the product?
-Not as fast as MySQL
-Without ORM, Query writing can be tedious and slow
-As it supports JSON schema as well it can be difficult to manage at scale
-Horizontal scaling can be trickier to achieve
What problems is the product solving and how is that benefiting you?
It works best when dealing with mixed types of data such as transactions, spatial, and geo-location as it can also store data in document format, unlike any other SQL database. Also its well suited if you're planning on vertical scaling of the database.


    Michelle C.

Secure, Powerful and Open-source database management system

  • July 04, 2023
  • Review verified by G2

What do you like best about the product?
PostgreSQL is a powerful open-source object-relational database management system. It is one of the highly used databases across different organizations worldwide. It can run all operating systems and manage data held in relational databases. It provides support for a variety of data such as images, text, video, audio, and more. It is very easy to learn for new developers as it supports all SQL features and we can add extensions to enable additional functions.
A user can work with PostgreSQL either through the CLI interface or through the pgAdmin desktop application. Once you enter the credentials to connect pgAdmin app with the database all the queries and operations will be in sync with the CLI interface as well.
What do you dislike about the product?
The only drawback I found using PostgreSQL is that the initial setup is a bit challenging. Sometimes it creates difficulties in creating new users for PostgreSQL and setting up credentials to log in to the database. If this could be made easy it will really help and save us a lot of hours of configuration time.
What problems is the product solving and how is that benefiting you?
My organization uses PostgreSQL as a primary solution for storing, retrieving, and manipulating data in Relational databases. We store users' data such as profile information, images, texts, and transaction details in the PostgreSQL database. We integrated PostgreSQL with DataGrip by Jetbrains to get a UI view of data that saves a lot of time and resources in running queries to view data. It can perform queries in milliseconds in petabytes of data. It maintains data integrity, security, and validation on the go and is easily scalable to size limits. Also, it allows developers to run it on container and virtual machines. The multiple language support and similarity with SQL make it easy to onboard new developers.


    Praneel Kumar P.

PostgreSQL

  • June 23, 2023
  • Review provided by G2

What do you like best about the product?
Ability to manage database securely and easily, easy to integrate to several applications.
What do you dislike about the product?
Nothing, so far everything is fine going
What problems is the product solving and how is that benefiting you?
Database management, backups and recoveries, easy administration and migration