Manage your PostgreSQL Time series with TimescaleDB (open-source)

What are time series?

Time series is a series of time-value pairs in a successive, timely order. As an example, a daily/or a monthly closing price over a year.

It is commonly used for storing, searching, retrieving, and managing timely data.

Time series has 4 components which are:

  1. Secular trend: describes the movement along the term
  2. Seasonal variation (changes) over the time
  3. Cyclical fluctuations: represent the periodical changes but not corresponding with the seasonal variation
  4. Irregular variations

Time series are used in statistics, finance (accounting), data analytics, mathematics, artificial intelligence, pattern recognition, medicine, communication engineering, security analytics, and many other domains.

What is TimescaleDB?

TimescaleDB is an open-source project that supercharges PostgreSQL with time series management tools, to speed up the data processing and provide faster queries than its parent (PostgreSQL) or its other counterparts.

It comes with two editions, a community edition that is fully open-source and hosted (managed) edition which features more tools, and options.

TimescaleDB Features

  1. Significantly fast, 10-100x time than PostgreSQL, MongoDB, InfluxDB.
  2. Supports relational time-series
  3. Works on big data: tested on millions of records per node
  4. Runs on Amazon Web Services (AWS), Microsoft Azure, IBM cloud
  5. Developer-friendly API: If you are familiar with PostgreSQL, you can dive directly into Timescale
  6. Self-hosted and on-premise
  7. Support complex queries
  8. Works as PostgreSQL
  9. Multi-platform support: Linux (Ubuntu, RedHat Linux, CentOS, and Debian), macOS, and Windows.
  10. Docker installation support
  11. Third-party tools
  12. Developer-friendly docs

License

TimescaleDB is released under Apache license 2.0, and Timescale License.

Resources



    Ever felt trapped while managing dozens of contacts, activities, pets activities, reminders, and follow-up social events like birthdays and so on? Well, you can easily manage all of this and more with Monica. Monica is a free, open-source self-hosted personal CRM solution to help you keep tracking all of your...Read more...


    Penpot is a free, open-source web-based design and prototyping application for teams. It works with open web standards as it uses SVG (Scalable Vector Graphics) format. Penpot can be installed on a remote server or the local machine with help of Docker and Docker Compose. With Penpot, you can quickly...Read more...


    What is FreeScout?FreeScout is a free, open-source web-based support and ticketing system. It is written in PHP using the Laravel framework. FreeScout features a responsive user interface that works on small mobile screens and tablets. It is an ideal solution for team, technical support, and customer support for small...Read more...


    What is Easy!Appointments?Easy!Appointments is an open-source, free, web-based, self-hosted, event scheduler and appointment manager. It is created by Alex Tselegidis, a software developer from Greece. Easy!Appointments syncs events with Google Calendar, and similar calendar services. It is a highly customizable, easy-to-use system, written with PHP and...Read more...


    Nowadays, there is almost an app for anything, even managing families. It may be an absurd idea for some, but many may need it especially for big families. Mea-Familia is designed for this purpose. It is an open-source web-based self-hosted system to manage family members, their activities, chores, shopping list,...Read more...




Read more