Firebird SQL vs Oracle MySQL Cloud Service vs PostgreSQL comparison

Cancel
You must select at least 2 products to compare!
Firebird Logo
12,152 views|9,664 comparisons
85% willing to recommend
Oracle Logo
452 views|363 comparisons
88% willing to recommend
PostgreSQL Logo
12,951 views|10,477 comparisons
96% willing to recommend
Comparison Buyer's Guide
Executive Summary

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, Firebird and others in Open Source Databases.
To learn more, read our detailed Open Source Databases Report (Updated: April 2024).
769,479 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I appreciate the fact that, once the database is embedded, it doesn't need to be administered, and removes the requirement for a specific server.""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 solution is very useful for stock management.""The most valuable feature of the solution is that it is reliable, offers good performance, and is easy to use.""I find the ease of deployment to be the most valuable aspect of this solution.""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.""Firebird SQL is an open-source solution."

More Firebird SQL Pros →

"The scalability of the database is absolutely guaranteed by the new features.""The most valuable feature is the data aggregation function.""It is very easy to start working with the product.""It's easy to use.""Oracle MySQL Cloud Service is easy to use and implement.""The most valuable aspect of the product is data migration.""The product is easy to learn.""The stability of the solution is very good. I wouldn't have used it for the past seven years if I was not satisfied."

More Oracle MySQL Cloud Service Pros →

"The product is quite flexible.""What I like is that it's quite powerful in terms of performance.""The solution is quite stable.""We often use PostgreSQL for operations monitoring because we are a manufacturing company.""The solution is open-source and free to use.""I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable.""The initial setup is quick and easy.""The tool is user-friendly."

More PostgreSQL Pros →

Cons
"This solution isn't very user-friendly, or intuitive, which could be improved when it is developed.""It would be good to have more automation and integration with the tools from other vendors.""Technical support and performance could be better. We have some problems with this solution, but we don't know if the problem is with the database or the configuration. For example, sometimes, the users can't access the database.""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.""Database sharing is a capability that Firebird SQL lacks.""Firebird SQL's performance has slowed since Firebird SQL 3 or 3.5 versions, where they developed over-the-wire encryption.""The security of the users could improve in Firebird SQL.""On large databases, we have some difficulties."

More Firebird SQL Cons →

"There could be more courses where the people could learn more easily how to use the tool.""They could include more advanced features like clustering and replication in the Oracle databases.""The support is not that great. They're not really supporting directly anymore and relying on experts to figure out technical issues.""In a production environment, upgrading from a lower to an upper version is a very long process that needs to be improved.""Oracle MySQL Cloud Service's scalability is an area of concern that can be better.""Sometimes MySQL does upgrades on the server. When we are still using the old server and when they integrate the upgrade, they don't carry along some of the old syntaxes. The versions don't sync.""Improvement could be made in the workflow, particularly when it comes to making changes or implementing certain functions.""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."

More Oracle MySQL Cloud Service Cons →

"PostgreSQL uses high memory compared to its counterparts when a highly demanding load is involved, especially one that makes many concurrent connections to the database.""We have to set up event API, which takes a lot of events from the user.""I have noticed that user and access management should be improved.""They need to improve the user experience of the management.""Integration with other platforms could be improved.""I'm not really able to customize it.""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.""It needs more integration."

More PostgreSQL Cons →

