DB-EnginesextremeDB - Data management wherever you need itEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Amazon Aurora vs. Apache Cassandra vs. PostgreSQL

System Properties Comparison Amazon Aurora vs. Apache Cassandra vs. PostgreSQL

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameAmazon Aurora  Xexclude from comparisonApache Cassandra  Xexclude from comparisonPostgreSQL  Xexclude from comparison
DescriptionFully managed relational database service built for the cloud providing unparalleled high performance and availability at global scale for MySQL, PostgreSQL, and DSQLWide-column store based on ideas of BigTable and DynamoDB infoOptimized for write accessWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL
Primary database modelRelational DBMSWide column storeRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.
Secondary database modelsDocument store
Spatial DBMS
Vector DBMS
Vector DBMS infostarting with release V5Document store
Graph DBMS infowith Apache Age
Spatial DBMS
Vector DBMS infowith pgvector extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score8.28
Rank#43  Overall
#27  Relational DBMS
Score102.58
Rank#11  Overall
#1  Wide column stores
Score659.62
Rank#4  Overall
#4  Relational DBMS
Websiteaws.amazon.com/­rds/­auroracassandra.apache.orgwww.postgresql.org
Technical documentationdocs.aws.amazon.com/­AmazonRDS/­latest/­AuroraUserGuide/­CHAP_AuroraOverview.html
docs.aws.amazon.com/­aurora-dsql/­latest/­userguide/­what-is-aurora-dsql.html
cassandra.apache.org/­doc/­latestwww.postgresql.org/­docs
Social network pagesLinkedIn
DeveloperAmazonApache Software Foundation infoApache top level project, originally developped by FacebookPostgreSQL Global Development Group infowww.postgresql.org/­developer
Initial release201520081989 info1989: Postgres, 1996: PostgreSQL
Current releaseAurora DSQL, November 2024 (preview), PostgreSQL: docs.aws.amazon.com/­AmazonRDS/­latest/­AuroraPostgreSQLReleaseNotes/­AuroraPostgreSQL.Updates.html , MySQL: docs.aws.amazon.com/­AmazonRDS/­latest/­AuroraMySQLReleaseNotes/­AuroraMySQL.release-calendars.html5.0-rc1, July 202416.4, August 2024
License infoCommercial or Open SourcecommercialOpen Source infoApache version 2Open 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.
PostgreSQL Flex @ STACKIT offers managed PostgreSQL Instances with adjustable CPU, RAM, storage amount and speed and several extensions available, in enterprise grade to perfectly match all application requirements. All 100% GDPR-compliant.
Implementation languagePostgreSQL/MySQL: C, C++, Aurora DSQL: RustJavaC
Server operating systemsAmazon LinuxBSD
Linux
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 dateyesyesyes
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.yesnoyes infospecific XML-type available, but no XML query functionality.
Secondary indexesyesrestricted infoonly equality queries, not always the best performing solutionyes
SQL infoSupport of SQLyes, MySQL and PostgreSQL dialectsSQL-like SELECT, DML and DDL statements (CQL)yes infostandard with numerous extensions
APIs and other access methodsDSQL API: docs.aws.amazon.com/­aurora-dsql/­latest/­userguide/­CHAP_api_reference.html
MySQL wire protocol
PostgreSQL wire protocol
RDS Data API: docs.aws.amazon.com/­AmazonRDS/­latest/­UserGuide/­ProgrammingGuide.html
Proprietary protocol infoCQL (Cassandra Query Language, an SQL-like language)
Thrift
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesAda
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Rust
Scheme
Tcl
C#
C++
Clojure
Erlang
Go
Haskell
Java
JavaScript infoNode.js
Perl
PHP
Python
Ruby
Scala
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Server-side scripts infoStored proceduresPL/pgSQL, MySQL stored program language, APG trusted language extensionsnouser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.
TriggersAurora MySQL: Yes. Aurora PostgreSQL: Yes. Aurora DSQL: No.yesyes
Partitioning methods infoMethods for storing different data on different nodesDBMS table partitioning, Horizontal storage partitioning, Sharding, Distributed horizontal partitioning (DSQL)Sharding infono "single point of failure"partitioning by range, list and (since PostgreSQL 11) by hash
Replication methods infoMethods for redundantly storing data on multiple nodesFull replication
Logical replication
Snapshot replication
Transactional replication
selectable replication factor infoRepresentation of geographical distribution of servers is possibleSource-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 systemEventual Consistency
Immediate/Strong Consistency
Eventual Consistency
Immediate Consistency infocan be individually decided for each write operation
Immediate Consistency
Foreign keys infoReferential integrityyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID, Multi-statementno infoAtomicity and isolation are supported for single operationsACID
Concurrency infoSupport for concurrent manipulation of dataMultiversion concurrency control (MVCC) with fully compatible MySQL and PostgreSQL options. Optimistic concurrency control (OCC) in Aurora DSQL.yesyes
Durability infoSupport for making data persistentData is replicated across 3 Availability Zones (AZs) within a single AWS Region. Active-active multi-Region high availability across 3 Regions (2 active, 1 witness) and automated failover recovery with Aurora DSQL. Automated, continuous backup of data with point in time restore. Fault-tolerant, self-healing storage system.yesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesnono
User concepts infoAccess controlRole based permissions
Row level security
Access rights for users can be defined per objectfine grained access rights according to SQL-standard
More information provided by the system vendor
Amazon AuroraApache CassandraPostgreSQL
Specific characteristicsApache Cassandra is the leading NoSQL, distributed database management system, well...
» more
Competitive advantagesNo single point of failure ensures 100% availability . Operational simplicity for...
» more
Typical application scenariosInternet of Things (IOT), fraud detection applications, recommendation engines, product...
» more
Key customersApple, Netflix, Uber, ING,, Intuit,Fidelity, NY Times, Outbrain, BazaarVoice, Best...
» more
Market metricsApache Cassandra is used by 40% of the Fortune 100.
» more
Licensing and pricing modelsApache license  Pricing for commercial distributions provided by DataStax and available...
» more
News

