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 most valuable feature of the solution is that it is reliable, offers good performance, and is easy to use."
"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."
"Robustness is the absolutely main feature."
"The documentation is very well written."
"I can deploy it on Linux, Mac OS, and Windows — it's very easy."
"We are happy with the event capabilities of Firebird SQL database. We can raise events from it and display them in our application."
"The product was easy to use."
"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."
"Support for enterprise-grade features like clustering, master-slave replication, even Sharding (to some extent) which is an advanced feature."
"The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it."
"The most valuable feature of MySQL is auto-scaling."
"I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures."
"For sure, the solution is very stable."
"The solution has been very easy to scale so far."
"MySQL is a scalable tool. Scalability-wise, I rate the solution a nine out of ten...The solution's technical support is good. I rate the technical support a nine out of ten."
"It is very easy to install and has all basic database features."
"The security of the users could improve in Firebird SQL."
"It would be interesting if they added functionality with redundancy, reputation, and variability."
"It is not easy to integrate the tool with Visual Studio."
"This solution isn't very user-friendly, or intuitive, which could be improved when it is developed."
"In the next release, it should support JSON, XML, and replication with third-party tools."
"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."
"Database sharing is a capability that Firebird SQL lacks."
"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."
"As an open-source product, there isn't really any technical support available if you get into trouble or have issues."
"The workbench could be improved. In particular, error messages can be improved, which are horrific and completely unhelpful. I'd like to see improved parsing of errors. When you write SQL and it crashes, it usually is something completely irrelevant and not helpful. I've started to use GPT 3.5 for finding out how to do things. I got to do something a bit different, and that I found to be very useful. If there was some way to tie it into one of the new AI tools, that would probably be a good idea."
"Clusters are hard to perform so we use no SQL alternates like MongoDB."
"Improvements are required in character set support, scalability, and big data sets."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"It isn't as reliable as an SQL Server."
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."
"It could be a little bit simpler to use."
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.