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.
"The solution is very useful for stock management."
"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 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."
"Robustness is the absolutely main feature."
"The most valuable feature of Firebird SQL is the creation of databases."
"The product was easy to use."
"The most valuable feature is the ease of use."
"However, it is easy to scale MySQL using the functions provided with the product."
"It has a community version. When I have to create a new database, I have no problems with licenses."
"It was easy to install."
"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."
"MySQL gives us all of the critical features that we need in a database, but without the costs."
"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."
"The most valuable features are that it's free and the documentation is good."
"Firebird SQL's performance has slowed since Firebird SQL 3 or 3.5 versions, where they developed over-the-wire encryption."
"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."
"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."
"In the next release, it should support JSON, XML, and replication with third-party tools."
"It is not easy to integrate the tool with Visual Studio."
"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."
"Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."
"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."
"The product is a little bit complex and it is difficult to find sufficient documentation."
"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 GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL."
"There should be more tools to manage the on-premises version and more automation features."
"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."
"MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers."
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.