We performed a comparison between MariaDB 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."One of the great features of MariaDB is its scalability. It's easy to handle even with large databases."
"MariaDB has a straightforward initial setup with easy-to-understand documentation."
"It is an absolutely stable solution."
"I would say that for most use cases it works fine."
"The product has been stable and reliable."
"The solution is very stable. It was originally built under MySQL. It has a similar level of stability."
"The most valuable feature of MariaDB is that it is open-source and we can easily migrate from other databases, such as Oracle to MariaDB."
"The most valuable features of the solution stem from the fact that it is a cloud-based tool, so it is pretty fast."
"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."
"Lacks time series data and additional driving support would be helpful."
"MariaDB could improve by adding support for non-relational structures and new data types."
"I would like to see a better user interface which would make the tool less complex."
"I would like to see more compatibility going forward. This would help if there is a need to change databases."
"The maintenance and performance could be a bit better."
"When we have had issues with accidental computer shutdown or a power outage, our MariaDB database was corrupted."
"It doesn't have the same level of maturity metrics as Postgres."
"Replication could be better, and it's not so simple. It would be better if they had a replication server. It would make things a lot easier. You need to have that replication server, but not in the same server farm. Then there will be a bit of latency between both because you should have one in one city and another one in a different city. That kind of solution should be more baked into every single database today. Mirroring the database in a live environment where any record written on the production server replicates instantly across the fiber on the other server wasn't easy. Many people don't even bother with that, and they just run one server."
"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."
"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."
MariaDB is ranked 3rd in Open Source Databases with 51 reviews while SQLite is ranked 9th in Open Source Databases with 7 reviews. MariaDB is rated 8.2, while SQLite is rated 7.4. The top reviewer of MariaDB writes "Simultaneously use active server capabilities but lacks the maturity ". 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". MariaDB is most compared with SQL Server, Oracle Database, PostgreSQL, Firebird SQL and CockroachDB, whereas SQLite is most compared with Firebird SQL, PostgreSQL, MySQL, Oracle Berkeley DB and LanceDB.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases 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.