We performed a comparison between Firebird SQL, Oracle MySQL Cloud Service, and PostgreSQL based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."The most valuable feature of Firebird SQL is the creation of databases."
"We are happy with the event capabilities of Firebird SQL database. We can raise events from it and display them in our application."
"The documentation is very well written."
"Firebird SQL is an open-source solution."
"I like that we don't have to pay external fees to migrate this data. So, we are looking to relocate from Postgres or EDB."
"The product was easy to use."
"The most valuable feature of the solution is that it is reliable, offers good performance, and is easy to use."
"I can deploy it on Linux, Mac OS, and Windows — it's very easy."
"The product is easy to learn."
"The most valuable aspect of the product is data migration."
"The scalability of the database is absolutely guaranteed by the new features."
"It's easy to use."
"The access to a suite of management and administration tools that simplify tasks such as database provisioning, configuration, and monitoring."
"The initial setup was straightforward."
"The product is good for tuning."
"The most valuable feature is the data aggregation function."
"We often use PostgreSQL for operations monitoring because we are a manufacturing company."
"It's a standard reliable database management system."
"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."
"The tool is user-friendly."
"PostgreSQL makes it very adaptable to several descriptions of a record. Instead of having several tables or several relations for one entity, I can adapt this entity. It can be a multiform entity. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person."
"PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. We have experience with Oracle database. My partner is experienced in DDA and he writes sophisticated SQL queries. The solution helps to get the job done in the best possible way. In today’s age, most developers do not have strong SQL knowledge or language command. They find it difficult to write even a SQL statement. These developers write cool queries which perform badly on the database end. As DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands."
"The product is quite flexible."
"In the next release, it should support JSON, XML, and replication with third-party tools."
"The main feature I expect is to be able to work with different databases at the same time because that's a wishlist item for me."
"It is not easy to integrate the tool with Visual Studio."
"Database sharing is a capability that Firebird SQL lacks."
"It would be good to have more automation and integration with the tools from other vendors."
"It would be nice to have a graphical user interface to handle the product."
"It would be interesting if they added functionality with redundancy, reputation, and variability."
"On large databases, we have some difficulties."
"The solution should offer memory management."
"The product has many bugs."
"The user interface is not simple."
"It requires a significant amount of expertise and effort to manage, especially when dealing with substantial volumes of data."
"There could be more courses where the people could learn more easily how to use the tool."
"Integrating business intelligence or NLP solutions would help us save time and would prevent us from having to take a deep dive. Data problems seem to multiply on the system when you interact with it. Automation would save a lot of man-hours."
"They could include more advanced features like clustering and replication in the Oracle databases."
"Improvement could be made in the workflow, particularly when it comes to making changes or implementing certain functions."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"We often find the solution's datetime datatype challenging."
"I have noticed that user and access management should be improved."
"When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties."
"I find it difficult to get connectors on the tool. For example, .NET has only one free provider in PostgreSQL. I need to pay the provider if I need something more sophisticated features. Other languages like PHP and Java have good community support. We need community support for .NET."
"I'm not really able to customize it."
"The performance of PostgreSQL could improve."
"The interface climate could be better."
