DB-EnginesExtremeDB Active Replication featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Amazon Redshift vs. Couchbase vs. PostgreSQL

System Properties Comparison Amazon Redshift vs. Couchbase vs. PostgreSQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Redshift  Xexclude from comparisonCouchbase infoOriginally called Membase  Xexclude from comparisonPostgreSQL  Xexclude from comparison
DescriptionLarge scale data warehouse service for use with business intelligence toolsJSON-based document store derived from CouchDB with a Memcached-compatible interfaceWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL
Primary database modelRelational DBMSDocument storeRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.
Secondary database modelsKey-value store infooriginating from the former Membase product and supporting the Memcached protocol
Spatial DBMS infousing the Geocouch extension
Document store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score22.50
Rank#32  Overall
#18  Relational DBMS
Score30.23
Rank#26  Overall
#4  Document stores
Score559.25
Rank#4  Overall
#4  Relational DBMS
Websiteaws.amazon.com/­redshiftwww.couchbase.comwww.postgresql.org
Technical documentationdocs.aws.amazon.com/­redshiftdocs.couchbase.comwww.postgresql.org/­docs
DeveloperAmazon (based on PostgreSQL)Couchbase, Inc.PostgreSQL Global Development Group infowww.postgresql.org/­developer
Initial release201220111989 info1989: Postgres, 1996: PostgreSQL
Current releaseServer: 6.5, January 2020; Mobile: 2.7, January 2020; Couchbase Autonomous Operator: 1.2, May 201913.2 , February 2021
License infoCommercial or Open SourcecommercialOpen Source infoApache version 2; Commercial licenses also availableOpen Source infoBSD
Cloud-based only infoOnly available as a cloud serviceyesnono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Couchbase Cloud: Deploy, manage, and operate Couchbase in a few clicksScaleGrid for PostgreSQL: Fully managed PostgreSQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageCC, C++, Go and ErlangC
Server operating systemshostedLinux
OS X
Windows
FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Data schemeyesschema-freeyes
Typing infopredefined data types such as float or dateyesyes infoString, Boolean, Numberyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.noyes infospecific XML-type available, but no XML query functionality.
Secondary indexesrestrictedyesyes
SQL infoSupport of SQLyes infodoes not fully support an SQL-standardDeclarative query language (N1QL) that extends ANSI SQL to JSON. First commercial implementation of SQL++.yes infostandard with numerous extensions
APIs and other access methodsJDBC
ODBC
Native language bindings for CRUD, Query, Search and Analytics APIsADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesAll languages supporting JDBC/ODBC.Net
C
Clojure
ColdFusion
Erlang
Go
Java
JavaScript infoNode.js
Perl
PHP
Python
Ruby
Scala
Tcl
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Server-side scripts infoStored proceduresuser defined functions infoin PythonFunctions and timers in JavaScriptuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.
Triggersnoyes infovia the TAP protocolyes
Partitioning methods infoMethods for storing different data on different nodesShardingShardingpartitioning by range, list and (since PostgreSQL 11) by hash
Replication methods infoMethods for redundantly storing data on multiple nodesyesMulti-source replication infoincluding cross data center replication
Source-replica replication
Source-replica replication infoother methods possible by using 3rd party extensions
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyesno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyEventual Consistency
Immediate Consistency infoselectable on a per-operation basis
Immediate Consistency
Foreign keys infoReferential integrityyes infoinformational only, not enforced by the systemnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes infoEphemeral bucketsno
User concepts infoAccess controlfine grained access rights according to SQL-standardUser and Administrator separation with password-based and LDAP integrated Authenticationfine grained access rights according to SQL-standard
More information provided by the system vendor
Amazon RedshiftCouchbase infoOriginally called MembasePostgreSQL
Specific characteristicsDeveloped as an alternative to traditionally inflexible relational databases, Couchbase...
» more
Competitive advantagesCouchbase was architected with several differentiated capabilities: Shared-nothing,...
» more
Typical application scenariosCustomer 360 for user profile, session store and data aggregation (Comcast, Equifax,...
» more
Key customersAmadeus, AT&T, BD (Becton, Dickinson and Company), Carrefour, Cisco, Comcast, Disney,...
» more
Market metricsNamed a leader in the Forrester Wave™: Big Data NoSQL, Q1 2019 Over 10M downloads...
» more
Licensing and pricing modelsThe Community Edition (CE) of Couchbase Server and Couchbase Mobile are available...
» more

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
» more
CData: Connect to Big Data & NoSQL through standard Drivers.
» more
ClusterControl: the only management system you’ll ever need to take control of your open source database infrastructure.
» more

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

Fivetran: Quickly and easily centralize your on-premise and cloud databases.
» more

EDB: Helping organizations get the most from PostgreSQL, Oracle Migration, High Availability, Security
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

CYBERTEC is your professional partner for PostgreSQL services and Data Science since 2000. With offices in Austria, Uruguay, Estonia, Poland, South Africa and Switzerland, CYBERTEC operates worldwide and is here for you 24/7!
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Amazon RedshiftCouchbase infoOriginally called MembasePostgreSQL
DB-Engines blog posts

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Couchbase climbs up the DB-Engines Ranking, increasing its popularity by 10% every month
2 June 2014, Matthias Gelbmann

show all

PostgreSQL is the DBMS of the Year 2020
4 January 2021, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

AQUA for Amazon Redshift goes GA
14 April 2021, ZDNet

Amazon brings more compute to RedShift nodes with AQUA – Blocks and Files
15 April 2021, Blocks and Files

Datacoral Launches Integration with Amazon Redshift Console
21 April 2021, PRNewswire

SnapLogic Adds Support for Amazon Redshift Console Program
23 April 2021, Database Trends and Applications

AWS launches AQUA for Amazon Redshift to bring compute to the storage layer
16 April 2021, Help Net Security

provided by Google News

Couchbase Details Its Distributed ACID Transaction Architecture
14 April 2021, InfoQ.com

RavenDB outperforms Couchbase, saving 85% of storage budget
14 April 2021, TechGenix

Couchbase’s Kumar: In search of the K-shaped silver bullet
26 April 2021, ComputerWeekly.com

Data Management System (DBMS) Market Size and Growth 2021-2027 | Key Players – Actian, Teradata, BMC Software, Broadcom, Couchbase Server, Embarcadero Technologies, EnterpriseDB Software Solution, MongoDB – KSU | The Sentinel Newspaper
6 May 2021, KSU | The Sentinel Newspaper

Exclusive: Database company Couchbase files for IPO – sources
11 March 2021, WHBL News

provided by Google News

Five tips for a smooth migration to PostgreSQL
7 May 2021, Information Age

Guest View: OLAP + OLTP = ...PostgreSQL?
12 April 2021, SDTimes.com

Rockset Enables Real-Time Analytics for MySQL and PostgreSQL
17 April 2021, DevPro Journal

Rockset takes a deeper dive into enterprise data pool
15 April 2021, ZDNet

Jan Wieck, Former Postgres Core Team Member, Joins Crunchy Data - PRNewswire
26 April 2021, PRNewswire

provided by Google News

Job opportunities

Redshift Consultant, CA(Remote)
CBL SOLUTIONS INC, Remote

Customer Success Operations Analyst
PTC, United States

Database Engineer - AWS, Amazon Redshift
Amazon Web Services, Inc., Seattle, WA

Solutions Delivery Analyst
Unite Us, New York State

Director of Technology Alliances, Amazon Web Services
N2W Software, Seattle, WA

Software Engineer, Couchbase Lite
Couchbase, Santa Clara, CA

Sales Development Representative - Austin
Couchbase, Austin, TX

Director of Employee Engagement & Experience
Couchbase, Santa Clara, CA

Information Security and Compliance Analyst
Couchbase, Remote

Enterprise Sales Representative
Couchbase, San Francisco, CA

Department
Aunalytics, Link, WV

Software Developer (Junior)
DBDriven.net, Dumfries, VA

Mid Level PostgreSQL DBA
XTIVIA, Remote

PostgreSQL DBA - Telecommute
UnitedHealth Group, Hartford, CT

SQL Server DBA
OneMain Financial, Baltimore, MD

jobs by Indeed




Share this page

Featured Products

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 5 GB free..

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here