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."What I like best about MariaDB is that it is open-source and reliable."
"I am editing."
"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."
"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."
"From the user's perspective, the performance of the columnar queries is very good in terms of the database when comparing it to the Oracle, and MySQL."
"The most valuable feature is that it uses multiple cores, which is better than some of the other databases."
"MariaDB performs well as the backend database for our cloud-based telephony solution."
"MariaDB has a straightforward initial setup with easy-to-understand documentation."
"I use Flutter Technology with the JSF plugin."
"The product is lightweight and highly scalable."
"SQLite’s most valuable feature is the ability to store granular-level backups of databases."
"Maria DB has to improve from a management perspective."
"MariaDB can improve by adding more features. There are a lot of features, which are available in Oracle, and which are not available in MariaDB. We hope they will introduce the features soon."
"The performance could be a bit better."
"MariaDB's GUI is an area with certain shortcomings where improvements are required."
"MariaDB doesn't handle long or complex SQL queries quite as well as Oracle Database."
"The price could be less expensive."
"One feedback I can quickly provide is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively."
"I'd like to see improved materialized views, like the ability to save select queries. This feature is missing in MariaDB compared to other relational databases like Oracle and SQL Server."
"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."
MariaDB is ranked 3rd in Open Source Databases with 51 reviews while SQLite is ranked 9th in Open Source Databases with 5 reviews. MariaDB is rated 8.0, while SQLite is rated 7.6. 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 "Helps to access data directly from my local storage or databases". MariaDB is most compared with SQL Server, PostgreSQL, Oracle Database, MySQL and CockroachDB, whereas SQLite is most compared with Firebird SQL, PostgreSQL, MySQL and Oracle Berkeley DB.
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.