Create entry

MongoDB vs. PostgreSQL

MongoDB PostgreSQL + Add column
Category
Preference (75% global votes) (65% global votes)
Website www.​monetdb.​org postgresql.​org
License
Design
Database model
Data storage
Embeddable No No
Features
Query language
Data types
Conditional entry updates ? Yes
Map and reduce Yes No
Unicode ? Yes
TTL for entries ? Yes
Compression ? Yes
Integrity
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions No Yes
Referential integrity Yes Yes
Revision control ? Yes
Locking model
Indexing
Secondary Indexes Yes Yes
Composite keys ? Yes
Full text search ? Yes
Geospatial Indexes Yes Yes
Graph support ? Conditional
Distribution
Horizontal scalable ? Yes
Replication ? Yes
Replication mode ?
Sharding Yes Yes
Restrictions
Value size max. 16 MB 1 GB
System requirements
Operating system
Native driver
Memory minimum ? 32 MB
Architecture
Programming language
More
Description Column store pioneer Object-Relational Database Management System
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Database
Price rating ★★★★☆ ★★★★★
Standard compliance Yes Yes
Software distribution
Object-Relational Mapping (ORM) No Yes
Release Date September 2008 May 1995
Documentation level ★★★☆☆ ★★★★★
Free to use Yes Yes
Active Yes Yes
Community Driven Basic Good
Online backup Yes Yes
Log Yes Yes
Download www.​monetdb.​org/​Downloads www.​postgresql.​org/​download/​
Backup functionality Basic Good
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★★★
Free for commercial use Yes Yes
Sorts Yes Yes
Open Source Yes Yes
Perfomance ★★★★☆ ★★★★★
Predictive Analytics Yes ?
Geospatial Yes Yes
JSON Yes Yes
Stored Procedure Yes Yes
Multilingual content ? Yes
WYSIWYG-Editor ? Yes
Multiple projects ? Yes
RESTful ? Yes
Lines of code ? 839 k
Database Connection Pooling ? Yes
Real time analytics ? Yes
Creation Date ? 1995
Web interface ? Yes
Data encryption ? Yes
API ? Good
XML Aware ? Good
Color ?
Cloud platform support ?
Partial Index ? Yes
Function Based Index ? Yes
Implementation flexibility (0% global votes) (77% global votes)
Level of access authorization ?
In-Place Update ? Yes
Tuneable write concerns ? Yes
Read preferences ? Yes
Op/s ? 1 000 005
XQuery Support ? Yes
Triggers ? Yes
Server side custom code ? Yes
Cloud-enabled ? Yes
Minimal memory footprint ? 32 MB
Multivariate Testing ? Yes
Materialized Views ? Yes
Pipeline Aggregation ? Yes
Spring Data Support ? Yes
Text Analytics ? Yes
Server Side Java Script ? Yes
HTML5 Charts ? No
Flexible Table(Schema) ? Yes
Geo-distributed ? Yes
Batch Loading ? Yes
ORM Join Support ? Yes
Fully Distributed ? Yes
Concurrency ? Yes
Auto-Sharding ? No
Contributors ? 21
24/7 support ? Yes
Free edition ? Yes
SQL Queries ? Yes
User and Group role based security model ? Yes
3D Support ? No
Monitoring UI ? Yes
Recursive queries ? Yes
Network datatype ? Yes
Windowed aggregate ? Yes
Online backup (no locking) ? Yes
CLI` ? Yes
Point In Time Recovery ? Yes
Performance ? 9 001
+ Add row ++
MongoDB PostgreSQL
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    darker
    = better
    Legend
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.

Type
Review
Comment