MongoDB vs SQLite

MongoDB
MongoDB

14.5K
2.7K
3.8K
SQLite
SQLite

2.9K
62
504
Add tool

MongoDB vs SQLite: What are the differences?

MongoDB: The database for giant ideas. MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding; SQLite: A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

MongoDB and SQLite can be categorized as "Databases" tools.

"Document-oriented storage", "No sql" and "Ease of use" are the key factors why developers consider MongoDB; whereas "Lightweight", "Portable" and "Simple" are the primary reasons why SQLite is favored.

MongoDB is an open source tool with 16.3K GitHub stars and 4.1K GitHub forks. Here's a link to MongoDB's open source repository on GitHub.

Uber Technologies, Lyft, and Codecademy are some of the popular companies that use MongoDB, whereas SQLite is used by Intuit, Coderus, and Infoshare. MongoDB has a broader approval, being mentioned in 2189 company stacks & 2218 developers stacks; compared to SQLite, which is listed in 314 company stacks and 477 developer stacks.

- No public GitHub repository available -

What is MongoDB?

MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.

What is SQLite?

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

Want advice about which of these to choose?Ask the StackShare community!

Why do developers choose MongoDB?
Why do developers choose SQLite?
What are the cons of using MongoDB?
What are the cons of using SQLite?
What companies use MongoDB?
What companies use SQLite?
What are some alternatives to MongoDB and SQLite?
Amazon DynamoDB
All data items are stored on Solid State Drives (SSDs), and are replicated across 3 Availability Zones for high availability and durability. With DynamoDB, you can offload the administrative burden of operating and scaling a highly available distributed database cluster, while paying a low price for only what you use.
Couchbase
Developed as an alternative to traditionally inflexible SQL databases, the Couchbase NoSQL database is built on an open source foundation and architected to help developers solve real-world problems and meet high scalability demands.
MySQL
The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
PostgreSQL
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
Cassandra
Partitioning means that Cassandra can distribute your data across multiple machines in an application-transparent matter. Cassandra will automatically repartition as machines are added and removed from the cluster. Row store means that like relational databases, Cassandra organizes data by rows and columns. The Cassandra Query Language (CQL) is a close relative of SQL.
See all alternatives
What tools integrate with MongoDB?
What tools integrate with SQLite?
    No integrations found
      No integrations found
      Decisions about MongoDB and SQLite
      MongoDB

      I starting using MongoDB because it was much easier to implement in production then hosted SQL, and found that a lot of the limitation you think of from a document store vs a relational database were overcome by connecting the application to a graphql API, making retrieval seamless. Mongos latest upgrades as well as Stitch and Mongo mobile make it a perfect fit especially if your application will be cross platform web and mobile.

      See more
      Mauro Bennici
      Mauro Bennici
      CTO at You Are My GUide · | 7 upvotes · 5.7K views
      atYou Are My GUideYou Are My GUide
      MongoDB
      TimescaleDB
      PostgreSQL

      PostgreSQL plus TimescaleDB allow us to concentrate the business effort on how to analyze valuable data instead of manage them on IT side. We are now able to ingest thousand of social shares "managed" data without compromise the scalability of the system or the time query. TimescaleDB is transparent to PostgreSQL , so we continue to use the same SQL syntax without any changes. At the same time, because we need to manage few document objects we dismissed the MongoDB cluster.

      See more
      Daniel Quinn
      Daniel Quinn
      Senior Developer at Founders4Schools · | 2 upvotes · 3K views
      atThe Paperless ProjectThe Paperless Project
      PostgreSQL
      SQLite

      SQLite is a tricky beast. It's great if you're working single-threaded, but a Terrible Idea if you've got more than one concurrent connection. You use it because it's easy to setup, light, and portable (it's just a file).

      In Paperless, we've built a self-hosted web application, so it makes sense to standardise on something small & light, and as we don't have to worry about multiple connections (it's just you using the app), it's a perfect fit.

      For users wanting to scale Paperless up to a multi-user environment though, we do provide the hooks to switch to PostgreSQL .

      See more
      Interest over time
      Reviews of MongoDB and SQLite
      No reviews found
      How developers use MongoDB and SQLite
      Avatar of Tarun Singh
      Tarun Singh uses MongoDBMongoDB

      Used MongoDB as primary database. It holds trip data of NYC taxis for the year 2013. It is a huge dataset and it's primary feature is geo coordinates with pickup and drop off locations. Also used MongoDB's map reduce to process this large dataset for aggregation. This aggregated result was then used to show visualizations.

      Avatar of Trello
      Trello uses MongoDBMongoDB

      MongoDB fills our more traditional database needs. We knew we wanted Trello to be blisteringly fast. One of the coolest and most performance-obsessed teams we know is our next-door neighbor and sister company StackExchange. Talking to their dev lead David at lunch one day, I learned that even though they use SQL Server for data storage, they actually primarily store a lot of their data in a denormalized format for performance, and normalize only when they need to.

      Avatar of Foursquare
      Foursquare uses MongoDBMongoDB

      Nearly all of our backend storage is on MongoDB. This has also worked out pretty well. It's enabled us to scale up faster/easier than if we had rolled our own solution on top of PostgreSQL (which we were using previously). There have been a few roadbumps along the way, but the team at 10gen has been a big help with thing.

      Avatar of Romans Malinovskis
      Romans Malinovskis uses SQLiteSQLite

      We build queries in PHP with DSQL that work with SQLite. We also have SQLite data controller, so that you can build SQLite-based models.

      Avatar of Coolfront Technologies
      Coolfront Technologies uses SQLiteSQLite

      Used during the "build process" of Coolfront Mobile's Flat rate search engine database. Flat rate data that resides in Salesforce is transformed using SQLite into a format that is usable for our mobile Flat rate search engine (AKA: Charlie).

      Avatar of AngeloR
      AngeloR uses MongoDBMongoDB

      We are testing out MongoDB at the moment. Currently we are only using a small EC2 setup for a delayed job queue backed by agenda. If it works out well we might look to see where it could become a primary document storage engine for us.

      Avatar of Sripathi Krishnan
      Sripathi Krishnan uses SQLiteSQLite

      RDBTools is a self-hosted application, and it is important that the installation process is simple. With SQLite, we create a new database file for every analysis. Once the analysis is done, the SQLite file can be thrown away easily.

      Avatar of Matt Welke
      Matt Welke uses MongoDBMongoDB

      Used for proofs of concept and personal projects with a document data model, especially with need for strong geographic queries. Often not chosen in long term apps due to chance data model can end up relational as needs develop.

      Avatar of Perljobs.Ru
      Perljobs.Ru uses SQLiteSQLite

      All the dynamic data (i.e.: jobs) is stored in a simple SQLite database.

      Все динамические данные (вакансии) хранятся в простой SQLite БД.

      Avatar of A. M. Douglas
      A. M. Douglas uses SQLiteSQLite

      There's really no call for something heavier for this site. SQLite is simple, easy to use and quite reliable given its age.

      How much does MongoDB cost?
      How much does SQLite cost?
      Pricing unavailable