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."We are happy with the event capabilities of Firebird SQL database. We can raise events from it and display them in our application."
"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."
"I can deploy it on Linux, Mac OS, and Windows — it's very easy."
"Robustness is the absolutely main feature."
"The product was easy to use."
"The documentation is very well written."
"The most valuable feature of the solution is that it is reliable, offers good performance, and is easy to use."
"I like that you can move any relational database from Oracle to PostgreSQL. I also like that it's pretty stable."
"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."
"It is very simple to manage."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"We are able to create many different types of jobs and items with this solution making it one of the most valuable features."
"The main value is that it is open source, which means it is free. Our organization has the initiative to go to open source to cut down on cost. Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. So, there is a big push to go to Postgres."
"It is a pretty comprehensive database system. Its performance is good, and it does what it is supposed to do. It also integrates very well."
"The database has excellent performance."
"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."
"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 haven't encountered any problems in my use cases. So, it has been a stable product for me."
"It would be nice to have a graphical user interface to handle the product."
"Firebird SQL's performance has slowed since Firebird SQL 3 or 3.5 versions, where they developed over-the-wire encryption."
"Database sharing is a capability that Firebird SQL lacks."
"This solution isn't very user-friendly, or intuitive, which could be improved when it is developed."
"The security of the users could improve in Firebird SQL."
"It would be interesting if they added functionality with redundancy, reputation, and variability."
"In the next release, it should support JSON, XML, and replication with third-party tools."
"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."
"We have to set up event API, which takes a lot of events from the user."
"It would be good to have machine learning functionality in this solution, similar to Microsoft SQL Server and other solutions. Machine learning capability for a basic level or a common user would be useful. It can also have good reporting capabilities."
"They need to have a better graphical interface. There is a tool called pgAdmin 4 that they use, which is free. It is written in Java, and it is slow. They need to have a better product that is similar to Toad for Oracle, but, of course, it is hard to get something that's really great and free. Other than that, it is great."
"As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself."
"PostgreSQL’s performance could be improved."
"The solution could improve the integration."
"It could be improved by using parallelization. You want basically, distributed computing."
"When you get a large number of records in a database and start doing various queries, it can adversely impact the performance of the live running systems. That's an area we continue to look at and mean to improve, but it is not only because of PostgreSQL. It is also because of the way the schemas are put together, and certain events are triggered. So, it is because of both parties."
"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."
"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."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"It could have a user-friendly GUI and better intelligence features."