DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > InfluxDB vs. Microsoft Access vs. PostgreSQL vs. ReductStore vs. VoltDB

System Properties Comparison InfluxDB vs. Microsoft Access vs. PostgreSQL vs. ReductStore vs. VoltDB

Editorial information provided by DB-Engines
NameInfluxDB  Xexclude from comparisonMicrosoft Access  Xexclude from comparisonPostgreSQL  Xexclude from comparisonReductStore  Xexclude from comparisonVoltDB  Xexclude from comparison
DescriptionDBMS for storing time series, events and metricsMicrosoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. infoThe Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)Widely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQLDesigned to manage unstructured time-series data efficiently, providing unique features such as storing time-stamped blobs with labels, customizable data retention policies, and a straightforward FIFO quota system.Distributed In-Memory NewSQL RDBMS infoUsed for OLTP applications with a high frequency of relatively simple transactions, that can hold all their data in memory
Primary database modelTime Series DBMSRelational DBMSRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.Time Series DBMSRelational DBMS
Secondary database modelsSpatial DBMS infowith GEO packageDocument store
Graph DBMS infowith Apache Age
Spatial DBMS
Vector DBMS infowith pgvector extension
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score22.12
Rank#28  Overall
#1  Time Series DBMS
Score93.76
Rank#12  Overall
#8  Relational DBMS
Score644.36
Rank#4  Overall
#4  Relational DBMS
Score0.00
Rank#385  Overall
#40  Time Series DBMS
Score1.38
Rank#156  Overall
#72  Relational DBMS
Websitewww.influxdata.com/­products/­influxdb-overviewwww.microsoft.com/­en-us/­microsoft-365/­accesswww.postgresql.orggithub.com/­reductstore
www.reduct.store
www.voltdb.com
Technical documentationdocs.influxdata.com/­influxdbdeveloper.microsoft.com/­en-us/­accesswww.postgresql.org/­docswww.reduct.store/­docsdocs.voltdb.com
DeveloperMicrosoftPostgreSQL Global Development Group infowww.postgresql.org/­developerReductStore LLCVoltDB Inc.
Initial release201319921989 info1989: Postgres, 1996: PostgreSQL20232010
Current release2.7.6, April 20241902 (16.0.11328.20222), March 201916.4, August 20241.9, March 202411.3, April 2022
License infoCommercial or Open SourceOpen Source infoMIT-License; commercial enterprise version availablecommercial infoBundled with Microsoft OfficeOpen Source infoBSDOpen Source infoBusiness Source License 1.1Open Source infoAGPL for Community Edition, commercial license for Enterprise, AWS, and Pro Editions
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
PostgreSQL Flex @ STACKIT offers managed PostgreSQL Instances with adjustable CPU, RAM, storage amount and speed and several extensions available, in enterprise grade to perfectly match all application requirements. All 100% GDPR-compliant.
Implementation languageGoC++CC++, RustJava, C++
Server operating systemsLinux
OS X infothrough Homebrew
Windows infoNot a real database server, but making use of DLLsFreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
Windows
Docker
Linux
macOS
Windows
Linux
OS X infofor development
Data schemeschema-freeyesyesyes
Typing infopredefined data types such as float or dateNumeric data and Stringsyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.noyes infospecific XML-type available, but no XML query functionality.
Secondary indexesnoyesyesyes
SQL infoSupport of SQLSQL-like query languageyes infobut not compliant to any SQL standardyes infostandard with numerous extensionsyes infoonly a subset of SQL 99
APIs and other access methodsHTTP API
JSON over UDP
ADO.NET
DAO
ODBC
OLE DB
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
HTTP APIJava API
JDBC
RESTful HTTP/JSON API
Supported programming languages.Net
Clojure
Erlang
Go
Haskell
Java
JavaScript
JavaScript (Node.js)
Lisp
Perl
PHP
Python
R
Ruby
Rust
Scala
C
C#
C++
Delphi
Java (JDBC-ODBC)
VBA
Visual Basic.NET
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
C++
JavaScript (Node.js)
Python
Rust
C#
C++
Erlang infonot officially supported
Go
Java
JavaScript infoNode.js
PHP
Python
Server-side scripts infoStored proceduresnoyes infosince Access 2010 using the ACE-engineuser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.Java
Triggersnoyes infosince Access 2010 using the ACE-engineyesno
Partitioning methods infoMethods for storing different data on different nodesSharding infoin enterprise version onlynonepartitioning by range, list and (since PostgreSQL 11) by hashSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor infoin enterprise version onlynoneSource-replica replication infoother methods possible by using 3rd party extensionsMulti-source replication
Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integritynoyesyesno infoFOREIGN KEY constraints are not supported
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infobut no files for transaction loggingACIDACID infoTransactions are executed single-threaded within stored procedures
Concurrency infoSupport for concurrent manipulation of datayesyesyesyes infoData access is serialized by the server
Durability infoSupport for making data persistentyesyes infobut no files for transaction loggingyesyes infoSnapshots and command logging
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yes infoDepending on used storage engineno
User concepts infoAccess controlsimple rights management via user accountsno infoa simple user-level security was built in till version Access 2003fine grained access rights according to SQL-standardUsers and roles with access to stored procedures
More information provided by the system vendor
InfluxDBMicrosoft AccessPostgreSQLReductStoreVoltDB
Specific characteristicsInfluxData is the creator of InfluxDB , the open source time series database. It...
» more
Competitive advantagesTime to Value InfluxDB is available in all the popular languages and frameworks,...
» more
Typical application scenariosIoT & Sensor Monitoring Developers are witnessing the instrumentation of every available...
» more
Key customersInfluxData has more than 1,900 paying customers, including customers include MuleSoft,...
» more
Market metricsFastest-growing database to drive 27,500 GitHub stars Over 750,000 daily active instances
» more
Licensing and pricing modelsOpen source core with closed source clustering available either on-premise or on...
» more
News

