Tutorials

Tutorials

We’ve created a host of code-focused tutorials that will help you get started with TimescaleDB.

Most of these tutorials require a working installation of TimescaleDB.

Common scenarios for using TimescaleDB

• Start Here - Hello Timescale: If you are new to TimescaleDB or even SQL, check out our tutorial with NYC taxicab data to get an idea of the capabilities our database has to offer.
• Time-series Forecasting: Use R, Apache MADlib and Python to perform data analysis and make forecasts on your data.
• Analyze Cryptocurrency Data: Use TimescaleDB to analyze historic cryptocurrency data. Learn how to build your own schema, ingest data, and analyze information in TimescaleDB.

How to use specific TimescaleDB features

• Replication: TimescaleDB takes advantage of well established PostgreSQL methods for replication. Here we provide a detailed guide along with additional resources for setting up streaming replicas.
• Continuous Aggregates: Getting started with continuous aggregates.

Integrating with Prometheus

• Visualize Prometheus long-term metrics using Grafana: Build visualizations in Grafana to obtain insight into your long-term Prometheus metrics stored in TimescaleDB.
• Setup a Prometheus endpoint to monitor Timescale Cloud: Configure Prometheus to collect monitoring data about your Timescale Cloud instance.
• Prometheus adapter: Integrate TimescaleDB with Prometheus monitoring for scalability and SQL powers.
• Monitoring Django with Prometheus: Learn how to monitor your Django application using Prometheus.

Integrating with Grafana

• Creating a Grafana dashboard and panel: Basic tutorial on using Grafana to visualize data in TimescaleDB.
• Visualize Geospatial data in Grafana: Use the Grafana WorldMap visualization to view your TimescaleDB data.
• Use Grafana variables: Filter and customize your Grafana visualizations.
• Visualizing Missing Data with Grafana: Learn how to visualize and aggregate missing time-series data in Grafana.
• Setting up Grafana alerts: Configure Grafana to alert you in Slack, PagerDuty, and more.

Integrating with other products

• Collecting metrics with Telegraf: Collecting metrics with the PostgreSQL and TimescaleDB output plugin for Telegraf.
• Visualize Time-Series Data using Tableau: Learn how to configure Tableau to connect to TimescaleDB and visualize your time-series data.
• Migrate from InfluxDB with Outflux: Use our open-source migration tool to transfer your data from InfluxDB to TimescaleDB.

Language quick-starts

• Node and TimescaleDB: A quick start guide for Node developers looking to use TimescaleDB.
• Python and TimescaleDB: A quick start guide for Python developers looking to use TimescaleDB.
• Ruby on Rails and TimescaleDB: A quick start guide for Ruby on Rails developers looking to use TimescaleDB.
• Golang and TimescaleDB: A quick start guide for Golang developers looking to use TimescaleDB.

Additional resources

• Sample data sets: And if you want to explore on your own with some sample data, we have some ready-made data sets for you to explore.
• Simulate IoT Sensor Data: Simulate a basic IoT sensor dataset on PostgreSQL or TimescaleDB.
• psql installation: psql is a terminal-based front-end for PostgreSQL. Learn how to install psql on Mac, Ubuntu, Debian, Windows, and pick up some valuable psql tips and tricks along the way.