DBMS > PostgreSQL vs. SAP SQL Anywhere vs. VoltDB
System Properties Comparison PostgreSQL vs. SAP SQL Anywhere vs. VoltDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||PostgreSQL Xexclude from comparison||SAP SQL Anywhere formerly called Adaptive Server Anywhere Xexclude from comparison||VoltDB Xexclude from comparison|
|Description||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||RDBMS database and synchronization technologies for server, desktop, remote office, and mobile environments||Distributed In-Memory NewSQL RDBMS Used for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory|
|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.||Relational DBMS||Relational DBMS|
|Secondary database models||Document store|
|Developer||PostgreSQL Global Development Group www.postgresql.org/developer||SAP formerly Sybase||VoltDB Inc.|
|Initial release||1989 1989: Postgres, 1996: PostgreSQL||1992||2010|
|Current release||11.5, August 2019||17, July 2015||9.0, April 2019|
|License Commercial or Open Source||Open Source BSD||commercial||Open Source AGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions|
|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.
|Implementation language||C||Java, C++|
|Server operating systems||FreeBSD|
OS X for development
|Typing predefined data types such as float or date||yes||yes||yes|
|yes specific XML-type available, but no XML query functionality.||yes|
|SQL Support of SQL||yes standard with numerous extensions||yes||yes only a subset of SQL 99|
|APIs and other access methods||native C library|
streaming API for large objects
RESTful HTTP/JSON API
|Supported programming languages||.Net|
Erlang not officially supported
|Server-side scripts Stored procedures||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||yes, in C/C++, Java, .Net or Perl||Java|
|Partitioning methods Methods for storing different data on different nodes||partitioning by range, list and (since PostgreSQL 11) by hash||none||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||Master-slave replication other methods possible by using 3rd party extensions||Master-slave replication Database mirroring||Master-master replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency||Immediate Consistency|
|Foreign keys Referential integrity||yes||yes||no FOREIGN KEY constraints are not supported|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID Transactions are executed single-threaded within stored procedures|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes Data access is serialized by the server|
|Durability Support for making data persistent||yes||yes||yes Snapshots and command logging|
|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||fine grained access rights according to SQL-standard||fine grained access rights according to SQL-standard||Users and roles with access to stored procedures|
More information provided by the system vendor
|Related products and services|
|3rd parties||Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service|
General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
SQLPro for PostgreSQL: A simple but powerful PostgreSQL database client available on iPhone and iPad as well as macOS.
2ndQuadrant: PostgreSQL Solutions for the Enterprise.
Dremio is like magic for PostgreSQL accelerating your analytical queries up to 1,000x.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
DBHawk: a web-based PostgreSQL/Greenplum database tool. Boost database development and BI productivity with an online Universal database tool.
pgDash: In-Depth PostgreSQL Monitoring.
|PostgreSQL||SAP SQL Anywhere formerly called Adaptive Server Anywhere||VoltDB|
|DB-Engines blog posts|
PostgreSQL is the DBMS of the Year 2018
|Conferences and events|
PostgreSQL Conference, Asia 2019
PostgreSQL Conference, Europe 2019
|Recent citations in the news|
Database PostgreSQL makes transition from academia to enterprise
After PostgreSQL, DigitalOcean now adds MySQL and Redis to its managed databases’ offering
Providing Postgres at scale with EnterpriseDB
TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
provided by Google News
SAP SQL Anywhere
SAP gives SQL Anywhere a new IoT injection
SAP BAPI (Business Application Programming Interface)
Data Management and the Internet of Things
SAP IoT products: How do they work with ERP and big data?
provided by Google News
In-Memory Database Market 2018-2023 Reaching New Height By Top Leading Players: Microsoft, IBM, Oracle, SAP
VoltDB Introduces Smart Streaming Architecture for the Connected World
Global In-Memory Database Market to Register Substantial Expansion and Growth by 2024
Global Database Management Systems (DBMS) Market Study 2019-2025: BMC Software, Oracle, IBM, CA Technologies, Couchbase Server
provided by Google News
Open Source Database Administrator
Database Administrator - Mongo
DevOps Database Administrator
Database Administrator (Higher Ed)
MySQL Database Administrator
Principal Big Data Engineer
Senior Embedded Engineer - ChronoTrack
Backend/Data Engineer II
Share this page