DB-EnginesCrateDB bannerEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > FaunaDB vs. Machbase vs. TimescaleDB

System Properties Comparison FaunaDB vs. Machbase vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFaunaDB  Xexclude from comparisonMachbase infoFormer name was Infiniflux  Xexclude from comparisonTimescaleDB  Xexclude from comparison
DescriptionStrongly consistent database capable of global horizontal scale with a focus on operational simplicityTimeSeries DBMS for IoT and BigDataA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelDocument store
Graph DBMS
Relational DBMS
Time Series DBMS
Time Series DBMSTime Series DBMS
Secondary database modelsRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.80
Rank#166  Overall
#25  Document stores
#14  Graph DBMS
#80  Relational DBMS
#9  Time Series DBMS
Score0.06
Rank#303  Overall
#25  Time Series DBMS
Score1.92
Rank#114  Overall
#7  Time Series DBMS
Websitefauna.comwww.machbase.comwww.timescale.com
Technical documentationfauna.com/­documentationdoc.machbase.comdocs.timescale.com
DeveloperFauna, Inc.MachbaseTimescale
Initial release201420132017
Current releaseV4.0
License infoCommercial or Open Sourcecommercialcommercial infofree test version availableOpen Source infoApache 2.0
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageScalaCC
Server operating systemsLinuxLinux
Windows
Linux
OS X
Windows
Data schemeschema-freeyesyes
Typing infopredefined data types such as float or datenoyesnumerics, strings, booleans, arrays, JSON blobs, geospatial dimensions, currencies, binary data, other complex data types
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.nonoyes
Secondary indexesyesyesyes
SQL infoSupport of SQLnoSQL-like query languageyes infofull PostgreSQL SQL syntax
APIs and other access methodsRESTful HTTP APIHTTP REST
JDBC
ODBC
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesC#
Go
Java
JavaScript
Python
Ruby
Scala
Swift
C
C#
C++
Java
JavaScript
PHP infovia ODBC
Python
R infovia ODBC
Scala
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresuser defined functionsnouser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnonoyes
Partitioning methods infoMethods for storing different data on different nodeshorizontal partitioning infoconsistent hashingShardingyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesMasterlessselectable replication factorMaster-slave replication with hot standby and reads on slaves info
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesnoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnoACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesnoyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyes infovolatile and lookup tableno
User concepts infoAccess controlIdentity management, authentication, and access controlsimple password-based access controlfine grained access rights according to SQL-standard
More information provided by the system vendor
FaunaDBMachbase infoFormer name was InfinifluxTimescaleDB
Specific characteristicsServerless cloud database for modern applications Native GraphQL API High performance...
» more
Machbase is an extremely fast time series database which processes large volumes...
» more
TimescaleDB is the first open-source time-series database that combines the reliability,...
» more
Competitive advantagesDocument-relational interface: combines flexibility in modeling with flexibility...
» more
Fastest Database for IIoT, Independently verified, on Industry Standard Benchmarks....
» more
TimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosModern Javascript Apps Identity management Multi-tenant SaaS backend Social content...
» more
Distributed Query In Machbase Enterprise Edition, a broker node, which is responsible...
» more
IoT, Industrial Machine, and Sensor Data Various industrial IoT use cases across...
» more
Key customersNextdoor ShiftX
» more
Samsung, POSCO, Hyundai heavy industries, SFA
» more
Altair Engineering Inc., Bloomberg, Comcast, Cray, Cree, DNSFilter, Laika, LaunchDarkly,...
» more
Market metricsReal-time data processing Real-time index creation Optimized DBMS for processing...
» more
1.8 million+ downloads, 7,500+ Github stars
» more
Licensing and pricing modelsMachbase provide several product editions, including: Intelligent Edge Device, Fog...
» more
Apache 2 and Timescale License (TSL); Product matrix here ; information on pricing...
» more

Related products and services

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

More resources
FaunaDBMachbase infoFormer name was InfinifluxTimescaleDB
Recent citations in the news

FaunaDB now offers a “Managed Serverless” service combining Fauna’s serverless database with a managed solution
22 August 2019, Packt Hub

FaunaDB review: Fast NoSQL database for global scale
12 December 2019, InfoWorld

Cloud native, chaos-tolerant FaunaDB adds support for SQL, GraphQL, and CQL
9 April 2019, ZDNet

FaunaDB brings its serverless database to Netlify to help developers create apps
10 September 2019, Packt Hub

10 tech startups for 2020 that will help the world build more resilient, secure, and observable software
30 December 2019, Packt Hub

provided by Google News

MachBase Bests the Competition to Take Top Slot as Fastest IoT Database Ranks #1 in Industry standard TPCx-IoT Database Benchmark
20 November 2019, PR Web

Enabling the Edge, The True IIoT Opportunity; Machbase Makes "Smart" Possible with its Newly Introduced Edge Database Edition
8 April 2019, Business Wire

Machbase Enables Edge Analytics for Multiple Locations
2 July 2019, PRNewswire

IBM and DBmaestro Announce a Global Partnership on DevOps and Cloud Solutions
11 July 2019, EnterpriseTalk

Maxon Acquires Redshift Rendering Technologies
10 April 2019, AiThority

provided by Google News

TimescaleDB Delivers Another Option for Time-Series Analytics
17 October 2019, Datanami

Timescale announces $15M investment and new enterprise version of TimescaleDB
29 January 2019, TechCrunch

TimescaleDB goes distributed; implements ‘Chunking’ over ‘Sharding’ for scaling-out
22 August 2019, Packt Hub

Why time series databases are exploding in popularity
26 June 2019, TechRepublic

The First Complete Life-Cycle Database Management Solution for TimescaleDB
16 April 2019, PRNewswire

provided by Google News

Job opportunities

Data Engineer, Energy Platform
Shell, Houston, TX

Application/Database Developer
State Street, Boston, MA

Sr. Engineer
Comcast, Philadelphia, PA

Systems Reliability Engineer
PacketFabric, Culver City, CA

Senior Data Engineer, Energy Platform
Shell, San Francisco, CA

jobs by Indeed




Share this page

Featured Products

MariaDB logo

How do MariaDB, Oracle MySQL and EnterpriseDB compare?
Get the white paper to
learn more.

Datastax Luna logo

Simple, subscription-based support for open source
Apache Cassandra™ from the Cassandra experts.
Learn more.

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

Get your free copy of the new O'Reilly book Graph Algorithms with 20+ examples for
machine learning, graph analytics and more.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here