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

DBMS > Hypertable vs. PostgreSQL vs. TimescaleDB

System Properties Comparison Hypertable vs. PostgreSQL vs. TimescaleDB

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameHypertable  Xexclude from comparisonPostgreSQL  Xexclude from comparisonTimescaleDB  Xexclude from comparison
Hypertable has stopped its further development with March 2016 and is removed from the DB-Engines ranking.
DescriptionAn open source BigTable implementation based on distributed file systems such as HadoopWidely used open source RDBMS infoDeveloped as objectoriented DBMS (Postgres), gradually enhanced with 'standards' like SQLA time series DBMS optimized for fast ingest and complex queries, based on PostgreSQL
Primary database modelWide column storeRelational DBMS infowith object oriented extensions, e.g.: user defined types/functions and inheritance. Handling of key/value pairs with hstore module.Time Series DBMS
Secondary database modelsDocument storeRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score481.33
Rank#4  Overall
#4  Relational DBMS
Score1.73
Rank#128  Overall
#8  Time Series DBMS
Websitewww.postgresql.orgwww.timescale.com
Technical documentationwww.postgresql.org/­docs/­manualsdocs.timescale.com
DeveloperHypertable Inc.PostgreSQL Global Development Group infowww.postgresql.org/­developerTimescale
Initial release20091989 info1989: Postgres, 1996: PostgreSQL2017
Current release0.9.8.11, March 201611.5, August 2019
License infoCommercial or Open SourceOpen Source infoGNU version 3. Commercial license availableOpen Source infoBSDOpen 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: Fully managed PostgreSQL hosting with high availability, dedicated servers, and superuser control on the #1 multi-cloud Amazon RDS alternative.
  • Azure Database for PostgreSQL: A fully managed, scalable PostgreSQL relational database with high availability and security built in at no extra cost
  • Google Cloud SQL: A fully-managed database service for the Google Cloud Platform
Implementation languageC++CC
Server operating systemsLinux
OS X
Windows infoan inofficial Windows port is available
FreeBSD
HP-UX
Linux
NetBSD
OpenBSD
OS X
Solaris
Unix
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.yes infospecific XML-type available, but no XML query functionality.yes
Secondary indexesrestricted infoonly exact value or prefix value scansyesyes
SQL infoSupport of SQLnoyes infostandard with numerous extensionsyes infofull PostgreSQL SQL syntax
APIs and other access methodsC++ API
Thrift
native C library
streaming API for large objects
ADO.NET
JDBC
ODBC
native C library
streaming API for large objects
ADO.NET
JDBC
ODBC
Supported programming languagesC++
Java
Perl
PHP
Python
Ruby
.Net
C
C++
Delphi
Java infoJDBC
JavaScript (Node.js)
Perl
PHP
Python
Tcl
.Net
C
C++
Delphi
Java infoJDBC
JavaScript
Perl
PHP
Python
R
Ruby
Scheme
Tcl
Server-side scripts infoStored proceduresnouser defined functions inforealized in proprietary language PL/pgSQL or with common languages like Perl, Python, Tcl etc.user defined functions, PL/pgSQL, PL/Tcl, PL/Perl, PL/Python, PL/Java, PL/PHP, PL/R, PL/Ruby, PL/Scheme, PL/Unix shell
Triggersnoyesyes
Partitioning methods infoMethods for storing different data on different nodesShardingpartitioning by range, list and (since PostgreSQL 11) by hashyes, across time and space (hash partitioning) attributes
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factor on file system levelMaster-slave replication infoother methods possible by using 3rd party extensionsMaster-slave replication with hot standby and reads on slaves info
MapReduce infoOffers an API for user-defined Map/Reduce methodsyesnono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integritynoyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyesyes
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.nono
User concepts infoAccess controlnofine grained access rights according to SQL-standardfine grained access rights according to SQL-standard
More information provided by the system vendor
HypertablePostgreSQLTimescaleDB
Specific characteristicsTimescaleDB is the first open-source time-series database that combines the reliability,...
» more
Competitive advantagesTimescaleDB is purpose-built to scale and handle time-series data workloads and is...
» more
Typical application scenariosIoT, Industrial Machine, and Sensor Data Various industrial IoT use cases across...
» more
Key customersAltair Engineering Inc., Bloomberg, Comcast, Cray, Cree, DNSFilter, Laika, LaunchDarkly,...
» more
Market metrics1 million+ downloads, 6,500+ Github stars
» more
Licensing and pricing modelsApache 2 and Timescale License (TSL); information on pricing for support and enterprise...
» 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 partiesSQLPro for PostgreSQL: A simple but powerful PostgreSQL database client available on iPhone and iPad as well as macOS.
» more

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development.
» more

