Anonymous UserDirector of IT Maintenance Department at a financial services firm
Faustine ChisasaEngineering Supervisor- Corporate Data Solutions and Services at TZ Telecoms. Corporation
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"It gives us a solid, less expensive alternative to deploying with Oracle."
"The low cost and functionality allows us to save money on smaller database projects."
"The most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use."
"It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
"The database has excellent performance."
"Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"The product is quite flexible."
"What I like is that it's quite powerful in terms of performance."
"The built-in code procedural language is the most valuable. It has a built-in layer for code procedures. Its installation is very easy and quick, and it is free. It is also stable, and its performance is also good."
"The system is aging and not keeping up with the performance of new, enhanced database models."
"The security is not very robust and the product would be much more useful with more security options."
"The user interface for the clients could be easier to use as they are small businesses. From a technical support perspective, the documentation could be improved."
"It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself."
"The user interface could be a bit better."
"It could be improved by using parallelization. You want basically, distributed computing."
"The database and applications can become very slow."
"The pricing could be better."
"I had some issues when I integrated with the Jupyter Notebook."
"PostgreSQL doesn't have a feature for temporal SQL, which is useful for gathering versions of data. This feature should be included in PostgreSQL. This feature is available in MariaDB, SQL Server, Oracle Database, and DB2."
"Pricing is significantly lower than competing products."
"The product is either free with community support or very inexpensive with a small yearly fee for paid support."
"It is free. There is no license on it."
"It is also open-source so it is free."
"PostgreSQL is a free and open-source database."
"It is free, but if you need support, you can go for the commercial version called EnterpriseDB. They provide paid support, and they can even do hosting for you if you want standby and support."
"PostgreSQL is open-source, so if capable admins are available then the setup cost can be $0."
"It is open-source. If you use it on-premise, it is free. It also has enterprise or commercial versions. If you go for the cloud version, there will be a cost, but it is lower than Oracle or Microsoft."
"The solution requires a license."
Earn 20 points
EDB Postgres Advanced Server is EDB’s enhanced Postgres database designed to meet the needs of the digital enterprise. EDB Advanced Server incorporates all of PostgreSQL’s features with additional enterprise-class functionality for enhanced performance and security requirements for enterprise workloads. EDB Advanced Server features improve DBA and developer productivity. Oracle users benefit from EDB Advanced Server’s native database compatibility with Oracle, including PL/SQL, built-in packages, and many DBA tools to accelerate and simplify migrations.
PostgreSQL is a powerful and fully-featured database management system with which business owners can create object relational tables. It is an open source project that can be acquired for free and heavily focuses on elements such as extensibility and strict standard compliance. PostgreSQL is a flexible server system that can manage large workloads that are being contributed and accessed from a wide range of locations such as in a network, as well as small-scale projects like a single machine or user.
Some technical details of interest about PostgreSQL include:
EDB Postgres Advanced Server is ranked 5th in Open Source Databases with 3 reviews while PostgreSQL is ranked 3rd in Open Source Databases with 14 reviews. EDB Postgres Advanced Server is rated 8.4, while PostgreSQL is rated 8.2. The top reviewer of EDB Postgres Advanced Server writes "Provides enhanced functionality but the technology is aging". On the other hand, the top reviewer of PostgreSQL writes "Can be clustered which allows for fault tolerance". EDB Postgres Advanced Server is most compared with Percona Server, MySQL, Oracle MySQL Cloud Service and MariaDB, whereas PostgreSQL is most compared with Firebird SQL, MariaDB, Percona Server, SQLite and MySQL. See our EDB Postgres Advanced Server vs. PostgreSQL report.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.