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."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 most valuable features of the solution stem from the fact that it is an open-source product and offers its users great online community support."
"MariaDB is easy to install and is stable and scalable."
"I haven't faced any technical issues with the product, and it works fine."
"There is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively."
"MariaDB is a fast and flexible tool."
"I am editing."
"Installation is straightforward."
"The product is lightweight and highly scalable."
"I use Flutter Technology with the JSF plugin."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"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 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."
"Master-master replication is something that needs to be simplified."
"The performance could be a bit better."
"The configuration could be improved. It should be easier."
"Maria DB has to improve from a management perspective."
"When we have had issues with accidental computer shutdown or a power outage, our MariaDB database was corrupted."
"It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved."
"MariaDB could improve by adding support for non-relational structures and new data types."
"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."
"A potential drawback is that the database file stored within the application's local storage could be accessible to users."
"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.