We compared Firebird SQL and MySQL based on our user's reviews in several parameters.
Firebird SQL requires improvements in performance, speed, documentation, error messages, query optimization, and compatibility. Users value its integration, scalability, resource management, and security. The customer service is highly praised, but some users reported mixed experiences with deployment times. Pricing is reasonable with positive ROI. MySQL excels in data management, performance, reliability, compatibility, ease of use, and security. Users appreciate efficient customer service and reasonable pricing. Deployment times vary but can be lengthy. Performance, documentation, support, scalability, and security enhancements are suggested.
Features: Firebird SQL stands out with its seamless integration with various programming languages, scalability for large datasets, and efficient resource management. In contrast, MySQL is valued for its efficiency in handling large amounts of data, compatibility with various platforms, and ease of use.
Pricing and ROI: The setup cost for Firebird SQL is appreciated for its affordability and ease of implementation. On the other hand, MySQL is praised for its reasonable pricing, affordable setup cost, and flexible licensing options., Firebird SQL demonstrates positive ROI based on user feedback, while MySQL is praised for its reliability, cost-effectiveness, scalability, community support, troubleshooting resources, and management of large databases.
Room for Improvement: Firebird SQL faces room for improvement in performance, speed, documentation, error messages, query optimization, and compatibility with other databases. MySQL requires enhancements in performance, documentation, support channels, scalability, compatibility, and security features.
Deployment and customer support: Comparing the reviews, Firebird SQL had mixed reviews ranging from a week to several months for deployment, setup, and implementation, indicating the need to consider context. MySQL had mixed reviews as well, with some users reporting separate durations of several months for deployment and a week for setup, while others mentioned a total duration of a week., Firebird SQL's customer service is highly regarded for its prompt and efficient assistance. Users praise their knowledgeable and friendly support team, resolving issues effectively. MySQL's customer service is also highly praised for prompt and helpful assistance, with a reliable support team offering efficient solutions.
The summary above is based on 32 interviews we conducted recently with Firebird SQL and MySQL users. To access the review's full transcripts, download our report.
"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 most valuable feature of Firebird SQL is the creation of databases."
"The documentation is very well written."
"Firebird SQL is an open-source solution."
"The most valuable feature of the solution is that it is reliable, offers good performance, and is easy to use."
"The solution is very useful for stock management."
"Firebird SQL is an open-source solution and can run on most operating systems, such as Linux, Unix, and Windows."
"MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
"The solution is a small application and is very easy to deploy."
"It is a scalable solution."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
"The IO segregation in CGE is valuable."
"The solution is free to use, which is its most valuable aspect."
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"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."
"On large databases, we have some difficulties."
"It would be good to have more automation and integration with the tools from other vendors."
"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 would be nice to have a graphical user interface to handle the product."
"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."
"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."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"It isn't as reliable as an SQL Server."
"The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform."
"The solution could have better integration and security features."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"Could use some additional JSON query support in the solution."
"In the next release, I would like to see the scalability features improved to allow you to configure it and reduce the complexity with the configuration, making it easier for the end-user to scale. Make it as simple as it can be."
Firebird SQL is ranked 4th in Open Source Databases with 14 reviews while MySQL is ranked 1st in Open Source Databases with 142 reviews. Firebird SQL is rated 7.8, while MySQL is rated 8.2. The top reviewer of Firebird SQL writes "A stable and freely available tool with well-written documents". On the other hand, the top reviewer of MySQL writes "Good beginner base but it should have better support for backups". Firebird SQL is most compared with PostgreSQL, MariaDB, SQLite and Oracle MySQL Cloud Service, whereas MySQL is most compared with PostgreSQL, MariaDB, Teradata, SQL Server and Oracle Database. See our Firebird SQL vs. MySQL 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.
