DBMS > mSQL vs. PostgreSQL vs. VoltDB
System Properties Comparison mSQL vs. PostgreSQL vs. VoltDB
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||mSQL Mini SQL Xexclude from comparison||PostgreSQL Xexclude from comparison||VoltDB Xexclude from comparison|
|Description||mSQL (Mini SQL) is a simple and lightweight RDBMS||Widely used open source RDBMS Developed as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQL||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||Relational DBMS with object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.||Relational DBMS|
|Secondary database models||Document store|
Graph DBMS with Apache Age
Vector DBMS with pgvector extension
|Developer||Hughes Technologies||PostgreSQL Global Development Group www.postgresql.org/developer||VoltDB Inc.|
|Initial release||1994||1989 1989: Postgres, 1996: PostgreSQL||2010|
|Current release||4.4, October 2021||16.0, September 2023||11.3, April 2022|
|License Commercial or Open Source||commercial free licenses can be provided||Open Source BSD||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.
|Aiven for PostgreSQL: Fully managed and hosted PostgreSQL® with 70+ extensions and orchestration tooling included.|
|Implementation language||C||C||Java, C++|
|Server operating systems||AIX|
OS X for development
|Typing predefined data types such as float or date||yes||yes||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.||no||yes specific XML-type available, but no XML query functionality.|
|SQL Support of SQL||A subset of ANSI SQL is implemented no subqueries, aggregate functions, views, foreign keys, triggers||yes standard with numerous extensions||yes only a subset of SQL 99|
|APIs and other access methods||JDBC|
native C library
streaming API for large objects
RESTful HTTP/JSON API
|Supported programming languages||C|
Erlang not officially supported
|Server-side scripts Stored procedures||no||user defined functions realized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.||Java|
|Partitioning methods Methods for storing different data on different nodes||none||partitioning by range, list and (since PostgreSQL 11) by hash||Sharding|
|Replication methods Methods for redundantly storing data on multiple nodes||none||Source-replica replication other methods possible by using 3rd party extensions||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||none||Immediate Consistency|
|Foreign keys Referential integrity||no||yes||no FOREIGN KEY constraints are not supported|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||ACID Transactions are executed single-threaded within stored procedures|
|Concurrency Support for concurrent manipulation of data||no||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||no|
|User concepts Access control||no||fine grained access rights according to SQL-standard||Users and roles with access to stored procedures|
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.|
Fujitsu Enterprise Postgres: An Enterprise Grade PostgreSQL with the flexibility of a hybrid cloud solution combined with industry leading security, availability and performance.
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!
Datasentinel: Platform for Monitoring and Analyzing the performance problems of your PostgreSQL Clusters
Aiven for PostgreSQL: The familiar open source PostgreSQL® that you know and love, with no proprietary features or add-ons that will lock you in.
pgDash: In-Depth PostgreSQL Monitoring.
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
Instaclustr: Fully Hosted & Managed PostgreSQL
Redgate webinars: A series of key topics for new PostgreSQL users.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|mSQL Mini SQL||PostgreSQL||VoltDB|
|DB-Engines blog posts|
Snowflake is the DBMS of the Year 2022, defending the title from last year
|Conferences and events|
PostgreSQL 101: An introduction to Multi-Version Concurrency Control and Vacuum
|Recent citations in the news|
Writing a Web Service in Perl
Higher Education PS rules out ghost students before PAC - Zambia
provided by Google News
Understanding the Fundamentals of PostgreSQL® Architecture
High Performance Functions in Rust on RDS PostgreSQL
Timescale Vector Launches to Enable Developers to Build ...
Turn PostgreSQL Into A Vector Store
PostgreSQL 16 Expands Analytics Capabilities
provided by Google News
Data Management System (DBMS) Market Size, Growth | Global Report, 2030
In-Memory Database Market Size, Research Report 2023-2031
Main Memory Database System Market by Size, Trend & New Technology till 2023-2031
2023 | RDBMS Software Market Size, (New Report) Exclusive Data Report Forecast 2031
Future of In-Memory Database Market by 2030 | Trends and Predictions
provided by Google News
Senior Application Developer
Senior Node.js/PostgreSQL developer
Share this page