"PostgreSQL is the most sophisticated and adaptable database software available."
December 31, 2021

"PostgreSQL is the most sophisticated and adaptable database software available."

Aurpa Fiza | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with PostgreSQL

PostgreSQL is the most advanced and versatile DB system available and is well documented. It’s cool, and there is a lot of diversity among the people who help with it. PostgreSQL has a project (phAdmin) that allows us to carry out tasks using a friendly graphical user interface, making it an incredible database manager. It has a command-line interface for Linux and Windows that is simple to use. In addition, Golang and Python and their frameworks, such as Django for Python, can be integrated. A comprehensive documentation website makes learning about all of its features easy.
  • It works well with external data sources and runs on platforms with stable performance.
  • Clients can rest assured that their personal information will be safe and secure.
  • Many forums discuss setup and usage, and most are free.
  • Adding tooling applications to a computer is unlimited.
  • PostgreSQL runs on many OS platforms and supports ANSI SQL, stored procedures, and triggers.
  • Increasing horizontal scaling is complex, but PostgreSQL may have a solution for all replicas to accept operations.
  • No column re-ordering and better data compression are required.
  • PostgreSQL is often criticized for being slow and unsuitable for large-scale enterprise applications.
  • Its open-source and accessible means that it is easily deployed without requiring much time and creating a database.
  • It provides high reliability and security, high performance, and high throughput.
  • Usually outperforms other databases like Oracle, MySQL, and SQL Server in response time, efficiency, and resource management.
  • A robust and reliable platform reduces the risk of data loss and confusion.
  • Using an almost free product is economical. No license fees = minimal ownership cost.
  • Efficiency is high due to quickness and excellent resource management.
  • PostgreSQL helps us achieve our goals, and there are no time-consuming management tasks.
In this case, Postgres is preferred because it handles large data sets and requires fewer hardware resources than its competitor, MySQL. Compared to PostgreSQL, Microsoft products are excellent, but the installation process for MS SQL is lengthy. PostgreSQL has an advantage over its competitors in that it can adapt or configure third-party programs, applications, or settings.

Do you think PostgreSQL delivers good value for the price?

Yes

Are you happy with PostgreSQL's feature set?

Yes

Did PostgreSQL live up to sales and marketing promises?

Yes

Did implementation of PostgreSQL go as expected?

Yes

Would you buy PostgreSQL again?

Yes

PostgreSQL, unlike other databases, is user-friendly and uses an open-source database. Ideal for relational databases, they can be accessed when speed and efficiency are required. It enables high-availability and disaster recovery replication from instance to instance. PostgreSQL can store data in a JSON format, including hashes, keys, and values. Multi-platform compatibility is also a big selling point. We could, however, use all the DBMS’s cores. While it works well in fast environments, it can be problematic in slower ones or cause multiple master replication.