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

DBMS > Alibaba Cloud AnalyticDB for PostgreSQL vs. PostgreSQL vs. RethinkDB vs. SAP SQL Anywhere vs. ScyllaDB

System Properties Comparison Alibaba Cloud AnalyticDB for PostgreSQL vs. PostgreSQL vs. RethinkDB vs. SAP SQL Anywhere vs. ScyllaDB

Editorial information provided by DB-Engines
NameAlibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDB  Xexclude from comparisonPostgreSQL  Xexclude from comparisonRethinkDB  Xexclude from comparisonSAP SQL Anywhere infoformerly called Adaptive Server Anywhere  Xexclude from comparisonScyllaDB  Xexclude from comparison
DescriptionAn online MPP (Massively Parallel Processing) data warehousing service based on GreenplumWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQLDBMS for the Web with a mechanism to push updated query results to applications in realtime.RDBMS database and synchronization technologies for server, desktop, remote office, and mobile environmentsCassandra and DynamoDB compatible wide column store
Primary database modelRelational DBMSRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.Document storeRelational DBMSKey-value store
Wide column store
Secondary database modelsDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.61
Rank#212  Overall
#107  Relational DBMS
Score550.96
Rank#4  Overall
#4  Relational DBMS
Score4.06
Rank#83  Overall
#14  Document stores
Score5.95
Rank#61  Overall
#35  Relational DBMS
Score2.15
Rank#113  Overall
#22  Key-value stores
#8  Wide column stores
Websitewww.alibabacloud.com/­product/­hybriddb-postgresqlwww.postgresql.orgrethinkdb.comwww.sap.com/­products/­sql-anywhere.htmlwww.scylladb.com
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­35387.htmwww.postgresql.org/­docsrethinkdb.com/­docshelp.sap.com/­sql-anywheredocs.scylladb.com
DeveloperAlibaba / Pivotal Software Inc. / PostgreSQL Global Development GroupPostgreSQL Global Development Group infowww.postgresql.org/­developerThe Linux Foundation infosince July 2017SAP infoformerly SybaseScyllaDB
Initial release20161989 info1989: Postgres, 1996: PostgreSQL200919922015
Current release13.2 , February 20212.4.1, August 202017, July 2015Scylla Open Source 4.3, January 2021
License infoCommercial or Open SourcecommercialOpen Source infoBSDOpen Source infoApache Version 2commercialOpen Source infoOpen Source (AGPL), commercial license available
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
ScaleGrid for PostgreSQL: Fully managed PostgreSQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS
Implementation languageCC++C++
Server operating systemshostedFreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Linux
OS X
Windows
AIX
HP-UX
Linux
OS X
Solaris
Windows
Linux
Data schemeyesyesschema-freeyesschema-free
Typing infopredefined data types such as float or dateyesyesyes infostring, binary, float, bool, date, geometryyesyes
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.yesyes infospecific XML-type available, but no XML query functionality.noyesno
Secondary indexesyesyesyesyesyes infocluster global secondary indices
SQL infoSupport of SQLyesyes infostandard with numerous extensionsnoyesSQL-like DML and DDL statements (CQL)
APIs and other access methodsJDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
ADO.NET
HTTP API
JDBC
ODBC
Proprietary protocol (CQL) infocompatible with CQL (Cassandra Query Language, an SQL-like language)
RESTful HTTP API (DynamoDB compatible)
Thrift
Supported programming languagesC
Java
Perl
Python
R
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C infocommunity-supported driver
C# infocommunity-supported driver
C++ infocommunity-supported driver
Clojure infocommunity-supported driver
Dart infocommunity-supported driver
Erlang infocommunity-supported driver
Go infocommunity-supported driver
Haskell infocommunity-supported driver
Java infoofficial driver
JavaScript (Node.js) infoofficial driver
Lisp infocommunity-supported driver
Lua infocommunity-supported driver
Objective-C infocommunity-supported driver
Perl infocommunity-supported driver
PHP infocommunity-supported driver
Python infoofficial driver
Ruby infoofficial driver
Scala infocommunity-supported driver
C
C#
C++
Delphi
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
For CQL interface: C#, C++, Clojure, Erlang, Go, Haskell, Java, JavaScript, Node.js, Perl, PHP, Python, Ruby, Rust, Scala
For DynamoDB interface: .Net, ColdFusion, Erlang, Groovy, Java, JavaScript, Perl, PHP, Python, Ruby
Server-side scripts infoStored proceduresyesuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.yes, in C/C++, Java, .Net or Perlyes, Lua
TriggersyesyesClient-side triggers through changefeedsyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud servicepartitioning by range, list and (since PostgreSQL 11) by hashSharding inforange basednoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud serviceSource-replica replication infoother methods possible by using 3rd party extensionsSource-replica replicationSource-replica replication infoDatabase mirroringselectable replication factor infoRepresentation of geographical distribution of servers is possible
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonoyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyEventual Consistency
Tunable Consistency infocan be individually decided for each write operation
Foreign keys infoReferential integrityyesyesnoyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDAtomic single-document operationsACIDno infoAtomicity and isolation are supported for single operations
Concurrency infoSupport for concurrent manipulation of datayesyesyes infoMVCC basedyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nononoyesyes infoin-memory tables
User concepts infoAccess controlfine grained access rights according to SQL-standardfine grained access rights according to SQL-standardyes infousers and table-level permissionsfine grained access rights according to SQL-standardAccess rights for users can be defined per object
More information provided by the system vendor
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBPostgreSQLRethinkDBSAP SQL Anywhere infoformerly called Adaptive Server AnywhereScyllaDB
Specific characteristicsScylla is a highly-available, highly-scalable, highly-performant NoSQL database....
» more
Competitive advantagesHighly-performant (efficiently utilizes full resources of a node and network; millions...
» more
Typical application scenariosAdTech ( AdGear , Dstillery , MediaMath , Numberly , SAS , SteelHouse , Xandr) Customer...
» more
Key customersComcast, Grab, OlaCabs, Yahoo! Japan, IMVU, Adgear, Xandr, Zenly, Natura, Snapfish,...
» more
Licensing and pricing modelsScylla Open Source - free open source software (AGPL) Scylla Enterprise - subscription-based...
» 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 partiesCYBERTEC 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

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

pgDash: In-Depth PostgreSQL Monitoring.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» 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

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

More resources
Alibaba Cloud AnalyticDB for PostgreSQL infoformer name was HybridDBPostgreSQLRethinkDBSAP SQL Anywhere infoformerly called Adaptive Server AnywhereScyllaDB
DB-Engines blog posts

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

Meet some database management systems you are likely to hear more about in the future
4 August 2014, Paul Andlinger

show all

Recent citations in the news

Cloud-native computing efficiency can skyrocket business operations - The Jakarta Post
1 February 2021, Jakarta Post

Alibaba Cloud Unveils 'Magic' Behind the World's Largest Online Shopping Festival
19 November 2020, PRNewswire

Alibaba supports Singles Day with cloud computing, 3D models
19 November 2020, Chain Store Age

Alibaba Cloud Leader in Magic Quadrant for Cloud Database Management
1 December 2020, DataCenterNews North America

Alibaba Cloud launches new cloud database solutions following market growth
1 October 2020, DataCenterNews North America

provided by Google News

AWS Announces Amazon Aurora Supports PostgreSQL 12 (infoq.com)
7 February 2021, InfoQ.com

Global NoSQL Market 2020 Industry Segmentation: Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database – KSU | The Sentinel Newspaper
24 February 2021, KSU | The Sentinel Newspaper

EDB Caps Successful Year of Hypergrowth
18 February 2021, Business Wire

Global RDBMS Software Market 2025: Microsoft, Oracle, PostgreSQL Global Development Group, SQLite, IBM, SolarWinds IT Operations Management, Cubrid, TmaxSoft, CA Technologies, ThinkSQL, FrontBase, MonetDB, VoltDB
22 February 2021, NeighborWebSJ

Global NoSQL Market 2025: Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database, MongoLab, MarkLogic, Couchbase, CloudDB, DynamoDB, Basho Technologies, Aerospike, IBM, Neo, Hypertable, Cisco, Objectivity
23 February 2021, NY Market Reports

provided by Google News

Document Databases Software Market Report 2025 : MongoDB, Amazon, ArangoDB, Azure Cosmos DB, Couchbase, MarkLogic, RethinkDB, CouchDB, SQL-RD, OrientDB, RavenDB, Redis – NeighborWebSJ
27 January 2021, NeighborWebSJ

Global Open Source Software Market 2025: Intel, Epson, IBM, Transcend, Oracle, Acquia, OpenText, Alfresco, Astaro, RethinkDB, Canonical, ClearCenter, Cleversafe, Compiere, Continuent
22 February 2021, NeighborWebSJ

Open Source Software Market Size, Industry Analysis, Growth Factors, Trends, and Regional Forecast to 2027 – KSU | The Sentinel Newspaper
19 February 2021, KSU | The Sentinel Newspaper

Open Source Software Market Technological Innovation by Key Players Intel, Epson, IBM, Transcend, Oracle, Acquia, Actuate – KSU | The Sentinel Newspaper
22 February 2021, KSU | The Sentinel Newspaper

Global NoSQL Software Market 2020-2025: Top Companies MongoDB, OrientDB, Amazon, Azure Cosmos DB, Couchbase, ArangoDB, CouchDB, MarkLogic, SQL-RD, RethinkDB, RavenDB, Microsoft, Redis
28 January 2021, SoccerNurds

provided by Google News

SAP SQL Anywhere
3 April 2018, TechTarget

SAP gives SQL Anywhere a new IoT injection
16 July 2015, Computerworld

Best Database Management Software 2020
14 July 2020, Datamation

Data Management and the Internet of Things
3 November 2016, CloudTweaks News

SAP HANA Dresses for Internet of Things and Predictive Analytics – Cloud Times
17 June 2015, CloudTimes

provided by Google News

ScyllaDB Unveils 'Monstrous' New Capabilities for Its NoSQL Database
12 January 2021, GlobeNewswire

ScyllaDB Unveils One-Step Migration from Amazon DynamoDB to Scylla NoSQL Database
2 September 2020, GlobeNewswire

ScyllaDB Announces Scylla Enterprise 2020 NoSQL Database
19 August 2020, GlobeNewswire

ScyllaDB Announces 4.0 Release of Its Open Source NoSQL Database
7 May 2020, GlobeNewswire

Discord Chooses Scylla as Its Core Storage Layer
22 July 2020, GlobeNewswire

provided by Google News

Job opportunities

GIS Technician I
Kaart Group, Seattle, WA

Data Technician (Full- or Part-Time)
Thasos Group, New York, NY

IICS Admin
Validity Green Inc, Remote

Junior Database Administrator
Colorado Business Computer Systems, Inc., Remote

Node.js Developer
Aiteq, Remote

Full Stack Ruby Engineer
Showcase IDX, Georgia

Full Stack Data Scientist
Clara Foods, South San Francisco, CA

Full Stack Developer
Renkim Corporation, Southgate, MI

Engineer II, Software Process Engineering
Samsung Electronics, Bellevue, WA

Senior Level System Development Engineer
HiveIO, Remote

Database Administrator
ECR Software Corporation, United States

IT Leader- Retirement Plan Services
CBIZ, Cleveland, OH

Sr. Software Engineer - Backend
Restream, Remote

Manager, Engineering (Product Graph/ Data Team)
Narrativ, New York State

Senior Full Stack Frontend Engineer, Data
Narrativ, New York State

jobs by Indeed




Share this page

Featured Products

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..

Neo4j logo

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

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

Present your product here