Benefits of TimescaleDB as a database?

1

What are the ways in which TimescaleDB can be utilized to store and manage time-series data on a product website, such as MODULARE? Are there any benefits to using TimescaleDB as a database for a product website?

1 Like
2

Welcome @leodavid :wave:t3:
I couldn’t find exactly what is the modulare website, but I’ll assume it’s selling some product online.

Every human interaction with the website can generate a event in the system, like a person clicked on a link, or scrolled a page. Every event can be considered a timeseries data.

Timescaledb has a powerful time series engine. The main features are:

  1. Hypertables can partition data by the time column - Timescale allow you to create the “hypertable” which automatically create new partitions monthly or any interval you want to use.
  2. The partitions are named chunks and they’re independent tables that host the data partially depending on the time column.
  3. The chunks can be compressed and save you like 95% of storage.
    If you store any human interaction with your system, it will probably happen at a specific point in time, which can be your timestamp column. Any data that contains a time column, can be considered time series data.

Any time series data will benefit from a smart long term storage like timescaledb offers.

There are much more that you can learn in our docs and official blog.

3

I am currently using Google Apps Script to run functions over my data stored en Google Sheets. I would like to find a platform that offers me these features so that I can run my functions, SQL queries and commands over tables stored in my Postgre server at certain times of the day or repetitively from time to time. Would this be possible with Timescale?

4

Yes! you can connect for instance to PopSQL for example, and schedule a query that runs it.

We recently acquired PopSQL and we’re fully integrating the platform into our cloud platform.
In a near future the scheduling will be a seamless integration but now through this editor you can also schedule queries and it will be offered as part of Timescale product.