We performed a comparison between MongoDB 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."The most valuable features of MongoDB are we have a lot of documentation and SQL-based applications that run on it."
"It is very fast - faster than an SQL or MySQL Server."
"I value the API integrations."
"I think that MongoDB isn't too structured, and that's good for our technical team because they are able to search through the database better than if they are using SQL Server."
"It's super easy to develop a couple of solutions for clients with MongoDB, like a quick web page with no clear data structure that they need to spin up quickly to validate some sort of MDTP."
"My impression is that the initial setup is straightforward."
"The clustering is very good. It allows us to have high availability."
"The installation is very stable."
"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."
"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."
"I haven't encountered any problems in my use cases. So, it has been a stable product for me."
"We'd like information about client onboarding experience and success stories. It would help to have something to show to internal stakeholders."
"MongoDB can improve large-size video or media frame operations. There are a lot of customers who want to upload media frames and video games but there is some difficulty. In MongoDB, we are looking out for solutions that are for large-size media files that can be saved and navigated efficiently."
"It could be much more flexible like SequoiaDB. I would like to see more flexibility in the next release, especially when working with Microsoft Windows. A lot of people struggle with MongoDB because of their Windows versions. But Linux is faultless and mostly runs nicely."
"The MongoDB documentation can be a little complicated sometimes."
"I have found the solution difficult to operate as an administrator."
"It is important to note that MongoDB has limitations since it can only be used for specific use cases. For example, for master data, I would want to pick keys using an RDBMS, but for attachments, I would choose MongoDB."
"They could provide more documentation and examples for adding pipeline stages."
"It would help if MongoDB offered a light solution for small projects."
"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."
"It could have a user-friendly GUI and better intelligence features."
"The performance could be better."
MongoDB is ranked 5th in Open Source Databases with 69 reviews while SQLite is ranked 9th in Open Source Databases with 7 reviews. MongoDB is rated 8.2, while SQLite is rated 7.4. The top reviewer of MongoDB writes "Lightweight with good flexibility and very fast performance for searching data". 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". MongoDB is most compared with InfluxDB, Couchbase, ScyllaDB, Oracle NoSQL and Cassandra, whereas SQLite is most compared with Firebird SQL, MariaDB, 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.