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 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 documentation is very well written."
"Firebird SQL is an open-source solution."
"The solution is very useful for stock management."
"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."
"The product was easy to use."
"I can deploy it on Linux, Mac OS, and Windows — it's very easy."
"The most valuable feature of Firebird SQL is the creation of databases."
"The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."
"Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language."
"For sure, the solution is very stable."
"MySQL is a light database. It's not very complex. It's easy to develop, easy to maintain, and easy to back up and restore."
"The solution is a small application and is very easy to deploy."
"The initial setup was easy. I work in an agile way, which means coding and deploying quickly."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable."
"It would be good to have more automation and integration with the tools from other vendors."
"Firebird SQL's performance has slowed since Firebird SQL 3 or 3.5 versions, where they developed over-the-wire encryption."
"In the next release, it should support JSON, XML, and replication with third-party tools."
"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."
"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."
"It would be nice to have a graphical user interface to handle the product."
"Database sharing is a capability that Firebird SQL lacks."
"This solution isn't very user-friendly, or intuitive, which could be improved when it is developed."
"I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"At times, the autoscaling does not happen when there is a surge in load."
"In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful."
"The manuals or documentation could be better."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
Firebird SQL is ranked 3rd 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, SAP HANA and SQL Server. 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.