Deploying InfluxDB and Telegraf to Monitor Kubernetes
17 September 2024

Telegraf 1.32 Release Notes
13 September 2024

An Introductory Guide to Cloud Security for IIoT
12 September 2024

Building Real-Time Android Apps with InfluxDB Cloud: Data Logging, Querying, and Visualization
10 September 2024

How to Use InfluxDB for Real-Time SpringBoot Application Monitoring
5 September 2024

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesNavicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

Navicat Monitor is a safe, simple and agentless remote server monitoring tool for PostgreSQL and many other database management systems.
» more

SharePlex is the reliable and affordable data replication solution for PostgreSQL migrations, high availability and more.
» more

CYBERTEC is your professional partner in PostgreSQL topics for over 20 years. As our main aim is to be your single-source all-in-one IT service provider, we offer a wide range of products and services. Visit our website for more details.
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

Instaclustr: Fully Hosted & Managed PostgreSQL
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
InfluxDBMicrosoft AccessPostgreSQLReductStoreVoltDB
DB-Engines blog posts

Why Build a Time Series Data Platform?
20 July 2017, Paul Dix (guest author)

Time Series DBMS are the database category with the fastest increase in popularity
4 July 2016, Matthias Gelbmann

Time Series DBMS as a new trend?
1 June 2015, Paul Andlinger

show all

MS Access drops in DB-Engines Ranking
2 May 2013, Paul Andlinger

Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking
3 December 2012, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

PostgreSQL is the DBMS of the Year 2023
2 January 2024, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Conferences, events and webinars

PASS Data Community Summit
Seattle, Washington, 4-8 November 2024

Recent citations in the news

InfluxData's Latest Updates Optimize Time Series Data for Better Performance, Scale and Management
19 September 2024, Integration Developers

Run and manage open source InfluxDB databases with Amazon Timestream
14 March 2024, AWS Blog

InfluxData avoids ’AI magic beans’ in InfluxDB time series database update for enterprises
4 September 2024, VentureBeat

InfluxData Enhances InfluxDB 3.0 with Performance Upgrades and Self-Managed Option
5 September 2024, Datanami

InfluxData makes performance, storage improvements to InfluxDB 3.0
4 September 2024, InfoWorld

provided by Google News

I live with MS: Access to affordable healthcare is my lifeline | Opinion
14 August 2024, Miami Herald

Abusing Microsoft Access "Linked Table" Feature to Perform NTLM Forced Authentication Attacks
9 November 2023, Check Point Research

Hackers Exploit Microsoft Access Feature to Steal Windows User’s NTLM Tokens
11 November 2023, CybersecurityNews

After installing Navisworks, Office 2016 (32-bit) applications stopped launching
8 October 2023, Autodesk Redshift

Access Migration to Power Apps and Dataverse is released to General Availability
11 May 2022, Microsoft

provided by Google News

YugabyteDB 2.19 gets new PostgreSQL-compatibility features
19 September 2024, InfoWorld

YugabyteDB evolves into a distributed PostgreSQL database for apps that need resilience and scale
19 September 2024, SiliconANGLE News

Intel Demonstrates Up To 48% Improvement For AVX-512 Optimized PostgreSQL
12 September 2024, Phoronix

PostgreSQL in line for DuckDB-shaped boost in analytics arena
20 August 2024, The Register

PostgreSQL databases under attack
21 August 2024, Help Net Security

provided by Google News

 VoltDB Launches Active(N) Lossless Cross Data Center Replication
31 August 2021, PR Newswire

Unveiling Volt Active Data’s game-changing approach to limitless app performance
16 October 2023, YourStory

VoltDB Aims for Fast Big Data Development
29 January 2015, ADT Magazine

Solutions Review Sits Down with VoltDB CEO David Flower
17 April 2018, Solutions Review

Stonebraker Seeks to Invert the Computing Paradigm with DBOS
12 March 2024, Datanami

provided by Google News



Share this page

Featured Products

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Present your product here