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."I like the global transaction IDs (GTIDs) feature. It's quite reliable for replication between a master and a replica server, and it's a feature that MySQL also has but implemented differently."
"It's a very easy product to set up."
"This solution is user-friendly."
"I am editing."
"The most valuable feature of MariaDB is the power it provides. It is a powerful solution."
"The most valuable feature is that it uses multiple cores, which is better than some of the other databases."
"We use MariaDB for identity provider services. Most of the things that we are doing are deployed in the container mode. All such solutions require a database, and MariaDB is easier to use for these kinds of deployments."
"It's open source."
"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 use Flutter Technology with the JSF plugin."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"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."
"The license should be cheaper and closer to that offered by MySQL, Oracle and other products."
"The scaling for database online transactions needs improvement."
"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."
"The solution should do some fine-tuning on maybe the transaction per second so that users can get more than they can on the Microsoft SQL Server."
"I am editing."
"With respect to clustering and the master-slave configuration, sometimes the slave goes out of synch."
"I would like to see a better user interface which would make the tool less complex."
"It's not very stable. It needs improvement."
"It could have a user-friendly GUI and better intelligence features."
"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."
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.