DBMS > PostgreSQL vs. Redis vs. ScyllaDB
System Properties Comparison PostgreSQL vs. Redis vs. ScyllaDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||PostgreSQL Xexclude from comparison||Redis Xexclude from comparison||ScyllaDB Xexclude from comparison|
|Description||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||Popular in-memory data platform used as a cache, message broker, and database that can be deployed on-premises, across clouds, and hybrid environments Redis focuses on performance so most of its design decisions prioritize high performance and very low latencies.||Cassandra and DynamoDB compatible wide column store|
|Primary database model||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Key-value store Multiple data types and a rich set of operations, as well as configurable data expiration, eviction and persistence||Wide column store|
|Secondary database models||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Document store with RedisJSON|
Graph DBMS with RedisGraph
Search engine with RediSearch
Time Series DBMS with RedisTimeSeries
|Social network pages|
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||Redis project core team, inspired by Salvatore Sanfilippo Development sponsored by Redis Inc.||ScyllaDB|
|Initial release||1989 1989: Postgres, 1996: PostgreSQL||2009||2015|
|Current release||16.1, November 2023||7.2.3, November 2023||ScyllaDB Open Source 5.2.11, November 2023|
|License Commercial or Open Source||Open Source BSD||Open Source source-available extensions (modules), commercial licenses for Redis Enterprise||Open Source Open Source (AGPL), commercial license available|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.||Scylla Cloud: Create real-time applications that run at global scale with Scylla Cloud, the industry’s most powerful NoSQL DBaaS|
|Server operating systems||FreeBSD|
Windows ported and maintained by Microsoft Open Technologies, Inc.
|Typing predefined data types such as float or date||yes||partial Supported data types are strings, hashes, lists, sets and sorted sets, bit arrays, hyperloglogs and geospatial indexes||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||yes specific XML-type available, but no XML query functionality.||no||no|
|Secondary indexes||yes||yes with RediSearch module||yes cluster global secondary indices|
|SQL Support of SQL||yes standard with numerous extensions||with RediSQL module||SQL-like DML and DDL statements (CQL)|
|APIs and other access methods||ADO.NET|
native C library
streaming API for large objects
|proprietary protocol RESP - REdis Serialization Protocol||Proprietary protocol (CQL) compatible with CQL (Cassandra Query Language, an SQL-like language)|
RESTful HTTP API (DynamoDB compatible)
|Supported programming languages||.Net|
|Server-side scripts Stored procedures||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||Lua; Redis Functions coming in Redis 7 (slides and Github)||yes, Lua|
|Triggers||yes||publish/subscribe channels provide some trigger functionality; RedisGears||no|
|Partitioning methods Methods for storing different data on different nodes||partitioning by range, list and (since PostgreSQL 11) by hash||Sharding Automatic hash-based sharding with support for hash-tags for manual sharding||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication other methods possible by using 3rd party extensions||Multi-source replication with Redis Enterprise Pack|
Source-replica replication Chained replication is supported
|selectable replication factor Representation of geographical distribution of servers is possible|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||through RedisGears||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Eventual Consistency|
Causal consistency can be enabled in Active-Active databases
Strong consistency with Redis Raft
Strong eventual consistency with Active-Active
Tunable Consistency can be individually decided for each write operation
|Foreign keys Referential integrity||yes||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||Atomic execution of command blocks and scripts and optimistic locking||no Atomicity and isolation are supported for single operations|
|Concurrency Support for concurrent manipulation of data||yes||yes Data access is serialized by the server||yes|
|Durability Support for making data persistent||yes||yes Configurable mechanisms for persistency via snapshots and/or operations logs||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes||yes in-memory tables|
|User concepts Access control||fine grained access rights according to SQL-standard||Access Control Lists (ACLs): redis.io/docs/management/security/acl|
LDAP and Role-Based Access Control (RBAC) for Redis Enterprise
Mutual TLS authentication: redis.io/docs/management/security/encryption
|Access rights for users can be defined per object|
|More information provided by the system vendor|
|Specific characteristics||The Redis real-time data platform builds upon the unmatched simplicity and speed...|
|ScyllaDB is the database for data-intensive apps that require high performance and...|
|Competitive advantages||Redis Enterprise is a robust in-memory database platform built by the people who...|
|Highly-performant (efficiently utilizes full resources of a node and network; millions...|
|Typical application scenarios||Redis Enterprise is used by large enterprise, startup, and government organizations...|
|ScyllaDB is ideal for applications that require high throughput and low latency at...|
|Key customers||Verizon, Vodafone, Atlassian, Trip Advisor, Jet.com, Nokia, Samsung, HTC, Docker,...|
|Discord, Epic Games, Expedia, Zillow, Comcast, Disney+ Hotstar, Samsung, ShareChat,...|
|Market metrics||Most launched Docker container per day according to Docker Hub (7.2M launches per...|
|ScyllaDB typically offers ~75% total cost of ownership savings, with ~5X higher throughput...|
|Licensing and pricing models||Redis Enterprise Cloud lets users scale up and down instantly, and pay only for the...|
|ScyllaDB Open Source - free open source software (AGPL) ScyllaDB Enterprise - subscription-based...|
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Redgate webinars: A series of key topics for new PostgreSQL users.
Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
pgDash: In-Depth PostgreSQL Monitoring.
Timescale: Calling all PostgreSQL users – the 2023 State of PostgreSQL survey is now open! Share your favorite extensions, preferred frameworks, community experiences, and more. Take the survey today!
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
Instaclustr: Fully Hosted & Managed PostgreSQL
|Navicat for Redis: the award-winning Redis management tool with an intuitive and powerful graphical interface.|
Read the Redis NoSQL benchmark report.
Redisson PRO: The ultra-fast Redis Java Client.
CData: Connect to Big Data & NoSQL through standard Drivers.
Aiven for Redis: Fully managed in-memory key-value store for all your caching and speedy lookup needs.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
PostgreSQL is the DBMS of the Year 2018 MySQL, PostgreSQL and Redis are the winners of the March ranking MongoDB is the DBMS of the year, defending the title from last year
MySQL, PostgreSQL and Redis are the winners of the March ranking MongoDB is the DBMS of the year, defending the title from last year
MongoDB is the DBMS of the year, defending the title from last year
|Recent citations in the news|
OCI Database: Oracle Embraces PostgreSQL
Data Flow Tutorial With Mage.ai | Part 4: PostgreSQL Database - Technical Articles
VMware and Google Cloud Announce Planned PostgreSQL-Compatible Database Solution for Traditional and ...
PostgreSQL Takes a New Turn
Using Arrays in PostgreSQL: A Guide
provided by Google News
In-memory database Redis wants to dabble in disk
Redis adds support for vector database search in its first unified platform update
Redis Cloud Powers LangChain OpenGPTs Project
Latest Redis Update Streamlines Management of Platform
New Cryptojacking Campaign Leverages Misconfigured Redis Database Servers
provided by Google News
ScyllaDB Raises $43M to Take on MongoDB at Scale, Push Database Performance to New Levels
Running ScyllaDB NoSQL on Kubernetes with Spot Instances
ScyllaDB Raises $43M in Funding
How Discord Migrated Trillions of Messages to ScyllaDB
provided by Google News
Sr PostgreSQL DBA
Full Stack Developer
Database Administrator (DBA)
Lead Database Engineer
Database Administrator (DBA)
Remote Elixir/Phoenix Developer
Senior Database Administrator
Share this page