We performed a comparison between Firebird SQL, PostgreSQL, and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."Robustness is the absolutely main feature."
"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 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."
"The documentation is very well written."
"Firebird SQL is an open-source solution."
"The most valuable feature of Firebird SQL is the creation of databases."
"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 most valuable features are the price, stability, it is scalable and is used by our clients in small business environments, and it is a simple product to use."
"Clustering will be the number 1 feature. It is also open-source so it is free. It can also be clustered, to allow fault tolerance."
"The initial setup is quick and easy."
"PostgreSQL is very powerful, easy to manage, and has many features."
"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
"It is easy to install and easy to manage. There is no license on it, so it is free. There is high compatibility with Oracle, and there are many tools for the migration of data from Oracle to Postgre."
"PostgreSQL makes it very adaptable to several descriptions of a record. Instead of having several tables or several relations for one entity, I can adapt this entity. It can be a multiform entity. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person."
"The PostgreSQL database is similar to the SQL Server but has a slightly different technology that has similar resources as well. If the customer has the confidence using SQL Server, they will be fairly comfortable using this solution."
"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."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"I use Flutter Technology with the JSF plugin."
"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 don't think the solution is very scalable, because the scalability of the performance when using more than one process is not very good."
"It is not easy to integrate the tool with Visual Studio."
"Firebird SQL's performance has slowed since Firebird SQL 3 or 3.5 versions, where they developed over-the-wire encryption."
"It would be interesting if they added functionality with redundancy, reputation, and variability."
"It would be nice to have a graphical user interface to handle the product."
"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."
"In the next release, it should support JSON, XML, and replication with third-party tools."
"Database sharing is a capability that Firebird SQL lacks."
"The scalability is limited."
"If it was free to use, it would be the perfect solution."
"It is possible that in the newer version this has been addressed, but I would like the deployment in microservices architecture could be improved."
"Instead of the installation agent downloading all the packages for the install, it should allow the user to download the packages separately on their own to do the install."
"I have noticed that user and access management should be improved."
"The interface climate could be better."
"It could be improved by using parallelization. You want basically, distributed computing."
"There could be a plugin to distribute the data on servers for the product."
"The performance could be better."
"It could have a user-friendly GUI and better intelligence features."
"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."
"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."