pgDash: In-Depth PostgreSQL Monitoring.
» more

Dremio is like magic for PostgreSQL accelerating your analytical queries up to 1,000x.
» more

DBHawk: a web-based PostgreSQL/Greenplum database tool. Boost database development and BI productivity with an online Universal database tool.
» more

2ndQuadrant: PostgreSQL Solutions for the Enterprise.
» more

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

Azure Database for PostgreSQL provides fully managed, enterprise-ready community PostgreSQL database as a service
» more

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

More resources
HypertablePostgreSQLTimescaleDB
DB-Engines blog posts

PostgreSQL is the DBMS of the Year 2018
2 January 2019, Paul Andlinger, Matthias Gelbmann

PostgreSQL is the DBMS of the Year 2017
2 January 2018, Paul Andlinger, Matthias Gelbmann

Microsoft SQL Server is the DBMS of the Year
4 January 2017, Matthias Gelbmann, Paul Andlinger

show all

Conferences and events

PostgreSQL Conference, Asia 2019
Denpasar, Bali, Indonesia, 9-12 September 2019

PostgreSQL Conference, Europe 2019
Milan, Italy, 15-18 October 2019

Recent citations in the news

NoSQL Market 2019-2025 to Grow at +35% CAGR Including Leading Players- Oracle, Marklogic, Mongodb, Couchbase, IBM, Microsoft SQL Server, Neo, DynamoDB, Hypertable, Aerospike
14 August 2019, Technology News

NoSQL Market: Drivers is Responsible to for Increasing Market Share, Forecast 2023: Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database, MongoLab
8 August 2019, Tribune City

Global NoSQL Market 2019 Data Analysis by Key vendors like Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database, MongoLab
10 August 2019, Market Research Time

NoSQL Market To Witness Massive Growth By 2025: Key Players Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, Oracle Database
22 July 2019, PortNews24

Global NoSQL Market 2019 Analysis report with Cross-Channel, Opportunities, Upturn Growth by 2024
25 July 2019, Micro Finance Ledger

provided by Google News

Database PostgreSQL makes transition from academia to enterprise
9 August 2019, TechHQ

Forget silicon - SQL on DNA is the next frontier for databases
22 July 2019, ZDNet

PostgreSQL EnterpriseDB Windows Installer Bundled OpenSSL Code Execution Vulnerability [CVE-2019-10211]
16 August 2019, SystemTek

RDBMS Software Market Outlook from 2019-2025 | Microsoft, Oracle, PostgreSQL Global Development Group
31 July 2019, Pledge Times

Data Base Management Systems Market : Industry Perspective, Comprehensive Analysis, Size, Share, Growth by Players: Microsoft, Software AG, IBM, Oracle, PostgreSQL
13 August 2019, Insta Newsletters

provided by Google News

Timescale Raises Additional $15M in Series A1 Funding
29 January 2019, FinSMEs

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

Introducing Timescale Cloud: The First Fully-Managed, Multi-Cloud Time-Series Database Service
18 June 2019, Business Wire

Timescale and Microsoft Azure Join Forces to Power IoT and Time-Series Workloads
18 March 2019, Business Wire

provided by Google News

Job opportunities

Senior Infrastructure Engineer
Phone Greetings, Orlando, FL

Database Administrator
Frontend Arts, Sunnyvale, CA

Database Administrator
Amyx, Inc., Washington, DC

Postgre Database Administrator
ITL USA, Ashburn, VA

Database Engineer
Harvest NYC, Remote

Open Source Database Administrator
Q2ebanking, Austin, TX

Data Engineer, Energy Platform - Houston, TX
Shell, Houston, TX

Sr. Ceph Storage Engineer
Comcast, Philadelphia, PA

Network Controller Software Engineer
Fungible Inc., Santa Clara, CA

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

Principal Software Engineer
Comcast, Philadelphia, PA

jobs by Indeed




Share this page

Featured Products

Couchbase logo

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

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

RavenDB logo

Setup a fully managed RavenDB Cloud Database in minutes. Enjoy hosting, management, backups all in one place.
Grab a Free Instance

Neo4j logo

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

Present your product here