We performed a comparison between MariaDB, PostgreSQL, and SQLite based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases."A valuable feature is that we can use it for quite a few things, all the things you'd expect from a server—along the lines of Linux's Lightweight Directory."
"The speed and functionality are the most valuable features."
"The most valuable feature of MariaDB is the replication mode."
"I haven't faced any technical issues with the product, and it works fine."
"What I like best about MariaDB is that it is open-source and reliable."
"The solution is very easy to implement."
"Easy to use and available in most environments."
"The most valuable feature of MariaDB is the power it provides. It is a powerful solution."
"The product is very similar to the SQL Server."
"It's quite scalable."
"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 has completely met our needs. It works, and it is robust. We haven't had any problems with what PostgreSQL does for us and the way it does it. That's why we've been using it for so long. We understand it, and it does the job."
"It is very simple to manage."
"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."
"The community support and the open-source community for it are good."
"With the database, you can provide a multi-component at the same service with the same performance, scalability, or all those things."
"It was a bit easy to use compared to other tools. It's simple. I found it pretty easy to execute my SQL queries."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"The product is lightweight and highly scalable."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"I use Flutter Technology with the JSF plugin."
"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 would like to see a better user interface which would make the tool less complex."
"It does not have tools for debugging procedures and functions."
"MariaDB's GUI is an area with certain shortcomings where improvements are required."
"It would be helpful if I could specify multiple drives for the database storage."
"In future releases, mainly the addition of security features would be beneficial for MariaDB."
"The price could be less expensive."
"It doesn't have the same level of maturity metrics as Postgres."
"The interface should be more user-friendly. It should be able to connect directly to the database and Interact with it without having to use commands. It needs better integration."
"Integration with other platforms could be improved."
"There are several features I would like to improve that aren't working as expected. It's likely that the latest version is doing something that was missed in the previous versions. For example, the output parameters — the stored procedures — is something new in PostgreSQL that Firebird has already had for a long time."
"It could be more secure."
"There are some products out there that have a slightly different method of implementation for the SQL language. Some of those are slightly better in some areas, and PostgreSQL is slightly better in some areas. I would probably like to match all of those products together. It is just down to the functionality. For example, Oracle has a number of options within SQL that are outside of what you would class as the SQL standard. PostgreSQL misses some of those, but PostgreSQL does other things that are better than what Oracle does. I would like to merge those two products so that there is a certain amount of functionality in a single product."
"We often find the solution's datetime datatype challenging."
"It still needs to be more mature and have some backup feature. We are normally dealing with Oracle's data, and we have very strong online tools to back up the data and do other things. PostgreSQL still needs to do more in this area as well as in the high availability area. There are many external tools that you can use for PostgreSQL's high availability, but there is no embedded tool within PostgreSQL for high availability. It could have a feature similar to Oracle for working on a distributed system. It can have some scripts to improve the monitoring and some tools to do performance analysis. We have a workaround for most of such requirements except for the support for a distributed system, which is very difficult to have. This area should be included in the core of the database itself."
"PostgreSQL’s performance could be improved."
"We have to set up event API, which takes a lot of events from the user."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"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."
"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."
"Compared to other tools, the performance was less effective than that of Microsoft Access."