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, MariaDB and others in Open Source Databases."Easy to use and available in most environments."
"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."
"MariaDB can solve things better than MySQL. Maria DB has better performance than MySQL."
"Installation is straightforward."
"The most valuable feature of MariaDB is the power it provides. It is a powerful solution."
"Great monitoring and performance stability."
"MariaDB is stable and the initial setup is straightforward."
"I am editing."
"We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance."
"Postgres has some functions called JSONB aggregators or other aggregators, which are quite useful."
"What I like is that it's quite powerful in terms of performance."
"This is an open-source solution, operates at a high speed, and supports more than one SQL language."
"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."
"Initial setup is simple."
"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 database has excellent performance."
"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."
"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."
"I would like to see a better user interface which would make the tool less complex."
"The maintenance and performance could be a bit better."
"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 product needs more features and more functionality. It's imperative that it supports more platforms, and supports more operating systems."
"I am editing."
"Document caching is an area of concern in the product, where improvements are required to help MariaDB improve on the previous queries as they are retained, and you can roll back to them."
"The solution could improve the integration."
"We often find the solution's datetime datatype challenging."
"PostgreSQL could improve by providing a geographical solution for tracking trucks and people in the field. They might already have features similar to this and I have not found them. I haven't done research about this topic."
"If it was free to use, it would be the perfect solution."
"PostgreSQL is a stable system, but from a security point of view, it still needs improvement."
"It could be improved by using parallelization. You want basically, distributed computing."
"PostgreSQL could improve by adding data warehousing tools."
"I have noticed that user and access management should be improved."
"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."
"The performance could be better."
"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."
"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."