Contributing

What is TimescaleDB used for?

author 0

What is TimescaleDB used for?

TimescaleDB is an open-source relational database for time-series data. It uses full SQL and is just as easy to use as a traditional relational database, yet scales in ways previously reserved for NoSQL databases.

What is timescale data?

Timescale Cloud TimescaleDB is a time-series SQL database providing fast analytics, scalability, with automated data management on a proven storage engine.

What is TimescaleDB Hypertable?

Chunks and hypertables TimescaleDB automatically partitions time-series data into chunks, or sub-tables, based on time and space. A hypertable is an abstraction layer over chunks that hold time-series data. Hypertables allow you to query and access data from all the chunks as if they were in a single table.

What is Create_hypertable?

Once this table is created, the built-in helper function, create_hypertable() , performs all the necessary tasks to create the hypertable and its child objects, e.g. partitions and chunks. The hypertable holds the information about its child objects, e.g. partitions and key spaces, within partitions called chunks.

How do I use TimescaleDB?

Let’s get up and running

  1. Launch your first instance. Use Timescale Cloud to launch your first TimescaleDB instance.
  2. Access your database. Connect to your database using psql.
  3. Create a hypertable.
  4. Add time-series data.
  5. Query your data.
  6. Create a continuous aggregate.
  7. Save space with compression.
  8. Learn about data retention.

Is TimescaleDB good?

For complex queries, TimescaleDB vastly outperforms InfluxDB, and supports a broader range of query types; the difference here is often in the range of seconds to tens of seconds, with Timescale 344-7100% the performance improvement over InfluxDB.

How do you get rid of a Hypertable?

Steps to reproduce bug:

  1. Step 1: Log in, create table and hypertable.
  2. Step 2: Log out and log back in.
  3. Step 3: Drop Table.
  4. Step 4: Recreate table.

Is TimescaleDB an extension?

TimescaleDB is “Postgres for time-series.” It’s packaged as a Postgres extension and is purpose-built for time-series use cases.

What is timescale Postgres?

Timescale. TimescaleDB is the first open-source time-series database that natively supports full SQL at scale and is deployed in production across industries all around the world for powering applications in DevOps, IoT, SaaS, and Machine Learning. It is packaged as PostgreSQL extension.

author

Back to Top