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




Submit a guest post!

We have limited spots for guest posts, and link insertion per month.
Learn more here

Services

Find out about our services and how can we help you with your business. Services.




Monica is your own persona CRM/ Assistant solution

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 s.......Read more...

Penpot: an open-source Prototyping and design platform for teams

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 he.......Read more...

FreeScout is an open-source helpdesk for teams

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 i.......Read more...

Easy!Appointments: A free Self-hosted Appointment Scheduler

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 Go.......Read more...

Family Management does it need an app? If yes, Try Mea-Familia

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.......Read more...