|
▼ 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 | |
| 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) | (57% 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 | Yes | |
| Read preferences | Yes | Yes | |
| 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 | Yes | |
| 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.