|
▼ Actions
| |||
| MongoDB | MySQL | SQLite | |
|---|---|---|---|
| Category | |||
| Preference | 21% votes | 21% votes | 58% votes |
| Website | www.mongodb.org | www.mysql.com | sqlite.org |
| License | |||
| Design | |||
| Database model | |||
| Data storage | |||
| Embeddable | No | Yes | Yes |
| Features | |||
| Query language | |||
| Data types | ? | ? | |
| Conditional entry updates | Yes | Yes | Yes |
| Map and reduce | Yes | No | No |
| Unicode | Yes | Yes | Yes |
| TTL for entries | Yes | No | ? |
| Compression | No | Yes | Yes |
| Integrity | |||
| Integrity model | |||
| Atomicity | Conditional | Yes | Yes |
| Consistency | Yes | Yes | Yes |
| Isolation | No | Yes | Yes |
| Durability (data storage) | Yes | Yes | Yes |
| Transactions | No | Yes | Yes |
| Referential integrity | No | Yes | Yes |
| Revision control | No | No | ? |
| Locking model | ? | ||
| Indexing | |||
| Secondary Indexes | Yes | Yes | ? |
| Composite keys | Yes | Yes | Yes |
| Full text search | Yes | Yes | Yes |
| Geospatial Indexes | Yes | Yes | ? |
| Graph support | No | No | ? |
| Distribution | |||
| Horizontal scalable | Yes | Yes | No |
| Replication | Yes | Yes | No |
| Replication mode | ? | ||
| Sharding | Yes | Yes | No |
| Shared nothing architecture | Yes | Yes | ? |
| Restrictions | |||
| Value size max. | 16 MB | ? | ? |
| System requirements | |||
| Operating system | |||
| Native driver | ? | ||
| Memory minimum | ? | 11 MB | 100 kB |
| Architecture | |||
| Programming language | |||
| More | |||
| Description | Document Oriented Database | Relational database system | ? |
| Multi-user system | Yes | Yes | Yes |
| Standard compliance | No | Yes | ? |
| Software distribution | ? | ||
| Object-Relational Mapping (ORM) | Yes | ? | ? |
| Documentation level | ★★★★★ | ★★★★☆ | ? |
| Distributed Counter | No | ? | ? |
| Free to use | Yes | Yes | Yes |
| Active | Yes | Yes | Yes |
| Database Connection Pooling | Yes | ? | Yes |
| Real time analytics | Yes | Conditional | ? |
| Online backup | No | Yes | ? |
| Partial Index | No | No | ? |
| Function Based Index | No | No | ? |
| Key length max | 255 | ? | ? |
| Log | Yes | ? | ? |
| Download | www.mongodb.org/downloads | dev.mysql.com/downloads/ | sqlite.org/download.html |
| Backup functionality | Basic | Good | ? |
| Query Cache | Yes | Yes | ? |
| In-Place Update | Yes | ? | ? |
| Free for commercial use | Yes | Yes | Yes |
| Sorts | Yes | Yes | ? |
| Capped Collections | Yes | ? | ? |
| Tuneable write concerns | No | ? | ? |
| Read preferences | Yes | ? | ? |
| Brand | ? | ? | |
| Lines of code | ? | 1 100 k | ? |
| Community Driven | ? | Good | ? |
| ACID | ? | ? | Yes |
| Framework | ? | ? | |
| Master-Master Replication | ? | ? | No |
| + Add row | + | + | + |
| MongoDB | MySQL | SQLite | |
Just click a data cell to edit it.
Take part and share your knowledge with the world.