Pricing and Cost Advice
  • "It is a public domain system as every customer can install it on their system without paying any license fee."
  • "It is okay."
  • "There is a yearly maintenance fee for the use of the solution."
  • "There is no licensing cost for this solution, as it is open-source."
  • "I was using the free version of Firebird SQL."
  • "The most valuable feature of the solution is that it is freely available."
  • "We are using the free solution, so there is no cost involved."
  • "Firebird SQL is an open-source solution, which means it is a free product."
  • More Firebird SQL Pricing and Cost Advice →

  • "The solution’s paid plans are expensive."
  • "The license is expensive."
  • "While the core solution itself is not exorbitant, the support services are associated with a significant maintenance fee, often ranging from twenty to thirty percent."
  • "The product is free since it is an open-source tool."
  • "It is an open-source product."
  • "The product is expensive."
  • More Oracle MySQL Cloud Service Pricing and Cost Advice →

  • "Affordable solution."
  • "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."
  • "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."
  • "We do not pay for licensing."
  • More PostgreSQL Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
    769,479 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a… more »
    Top Answer:Firebird SQL is an open-source solution.
    Top Answer:Oracle MySQL Cloud Service handles data easily.
    Top Answer:Improvement could be made in the workflow, particularly when it comes to making changes or implementing certain… more »
    Top Answer:The search option is not very good. If I need to see data in a table, I must go into the table. The solution must… more »
    Ranking
    3rd
    Views
    12,152
    Comparisons
    9,664
    Reviews
    9
    Average Words per Review
    402
    Rating
    7.9
    7th
    Views
    452
    Comparisons
    363
    Reviews
    10
    Average Words per Review
    289
    Rating
    8.2
    2nd
    Views
    12,951
    Comparisons
    10,477
    Reviews
    7
    Average Words per Review
    368
    Rating
    8.9
    Comparisons
    Learn More
    Firebird
    Video Not Available
    PostgreSQL
    Video Not Available
    Overview

    Firebird SQL is an open-source, cross-platform relational database management system that offers an enterprise-level database solution. The solution is designed to be highly secure, efficient, and compatible with various platforms and programming languages. Firebird can operate in both embedded and server modes.

    Firebird is an open-source project with an active community of developers and users. It is released under the Initial Developer's Public License (IDPL) and the InterBase Public License, allowing for free use, modification, and distribution. 

    The Firebird solution requires minimal configuration and its architecture allows it to efficiently handle databases ranging from a few KB to multiple terabytes. It is available for various operating systems, including Windows, Linux, macOS, and several Unix-like platforms.

    What are the key features of Firebird SQL?

    1. ACID Compliance: Firebird provides full support for ACID (Atomicity, Consistency, Isolation, Durability) transactions, ensuring data integrity and consistency, even in the event of system failures or concurrent access.
    2. SQL Language Support: Firebird SQL provides extensive support for ANSI SQL, which is the standard SQL language, making it compatible with a wide range of applications and tools.
    3. Multi-Generational Architecture: Firebird employs a multi-generational architecture, which allows multiple versions of the same data to coexist within the database.
    4. Concurrency and Performance: Firebird offers efficient concurrency control mechanisms, including multi-version concurrency control (MVCC), which allows multiple transactions to access and modify data simultaneously without locking or blocking each other, improving overall performance.
    5. Embedded mode: In the embedded mode, the database engine is integrated directly into the application.
    6. Security Features: Firebird provides user authentication, role-based access control, and encryption capabilities. It supports various authentication methods, such as native Firebird user accounts, external authentication sources (e.g., Windows domains), and single sign-on (SSO) mechanisms.
    7. Backup and Restore: Firebird offers built-in backup and restore utilities, allowing users to create full or incremental backups of the database, as well as restore from these backups when needed.

    As part of being a commonly used open-sourced solution, Firebird boasts a vibrant community of developers and users. The community provides extensive documentation, third-party tools, and active forums for support. Businesses can also opt for professional support services offered by third-party vendors for added assurance.

    To summarize, Firebird SQL is a robust, scalable, and cost-effective database solution suitable for a wide range of applications and business sizes. Its comprehensive SQL support, security features, and cross-platform compatibility, combined with the active community support, make it a compelling choice for businesses looking to leverage the power of open-source software without compromising on performance or security.

      Oracle MySQL Cloud Service delivers a secure, cost-effective and enterprise-grade MySQL database service. Built on MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise ready MySQL cloud service, enabling organizations to increase business agility and reduce costs.

      PostgreSQL is a versatile and reliable database management system commonly used for web development, data analysis, and building scalable databases. 

      It offers advanced features like indexing, replication, and transaction management. Users appreciate its flexibility, performance, and ability to handle large amounts of data efficiently. Its robustness, scalability, and support for complex queries make it highly valuable. 

      Additionally, PostgreSQL's extensibility, flexibility, community support, and frequent updates contribute to its ongoing improvement and stability.

      Sample Customers
      Elekt Labs, Streamsoft, wobe-systems GmbH, DRB Systems, Moscow City Hospital #31
      Omnis, Naveex, Rehash Technologies
      1. Apple 2. Cisco 3. Fujitsu 4. Instagram 5. Netflix 6. Red Hat 7. Sony 8. Uber 9. Cisco Systems 10. Skype 11. LinkedIn 12. Etsy 13. Yelp 14. Reddit 15. Dropbox 16. Slack 17. Twitch 18. WhatsApp 19. Snapchat 20. Shazam 21. SoundCloud 22. The New York Times 23. Cisco WebEx 24. Atlassian 25. Cisco Meraki 26. Heroku 27. GitLab 28. Zalando 29. OpenTable 30. Trello 31. Square Enix 32. Bloomberg
      Top Industries
      VISITORS READING REVIEWS
      Computer Software Company15%
      Comms Service Provider14%
      Educational Organization8%
      Manufacturing Company7%
      REVIEWERS
      Manufacturing Company30%
      Energy/Utilities Company20%
      University20%
      Comms Service Provider10%
      VISITORS READING REVIEWS
      Financial Services Firm18%
      Computer Software Company12%
      University11%
      Manufacturing Company9%
      REVIEWERS
      Computer Software Company14%
      Comms Service Provider13%
      Financial Services Firm9%
      University8%
      VISITORS READING REVIEWS
      Computer Software Company15%
      Comms Service Provider12%
      Financial Services Firm10%
      Manufacturing Company7%
      Company Size
      REVIEWERS
      Small Business85%
      Midsize Enterprise15%
      VISITORS READING REVIEWS
      Small Business31%
      Midsize Enterprise16%
      Large Enterprise53%
      REVIEWERS
      Small Business40%
      Midsize Enterprise7%
      Large Enterprise53%
      VISITORS READING REVIEWS
      Small Business28%
      Midsize Enterprise8%
      Large Enterprise64%
      REVIEWERS
      Small Business45%
      Midsize Enterprise20%
      Large Enterprise35%
      VISITORS READING REVIEWS
      Small Business27%
      Midsize Enterprise14%
      Large Enterprise59%
      Buyer's Guide
      Open Source Databases
      April 2024
      Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases. Updated: April 2024.
      769,479 professionals have used our research since 2012.