Anonymous UserDBA at a consultancy
Anonymous UserChief technical officer at a healthcare company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"I find the ease of deployment to be the most valuable aspect of this solution."
"The solution is very useful for stock management."
"It helps us in detecting all kinds of problems in the code, such as bad quality, unclear code, or any violation in the code or best practices."
"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."
"I don't think the solution is very scalable, because the scalability of the performance when using more than one process is not very good."
"It would be interesting if they added functionality with redundancy, reputation, and variability."
"It would be good to have more automation and integration with the tools from other vendors."
"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."
"It is a public domain system as every customer can install it on their system without paying any license fee."
"It is okay."
"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."
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:
Firebird SQL is ranked 4th in Open Source Databases with 3 reviews while PostgreSQL is ranked 3rd in Open Source Databases with 10 reviews. Firebird SQL is rated 7.4, while PostgreSQL is rated 8.4. The top reviewer of Firebird SQL writes "Free to use but they need to add features such as functionality with redundancy". On the other hand, the top reviewer of PostgreSQL writes "Can be clustered which allows for fault tolerance". Firebird SQL is most compared with MySQL, SQLite, MariaDB, Oracle MySQL Cloud Service and Percona Server, whereas PostgreSQL is most compared with EDB Postgres Advanced Server, MariaDB, Percona Server, MySQL and SQLite. See our Firebird SQL 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.