We performed a comparison between Firebird SQL and SQLite based on real PeerSpot user reviews.
Find out in this report how the two Embedded Database solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The product was easy to use."
"We are happy with the event capabilities of Firebird SQL database. We can raise events from it and display them in our application."
"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."
"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."
"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."
"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 most valuable feature of Firebird SQL is the creation of databases."
"It was a bit easy to use compared to other tools. It's simple. I found it pretty easy to execute my SQL queries."
"Sometimes, you want data to persist within the app even when there's no internet connectivity. To avoid showing blank screens, we can use SQLite to store data locally and then sync it with the cloud database when connectivity is restored."
"I use Flutter Technology with the JSF plugin."
"The product is lightweight and highly scalable."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"The security of the users could improve in Firebird SQL."
"Database sharing is a capability that Firebird SQL lacks."
"On large databases, we have some difficulties."
"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."
"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."
"It would be interesting if they added functionality with redundancy, reputation, and variability."
"It could have a user-friendly GUI and better intelligence features."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"I primarily use SQLite for small-scale applications due to its limitations in storing large amounts of data. For larger-scale projects, I typically opt for MySQL or other alternatives. Storing a large number of dates in SQLite can significantly impact its performance."
"The performance could be better."
"There are some difficulties on the server side. When syncing data with databases like SQL Server or Oracle, SQLite requires a kind of double effort."
"Compared to other tools, the performance was less effective than that of Microsoft Access."
Firebird SQL is ranked 3rd in Embedded Database with 14 reviews while SQLite is ranked 4th in Embedded Database with 8 reviews. Firebird SQL is rated 7.8, while SQLite is rated 7.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 SQLite writes " Pretty easy to execute my SQL queries but issues while uploading and importing my dataset". Firebird SQL is most compared with MySQL, PostgreSQL, MariaDB and Oracle MySQL Cloud Service, whereas SQLite is most compared with MariaDB, PostgreSQL, MySQL, Oracle Berkeley DB and LanceDB. See our Firebird SQL vs. SQLite report.
See our list of best Embedded Database vendors and best Open Source Databases vendors.
We monitor all Embedded Database 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.