▼ Actions
| |||
PostgreSQL | Couchbase | + Add column | |
---|---|---|---|
Category | |||
Preference | 50% votes | 50% votes | |
Website | postgresql.org | www.couchbase.com | |
License | |||
Design | |||
Database model | |||
Data storage | |||
Embeddable | No | Yes | |
Features | |||
Query language | |||
Data types | |||
Conditional entry updates | Yes | Yes | |
Map and reduce | No | Yes | |
Unicode | Yes | Yes | |
TTL for entries | Yes | Yes | |
Compression | Yes | Yes | |
Integrity | |||
Integrity model | |||
Atomicity | Yes | No | |
Consistency | Yes | Yes | |
Isolation | Yes | Yes | |
Durability (data storage) | Yes | Yes | |
Transactions | Yes | Yes | |
Referential integrity | Yes | No | |
Revision control | Yes | Yes | |
Locking model | |||
Indexing | |||
Secondary Indexes | Yes | Yes | |
Composite keys | Yes | Yes | |
Full text search | Yes | Yes | |
Geospatial Indexes | Yes | Yes | |
Graph support | Conditional | No | |
Distribution | |||
Horizontal scalable | Yes | Yes | |
Replication | Yes | Yes | |
Replication mode | |||
Sharding | Yes | Yes | |
Shared nothing architecture | ? | Yes | |
Restrictions | |||
Value size max. | 1 GB | 20 MB | |
System requirements | |||
Operating system | |||
Native driver | |||
Memory minimum | 32 MB | 4 GB | |
Architecture | |||
Programming language | |||
More | |||
Description | Object-Relational Database Management System | High performance key-value/document store with very flexible,Fast Global Secondary Indexes RAM | |
Brand | |||
Multi-user system | Yes | Yes | |
Extension/Plug-in | Yes | Yes | |
Database | |||
Multilingual content | Yes | Yes | |
Price rating | ★★★★★ | ★★★★☆ | |
WYSIWYG-Editor | Yes | Yes | |
Multiple projects | Yes | ? | |
Standard compliance | Yes | Yes | |
Software distribution | |||
Object-Relational Mapping (ORM) | Yes | Yes | |
Release Date | May 1995 | February 2011 | |
Documentation level | ★★★★★ | ★★★★☆ | |
RESTful | Yes | Yes | |
Lines of code | 839 k | ? | |
Free to use | Yes | Yes | |
Active | Yes | Yes | |
Database Connection Pooling | Yes | Yes | |
Real time analytics | Yes | Yes | |
Creation Date | 1995 | ? | |
Community Driven | Good | Good | |
Web interface | Yes | Yes | |
Data encryption | Yes | Yes | |
API | Good | Good | |
XML Aware | Good | ? | |
Color | ? | ||
Cloud platform support | |||
Online backup | Yes | Yes | |
Partial Index | Yes | ? | |
Function Based Index | Yes | Yes | |
Log | Yes | Yes | |
Implementation flexibility | (83% global votes) | (60% global votes) | |
Download | www.postgresql.org/download/ | www.couchbase.com/download | |
Level of access authorization | |||
Backup functionality | Good | Good | |
Query Cache | Yes | Yes | |
Ease of use | ★★★★★ | ★★★★★ | |
In-Place Update | Yes | Yes | |
Free for commercial use | Yes | Yes | |
Sorts | Yes | Yes | |
Tuneable write concerns | Yes | No | |
Read preferences | Yes | No | |
Open Source | Yes | Yes | |
Op/s | 1 000 005 | 159 997 | |
XQuery Support | Yes | ? | |
Triggers | Yes | No | |
Server side custom code | Yes | ? | |
Perfomance | ★★★★★ | ★★★★☆ | |
Cloud-enabled | Yes | ? | |
Minimal memory footprint | 32 MB | ? | |
Multivariate Testing | Yes | ? | |
Materialized Views | Yes | Yes | |
Pipeline Aggregation | Yes | ? | |
Spring Data Support | Yes | Yes | |
Geospatial | Yes | Yes | |
Text Analytics | Yes | ? | |
Server Side Java Script | Yes | Yes | |
HTML5 Charts | No | ? | |
JSON | Yes | Yes | |
Flexible Table(Schema) | Yes | Yes | |
Geo-distributed | Yes | Yes | |
Batch Loading | Yes | ? | |
ORM Join Support | Yes | Yes | |
Fully Distributed | Yes | Yes | |
Stored Procedure | Yes | No | |
Concurrency | Yes | Yes | |
Auto-Sharding | No | Yes | |
Contributors | 21 | 4 | |
24/7 support | Yes | Yes | |
Free edition | Yes | Yes | |
SQL Queries | Yes | Yes | |
User and Group role based security model | Yes | ? | |
3D Support | No | ? | |
Monitoring UI | Yes | Yes | |
Recursive queries | Yes | ? | |
Network datatype | Yes | ? | |
Windowed aggregate | Yes | ? | |
Online backup (no locking) | Yes | ? | |
CLI` | Yes | Yes | |
Point In Time Recovery | Yes | No | |
Distributed Counter | ? | Yes | |
WSDL | ? | No | |
Key length max | ? | 250 | |
Geographic Replication | ? | Yes | |
Maven support | ? | Yes | |
Cross Domain Testing | ? | Yes | |
Ajax | ? | Yes | |
Max rows in query result | ? | 100 000 | |
Re-Reduce | ? | Yes | |
Clustering over WAN | ? | Yes | |
Near cache | ? | Yes | |
In business since | ? | 2009 | |
Kafka Integration | ? | Yes | |
Multi-statement Transactions | ? | Yes | |
memcached protocol | ? | Yes | |
command-line console | ? | Yes | |
Hadoop Integration | ? | Yes | |
Apache Spark Integration | ? | Yes | |
{{alert('xss');}} | ? | ||
Incremental Backup | ? | Yes | |
Does your boss understand it? | ? | Yes | |
+ Add row | + | + | |
PostgreSQL | Couchbase |
Just click a data cell to edit it.
Take part and share your knowledge with the world.