DBMS > PostgreSQL vs. RethinkDB
System Properties Comparison PostgreSQL vs. RethinkDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||PostgreSQL Xexclude from comparison||RethinkDB Xexclude from comparison|
|Description||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||DBMS for the Web with a mechanism to push updated query results to applications in realtime.|
|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.||Document store|
|Secondary database models||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||The Linux Foundation since July 2017|
|Initial release||1989 1989: Postgres, 1996: PostgreSQL||2009|
|Current release||16.1, November 2023||2.4.1, August 2020|
|License Commercial or Open Source||Open Source BSD||Open Source Apache Version 2|
|Cloud-based only Only available as a cloud service||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.|
|Server operating systems||FreeBSD|
|Typing predefined data types such as float or date||yes||yes string, binary, float, bool, date, geometry|
|yes specific XML-type available, but no XML query functionality.||no|
|SQL Support of SQL||yes standard with numerous extensions||no|
|APIs and other access methods||ADO.NET|
native C library
streaming API for large objects
|Supported programming languages||.Net|
|C community-supported driver|
C# community-supported driver
C++ community-supported driver
Clojure community-supported driver
Dart community-supported driver
Erlang community-supported driver
Go community-supported driver
Haskell community-supported driver
Java official driver
Lisp community-supported driver
Lua community-supported driver
Objective-C community-supported driver
Perl community-supported driver
PHP community-supported driver
Python official driver
Ruby official driver
Scala community-supported driver
|Server-side scripts Stored procedures||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.|
|Triggers||yes||Client-side triggers through changefeeds|
|Partitioning methods Methods for storing different data on different nodes||partitioning by range, list and (since PostgreSQL 11) by hash||Sharding range based|
|Replication methods Methods for redundantly storing data on multiple nodes||Source-replica replication other methods possible by using 3rd party extensions||Source-replica replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||Atomic single-document operations|
|Concurrency Support for concurrent manipulation of data||yes||yes MVCC based|
|Durability Support for making data persistent||yes||yes|
|User concepts Access control||fine grained access rights according to SQL-standard||yes users and table-level permissions|
More information provided by the system vendor
|Related products and services|
|3rd parties||Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.|
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!
Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
Redgate webinars: A series of key topics for new PostgreSQL users.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
Instaclustr: Fully Hosted & Managed PostgreSQL
pgDash: In-Depth PostgreSQL Monitoring.
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
Meet some database management systems you are likely to hear more about in the future Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL ... Airbyte Announces Certified Connectors for MongoDB, MySQL ... Timescale Introduces Dynamic PostgreSQL, an Alternative to ... Google AlloyDB Omni: PostgreSQL-Compatible Database for On ... PostgreSQL Takes a New Turn provided by Google News The perpetual rise of Sam Altman takes an unexpected turn MongoDB: The Popular Database for IoT RethinkDB is dead, and MongoDB isn't what killed it What Does Real-time Really Mean In Data Analytics? 5 keys to project success on GitHub provided by Google News PostGreSQL DBA Rails Developer PostgreSQL DBA Sr PostgreSQL DBA Full Stack Developer
Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL ...
Airbyte Announces Certified Connectors for MongoDB, MySQL ...
Timescale Introduces Dynamic PostgreSQL, an Alternative to ...
Google AlloyDB Omni: PostgreSQL-Compatible Database for On ...
PostgreSQL Takes a New Turn
provided by Google News
The perpetual rise of Sam Altman takes an unexpected turn
MongoDB: The Popular Database for IoT
RethinkDB is dead, and MongoDB isn't what killed it
What Does Real-time Really Mean In Data Analytics?
5 keys to project success on GitHub
provided by Google News
Sr PostgreSQL DBA
Full Stack Developer
Share this page