We performed a comparison between Firebird SQL and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about SAP, Oracle, Firebird and others in Embedded Database."The product was easy to use."
"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."
"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."
"Firebird SQL is an open-source solution."
"I find the ease of deployment to be the most valuable aspect of this solution."
"I can deploy it on Linux, Mac OS, and Windows — it's very easy."
"Robustness is the absolutely main feature."
"The solution is very useful for stock management."
"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."
"The product is lightweight and highly scalable."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"I use Flutter Technology with the JSF plugin."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"It would be good to have more automation and integration with the tools from other vendors."
"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."
"This solution isn't very user-friendly, or intuitive, which could be improved when it is developed."
"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."
"On large databases, we have some difficulties."
"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."
"It would be nice to have a graphical user interface to handle the product."
"It is not easy to integrate the tool with Visual Studio."
"The performance could be better."
"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."
"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."
"It could have a user-friendly GUI and better intelligence features."
Firebird SQL is ranked 3rd in Embedded Database with 14 reviews while SQLite is ranked 4th in Embedded Database with 7 reviews. Firebird SQL is rated 7.8, while SQLite is rated 7.4. 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 "Good for scenarios where you need offline capabilities within your mobile applications, stable and useful plugin". 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 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.