"Firebird SQL is an open-source solution and can run on most operating systems, such as Linux, Unix, and Windows."
"I can deploy it on Linux, Mac OS, and Windows — it's very easy."
"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 database has excellent performance."
"This is an open-source solution, operates at a high speed, and supports more than one SQL language."
"The community support and the open-source community for it are good."
"It is a pretty comprehensive database system. Its performance is good, and it does what it is supposed to do. It also integrates very well."
"It is very useful for both structured and unstructured data. You can store unstructured and structured data in PostgreSQL. It is easy to use. You can easily manage things through PostgreSQL Admin. It is cost-effective. Its on-premise version is free. It is agnostic of on-premise or cloud. You can install it on the cloud or on-premises. It is available with all clouds, and you can also install it on desktop or Windows Servers."
"Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community. When it's installed correctly, PostgreSQL is an enterprise-grade solution."
"We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance."
"The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
"It would be good to have more automation and integration with the tools from other vendors."
"The solution could improve by providing partitioning and encryption. It is not at the higher level of database solution but it could be with some upgrades."
"In the next release, it should support JSON, XML, and replication with third-party tools."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"If it was free to use, it would be the perfect solution."
"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."
"I had some issues when I integrated with the Jupyter Notebook."
"It could be improved by using parallelization. You want basically, distributed computing."
"The scalability is limited."
"They need to improve the user experience of the management."
"I'm not really able to customize it."
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 2nd in Open Source Databases with 39 reviews. Firebird SQL is rated 8.0, while PostgreSQL is rated 8.2. The top reviewer of Firebird SQL writes "Overall a good product that helps us in detecting all kinds of problems in the code". 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, MariaDB, SQLite and Oracle MySQL Cloud Service, whereas PostgreSQL is most compared with MariaDB, MySQL, EDB Postgres Advanced Server, SQLite and YugabyteDB. 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.