DBMS > JanusGraph vs. PostgreSQL vs. Rockset
System Properties Comparison JanusGraph vs. PostgreSQL vs. Rockset
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||JanusGraph successor of Titan Xexclude from comparison||PostgreSQL Xexclude from comparison||Rockset Xexclude from comparison|
|Description||A Graph DBMS optimized for distributed clusters It was forked from the latest code base of Titan in January 2017||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||A scalable, reliable search and analytics service in the cloud, built on RocksDB|
|Primary database model||Graph DBMS||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||Linux Foundation; originally developed as Titan by Aurelius||PostgreSQL Global Development Group www.postgresql.org/developer||Rockset|
|Initial release||2017||1989 1989: Postgres, 1996: PostgreSQL||2019|
|Current release||0.6.3, February 2023||16.1, November 2023|
|License Commercial or Open Source||Open Source Apache 2.0||Open Source BSD||commercial|
|Cloud-based only Only available as a cloud service||no||no||yes|
|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||Linux|
|Typing predefined data types such as float or date||yes||yes||dynamic typing|
|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.||no||yes specific XML-type available, but no XML query functionality.||no ingestion from XML files supported|
|Secondary indexes||yes||yes||all fields are automatically indexed|
|SQL Support of SQL||no||yes standard with numerous extensions||Read-only SQL queries, including JOINs|
|APIs and other access methods||Java API|
native C library
streaming API for large objects
|Supported programming languages||Clojure|
|Server-side scripts Stored procedures||yes||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||no|
|Partitioning methods Methods for storing different data on different nodes||yes depending on the used storage backend (e.g. Cassandra, HBase, BerkeleyDB)||partitioning by range, list and (since PostgreSQL 11) by hash||Automatic sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||yes||Source-replica replication other methods possible by using 3rd party extensions||yes|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes via Faunus, a graph analytics engine||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency|
|Immediate Consistency||Eventual Consistency|
|Foreign keys Referential integrity||yes Relationships in graphs||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||no|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes Supports various storage backends: Cassandra, HBase, Berkeley DB, Akiban, Hazelcast||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no|
|User concepts Access control||User authentification and security via Rexster Graph Server||fine grained access rights according to SQL-standard||Access rights for users and organizations can be defined via Rockset console|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||Aiven for PostgreSQL: Fully managed PostgreSQL for developers with 70+ extensions and flexible orchestration tools.
pgDash: In-Depth PostgreSQL Monitoring.
Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
Instaclustr: Fully Hosted & Managed PostgreSQL
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
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
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!
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|JanusGraph successor of Titan||PostgreSQL||Rockset|
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
|Recent citations in the news|
Getting Started with Graph Database Queries, with Cheat Sheet!
Aerospike Is Now a Graph Database, Too
Google Cloud's 2023 Data and AI Trends Report Reveals a ...
The year of the graph: Getting graphic, going native, reshaping the ...
The untapped potential of HPC + graph computing
provided by Google News
Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL ...
Timescale Introduces Dynamic PostgreSQL, an Alternative to ...
PostgreSQL Takes a New Turn
Google AlloyDB Omni: PostgreSQL-Compatible Database for On ...
Timescale's Dynamic PostgreSQL Makes Data Provisioning Elastic
provided by Google News
Rockset enhances vector search to support cloud-based AI ...
Rockset Primes Database for Massive Vector Serving
Rockset boosts AI capabilities for vector database search
Confluent unveils data streaming for AI for real-time applications
Storage news ticker – November 24 – Blocks and Files
provided by Google News
Senior Data Engineer, Unity Ads
Senior Data Scientist I
Cloud Computing Engineer
Sr PostgreSQL DBA
Full Stack Developer
Software Engineer, Infrastructure
Sr. Software Engineer, Infrastructure
Product Marketing Manager
Share this page