DBMS > FoundationDB vs. PostgreSQL vs. RocksDB
System Properties Comparison FoundationDB vs. PostgreSQL vs. RocksDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||FoundationDB Xexclude from comparison||PostgreSQL Xexclude from comparison||RocksDB Xexclude from comparison|
|Created as commercial project in 2013, FoundationDB has been acquired by Apple in March 2015 and was withdrawn from the market. As a consequence, the product was removed from the DB-Engines ranking. In April 2018, Apple open-sourced FoundationDB and it therefore reappears in the ranking.|
|Description||Ordered key-value store. Core features are complimented by layers.||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||Embeddable persistent key-value store optimized for fast storage (flash and RAM)|
|Primary database model||Document store supported via specific layer|
Relational DBMS supported via specific SQL-layer
|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|
|Secondary database models||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Developer||FoundationDB||PostgreSQL Global Development Group www.postgresql.org/developer||Facebook, Inc.|
|Initial release||2013||1989 1989: Postgres, 1996: PostgreSQL||2013|
|Current release||6.2.28, November 2020||16.1, November 2023||8.8.1, November 2023|
|License Commercial or Open Source||Open Source Apache 2.0||Open Source BSD||Open Source BSD|
|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.|
|Server operating systems||Linux|
|Data scheme||schema-free some layers support schemas||yes||schema-free|
|Typing predefined data types such as float or date||no some layers support typing||yes||no|
|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|
|SQL Support of SQL||supported in specific SQL layer only||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|
|Server-side scripts Stored procedures||in SQL-layer only||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||Sharding||partitioning by range, list and (since PostgreSQL 11) by hash||horizontal partitioning|
|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||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Linearizable consistency||Immediate Consistency|
|Foreign keys Referential integrity||in SQL-layer only||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||yes|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no||yes|
|User concepts Access control||no||fine grained access rights according to SQL-standard||no|
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||Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.|
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
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!
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.
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.
Instaclustr: Fully Hosted & Managed PostgreSQL
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
|Speedb: A high performance RocksDB-compliant key-value store optimized for write-intensive workloads.|
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
|Recent citations in the news|
Apple Acquires Durable Database Company FoundationDB
IBM Cloudant pulls plan to fund new foundational layer for CouchDB
Apple May Have Just Killed An Open-Source Project
Apple Open Sources FoundationDB
provided by Google News
Export Apple Notes to a PostgreSQL Database with Python and AppleScript
Meet PGXMAN : The PostgreSQL Extension Manager
Git-for-Data, Version-Controlled Database Dolt Gets PostgreSQL-Flavor
VMware and Google Cloud Announce Planned PostgreSQL-Compatible Database Solution for Traditional and ...
Crunchy Data and Center for Internet Security Announce Benchmark Update for PostgreSQL 16
provided by Google News
Pliops Unveils Accelerated Key-Value Store That Boosts RocksDB Performance by 20x at OCP Global Summit
CockroachDB Launches Advanced Key-Value Store Pebble
Kicking Up AI, Data Analytics, And Networking A Notch Or Two
Just How Special Is The Intel i9-9900KS?
All 51 startups that debuted at Y Combinator W17 Demo Day 2
provided by Google News
Sr PostgreSQL DBA
Full Stack Developer
Sr .Net Developer -W2 Contract
Software Engineer - Database Engineering
Backend Engineer (Databases)
Senior Software Engineer - FoundationDB
Senior Software Engineer- Database Internals
Share this page