How to Build a Simple AI Agent with Langflow and Composio
6 February 2025

Knowledge Graphs: Do You Need One?
5 February 2025

AI Agents Are About to Blow Up the Business Process Layer
4 February 2025

How to Store a Knowledge Graph in a Database
30 January 2025

Introducing Langflow.new: Frictionless AI
29 January 2025

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

» more


» more


» more


» more


» more

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

More resources
Amazon AuroraApache CassandraPostgreSQL
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

Amazon - the rising star in the DBMS market
3 August 2015, Matthias Gelbmann

show all

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

Announcing Amazon Aurora DSQL (Preview)
3 December 2024, AWS Blog

Amazon Aurora PostgreSQL Limitless Database is now generally available
31 October 2024, AWS Blog

How Aqua Security exports query data from Amazon Aurora to deliver value to their customers at scale
29 January 2025, AWS Blog

Introducing Amazon Aurora DSQL | Amazon Web Services
3 December 2024, AWS Blog

Introducing scaling up to 256 ACUs with Amazon Aurora Serverless v2
8 October 2024, AWS Blog

provided by Google News

New Apache Cassandra 5.0 gives open source NoSQL database a scalability and performance boost
6 September 2024, VentureBeat

Apache Cassandra survey highlights growing adoption for AI workloads
11 November 2024, Blocks and Files

Migrate Cassandra workloads to Amazon Keyspaces using CQLReplicator
4 September 2024, AWS Blog

Apache Cassandra Vulnerability Allows Attackers to Gain Access Data Centers
4 February 2025, GBHackers

Apache Software Foundation Announces Apache Cassandra® 5.0,
7 October 2024, GlobeNewswire

provided by Google News

Microsoft builds open source document database on PostgreSQL, suggests FerretDB as front end
27 January 2025, The Register

Amazon Aurora PostgreSQL Limitless Database is now generally available
31 October 2024, AWS Blog

Snowflake Brings Seamless PostgreSQL and MySQL Integration with New Connectors
16 July 2024, Snowflake

High-Severity Flaw in PostgreSQL Allows Hackers to Exploit Environment Variables
15 November 2024, The Hacker News

Aurora Limitless: AWS Introduces New PostgreSQL Database with Automated Horizontal Scaling
22 November 2024, InfoQ.com

provided by Google News



Share this page

Featured Products

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Present your product here