Getting started with TimescaleDB
Congratulations! You're here because you have successfully spun up your first instance of TimescaleDB, can connect to it, and are ready to explore some of the most popular TimescaleDB features. If you have not yet created a TimescaleDB instance or learned how to connect to it, make sure to check out these two sections:
TimescaleDB is an extension on top of PostgreSQL. When you use TimescaleDB, you get all the time-series optimizations and special features that TimescaleDB provides, along with all the features available in regular PostgreSQL. Developers refer to TimescaleDB as PostgreSQL with superpowers.
TimescaleDB supports the full SQL language and you can use TimescaleDB with all the tools and connectors within the PostgreSQL ecosystem. If it works with PostgreSQL, it works with TimescaleDB.
This Getting Started section gives you a hands-on introduction to the fundamentals of TimescaleDB. You'll learn definitions of key terms like hypertables and chunks, and use some of TimescaleDB's key features like continuous aggregation, compression, and data retention.
The data you ingest and use for this tutorial is real-time stock trading data provided by Twelve Data. The dataset consists of two tables, one with second-by-second stock-trade data for the top 100 most-traded symbols and the other containing company information which maps to the symbols.
Let's jump right in!
Found an issue on this page?Report an issue!