Create entry

PostgreSQL vs. MongoDB

PostgreSQL MongoDB + Add column
Category
Preference (65% global votes) (75% global votes)
Website postgresql.​org www.​monetdb.​org
License
Design
Database model
Data storage
Embeddable No No
Features
Query language
Data types
Conditional entry updates Yes ?
Map and reduce 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 Yes No
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 ?
Restrictions
Value size max. 1 GB 16 MB
System requirements
Operating system
Native driver
Memory minimum 32 MB ?
Architecture
Programming language
More
Description Object-Relational Database Management System Column store pioneer
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Database
Multilingual content Yes ?
Price rating ★★★★★ ★★★★☆
WYSIWYG-Editor Yes ?
Multiple projects Yes ?
Standard compliance Yes Yes
Software distribution
Object-Relational Mapping (ORM) Yes No
Release Date May 1995 September 2008
Documentation level ★★★★★ ★★★☆☆
RESTful Yes ?
Lines of code 839 k ?
Free to use Yes Yes
Active Yes Yes
Database Connection Pooling Yes ?
Real time analytics Yes ?
Community Driven Good Basic
Web interface Yes ?
Data encryption Yes ?
API Good ?
XML Aware Good ?
Color ?
Cloud platform support ?
Online backup Yes Yes
Partial Index Yes ?
Function Based Index Yes ?
Log Yes Yes
Implementation flexibility (83% global votes) (0% global votes)
Download www.​postgresql.​org/​download/​ www.​monetdb.​org/​Downloads
Level of access authorization ?
Backup functionality Good Basic
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★☆
In-Place Update Yes ?
Free for commercial use Yes Yes
Sorts Yes Yes
Tuneable write concerns Yes ?
Read preferences Yes ?
Open Source Yes Yes
Op/s 1 000 005 ?
XQuery Support Yes ?
Triggers Yes ?
Server side custom code Yes ?
Perfomance ★★★★★ ★★★★☆
Cloud-enabled Yes ?
Minimal memory footprint 32 MB ?
Multivariate Testing Yes ?
Materialized Views Yes ?
Pipeline Aggregation Yes ?
Spring Data Support Yes ?
Geospatial Yes Yes
Text Analytics Yes ?
Server Side Java Script Yes ?
HTML5 Charts No ?
JSON Yes Yes
Flexible Table(Schema) Yes ?
Geo-distributed Yes ?
Batch Loading Yes ?
ORM Join Support Yes ?
Fully Distributed Yes ?
Stored Procedure Yes 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 ?
:( No ?
; drop table users; No ?
Point In Time Recovery Yes ?
Can help Modi to make New India ? Yes ?
Predictive Analytics ? Yes
+ Add row ++
PostgreSQL MongoDB
  • 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