DB-EngineseXtremeDB Telecom and Networking featuresEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > FatDB vs. MySQL vs. TimescaleDB

System Properties Comparison FatDB vs. MySQL vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFatDB  Xexclude from comparisonMySQL  Xexclude from comparisonTimescaleDB  Xexclude from comparison
FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.
DescriptionA .NET NoSQL DBMS that can integrate with and extend SQL Server.Widely used open source RDBMSA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelDocument store
Key-value store
Relational DBMS infoKey/Value like access via memcached APITime Series DBMS
Secondary database modelsDocument storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1241.64
Rank#2  Overall
#2  Relational DBMS
Score2.96
Rank#100  Overall
#6  Time Series DBMS
Websitewww.mysql.comwww.timescale.com
Technical documentationdev.mysql.com/­docdocs.timescale.com
DeveloperFatCloudOracle infosince 2010, originally MySQL AB, then SunTimescale
Initial release201219952017
Current release8.0.22, 2020
License infoCommercial or Open SourcecommercialOpen Source infoGPL version 2. Commercial licenses with extended functionallity are 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.
ScaleGrid for MySQL: Fully managed MySQL hosting on AWS, Azure and DigitalOcean with high availability and SSH access on the #1 multi-cloud DBaaS.
Implementation languageC#C and C++C
Server operating systemsWindowsFreeBSD
Linux
OS X
Solaris
Windows
Linux
OS X
Windows
Data schemeschema-freeyesyes
Typing infopredefined data types such as float or dateyesyesnumerics, 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.yesyes
Secondary indexesyesyesyes
SQL infoSupport of SQLno infoVia inetgration in SQL Serveryes infowith proprietary extensionsyes infofull PostgreSQL SQL syntax
APIs and other access methods.NET Client API
LINQ
RESTful HTTP API
RPC
Windows WCF Bindings
ADO.NET
JDBC
ODBC
Proprietary native API
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesC#Ada
C
C#
C++
D
Delphi
Eiffel
Erlang
Haskell
Java
JavaScript (Node.js)
Objective-C
OCaml
Perl
PHP
Python
Ruby
Scheme
Tcl
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresyes infovia applicationsyes infoproprietary syntaxuser defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersyes infovia applicationsyesyes
Partitioning methods infoMethods for storing different data on different nodesShardinghorizontal partitioning, sharding with MySQL Cluster or MySQL Fabricyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorMulti-source replication
Source-replica replication
Source-replica replication with hot standby and reads on replicas info
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Immediate Consistency
Immediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyes infonot for MyISAM storage engineyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACID infonot for MyISAM storage engineACID
Concurrency infoSupport for concurrent manipulation of datayesyes infotable locks or row locks depending on storage engineyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlno infoCan implement custom security layer via applicationsUsers with fine-grained authorization concept infono user groups or rolesfine grained access rights according to SQL-standard
More information provided by the system vendor
FatDBMySQLTimescaleDB
Specific characteristicsTimescale is the creator of TimescaleDB , the first open-source relational database...
» more
Competitive advantagesTimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosDevOps and Infrastructure Monitoring All monitoring data is time-series data. Efficiently...
» more
Key customersTransferWise, Maersk, AppDynamics, Walmart, Comcast, LaunchDarkly, IBM, NOV, Cisco,...
» more
Market metricsWith over 9,000 GitHub stars and growing, 600,000 active databases, and an active...
» more
Licensing and pricing modelsTimescaleDB comes in 3 versions, including fully managed Cloud-hosted solutions*,...
» more

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 partiesDatadog: Improve MySQL performance by visualizing and identifying errors fast using granular, out-of-the-box dashboards.
» more

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

General SQL Parser: Instantly adding parsing, decoding, analysis and rewrite SQL processing capability to your products.
» more

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

More resources
FatDBMySQLTimescaleDB
DB-Engines blog posts

MySQL is the DBMS of the Year 2019
3 January 2020, Matthias Gelbmann, Paul Andlinger

MariaDB strengthens its position in the open source RDBMS market
5 April 2018, Matthias Gelbmann

The struggle for the hegemony in Oracle's database empire
2 May 2017, Paul Andlinger

show all

Recent citations in the news

SQL Market Next Big Thing | Major Giants MySQL, PostgreSQL, Sybase
28 November 2020, The Haitian-Caribbean News Network

Delphix Bets Big on MySQL, Mongo, and Couchbase with Select Connectors
17 November 2020, Security Boulevard

Google Launches a New Serverless Database Migration Service
21 November 2020, InfoQ.com

Relational Databases Software Market Innovative Strategy by 2028 | Microsoft, MySQL, Oracle
27 November 2020, The Haitian-Caribbean News Network

Save 98% off the 2021 Premium Learn to Code Certification Bundle
28 November 2020, Neowin

provided by Google News

Timescale Launches Industry's First Multi-Node Relational Database for Time-Series Data, Giving Organizations Unprecedented Scale
4 November 2020, AiThority

Timescale Brings Powerful Time-Series Data Analysis to Developers Worldwide, Now Available in 75+ Cloud Regions
12 August 2020, Business Wire

Timescale Database Now Available in 76 Cloud Regions
12 August 2020, Datanami

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

Time series databases are hot, but will this spin on open source be cool?
5 October 2020, TechRepublic

provided by Google News

Job opportunities

Entry Level Programmer
Tetra Tech, Lafayette, CA

Software Engineer Internship
WebFX, Inc., Harrisburg, PA

Loss Prevention Specialist
Amazon.com Services LLC, Nampa, ID

MySQL Database Administrator
Updox, Remote

Loss Prevention Specialist
Amazon.com Services LLC, Concord, NC

DevSecOps Engineer
Wise, California

Middle Full-Stack Developer 〈Node.js+React〉
Mobilunity, United States

Systems Reliability Engineer
PacketFabric, Culver City, CA

DATA ANALYST -
KW Engineering, Oakland, OR

Python Engineer
TrailStone Group, Austin, TX

jobs by Indeed




Share this page

Featured Products

Datastax Astra logo

Cassandra made easy in the cloud. Build cloud-native applications faster with CQL, REST and GraphQL APIs.
Try for Free.

Vertica logo

The fastest unified analytical warehouse at extreme scale with in-database Machine Learning. Try Vertica for free with no time limit.

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.

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Present your product here