Comparison: Aurora DSQL vs Redis

Modified date: Monday, June 30, 2025

Table of Contents

Introduction
General
Data Types
SQL
Storage and System
Benchmarking
Tools
Export Regulations
Internal
Internal - Optimizer
Internal - Runtime
Internal - Storage Engine

General

Feature	Aurora DSQL	Redis	Definition
intro	Aurora is a relational database management system (RDBMS) built for the cloud with full MySQL and PostgreSQL compatibility. DSQL is PostgreSQL compatible.	Redis (REmote DIctionary Server) is an open source, in-memory, NoSQL key/value store that is used primarily as an application cache or quick-response database.	in their own words - but I reserved the rights to remove some bold claims like "the best", unless it is widely recognized.
vendor	Amazon AWS	Redis
initial release		2009
latested version		8	We don't put a release date here as the software is patching frequently. So tracking it is not much useful.
supported platforms		RHEL, Ubuntu, Amazon Linux Here is the Redis Enterprise version. The open source one shall be runnable on *BSD, Linux, MacOS.	supported OS/CPU platforms
db-engines ranking		7	ranks from https://db-engines.com/en/ranking (06/25)
relational?		no	Is it a relational database? (1) Most database are actually with some extensions, for example, nested data types, graph support, etc, which we usually called "multi-model". (2) Some of them are product family, meaning they have more than one database. Here we focus on the main one but explain others when needed.
open source?		yes/no	mainly the engine code
license		Tri-licensing model Starting with Redis 8, Redis Open Source is moving to a tri-licensing model with all new Redis code contributions governed by the updated Redis Software Grant and Contributor License Agreement. After this release, contributions are subject to your choice of: (a) the Redis Source Available License v2 (RSALv2);or (b) the Server Side Public License v1 (SSPLv1); or (c) the GNU Affero General Public License v3 (AGPLv3). Redis Open Source 7.2 and prior releases remain subject to the BSDv3 clause license.
on-premise offering		yes	if no means you can't buy "box" software from them
cloud offering		Redis Cloud
technical doc		https://redis.io/docs/latest/

SQL

Feature	Aurora DSQL	Redis	Definition
base	PostgreSQL
SQL: standard complaince	high	No SQL
max SQL length	undefined same as PostgreSQL with "StringInfo" container		maximal SQL statement length
PL: main	SQL + PL/PgSQL		main programming lanage: most database suports SQL because SQL is a well established standard. However, each database would like to extend SQL more or less.
PL: other language support	yes		PL lanaguage other than PL/SQL, like PL/Java, PL/Rust etc
SP: max parameters	100
UDF: max parameters	100
SQL: max parameters	65535		number of parameters in a PREPARED query
SQL: query hints	GUC only		if it allows use query hints to guide the optimizer
SQL: explicit locking	yes: row, page, table level		Locking is usually an internal matter - so does it allow explicit locking? What levels do they support?
Triggers?	yes		If support triggers
Triggers: scope	tables, views, foreign tables		What objects can have triggers
Triggers: type	BEFORE, AFTER, INSTEAD OF		Types of triggers supported
Object-Relational?	yes
Extension Mechanism	C programming, link with engine	Redis Modules API
vector search	no native		does it support vector search
SQL: extensions		There are multiple open source projects to add SQL support on top of Redis. For example, RediSQL.

Storage and System

Feature	Aurora DSQL	Redis	Definition
arch: server		C/S	Embedded or traditional C/S?
arch: run in browser?		no	It also known as a client-side database, is a database that is stored and managed within a user's web browser, rather than on a remote server.
ACID: durability		yes
Materialized View: support?		no

Benchmarking

Feature	Aurora DSQL	Redis	Definition
any official TPC benchmarks?		no	The TPC benchmark includes a set of tests simulating real-world scenarios to evaluate database performance.

Tools

Feature	Aurora DSQL	Redis	Definition
command line client		redis-cli	it means "sql client" for database supporting SQL. For embedded atabase, the client includes the server together.

Export Regulations

Feature	Aurora DSQL	Redis	Definition
Jurisdiction		US	Which country controls export
ECCN		None	An Export Control Classification Number (ECCN) is a five-character alphanumeric code used to categorize items on the Commerce Control List (CCL) for export control purposes. Most database may fall into 5D992.c category, "mass market encryption", which means it has some ordinary encryption related code, for example, the SSL connection code.
Eligible License Exception / CCATS		Not required There is no ECCN for open source software	A License Exception is an authorization that allows you to export or reexport items subject to the EAR without needing to obtain a specific export license, provided certain conditions are met. CCATS stands for Commodity Classification Automated Tracking System. The BIS assigns a CCATS number to products that it has classified under the Commerce Control List (CCL).
Encryption Components		SSL	Crypto functionality that triggers control

Internal

Feature	Aurora DSQL	Redis	Definition

Internal - Optimizer

Feature	Aurora DSQL	Redis	Definition

Internal - Runtime

Feature	Aurora DSQL	Redis	Definition

Internal - Storage Engine

Feature	Aurora DSQL	Redis	Definition
ACID: durability mechanism		AOF	How is it implements durability. Database's classic way is write ahead logging (WAL).