Get started with TimescaleDB to experience the power of its core features, such as hypertables, continuous aggregates, and compression.
TimescaleDB is an extension on top of PostgreSQL. It gives you all the power of PostgreSQL, plus new superpowers that help you work with time-series data and complex SQL queries.
This guide helps you set up a TimescaleDB database, so you can work with some real-time stock trading data, provided by Twelve Data.
To work with TimescaleDB, you need a TimescaleDB database. The easiest way to get started is to use Timescale Cloud, our hosted, cloud-native database service.
Install Timescale Cloud by signing up for an account. It's free for thirty days. It's a cloud service, so you don't need to download anything to your own machines.
Need to self-host your own database? See the other installation options in the install section.
- Sign up for a Timescale Cloud account with your name and email address. You do not need to provide payment details to get started. A confirmation email is sent to the email address you provide.
- Verify your email by clicking on the link in the email you received. Don't forget to check your spam folder in case the email ends up there.
- Sign in to the Timescale Cloud portal with the
password you set:
Your Timescale Cloud trial is completely free for you to use for the first thirty days. This gives you enough time to complete all our tutorials and run a few test projects of your own.
A service in Timescale Cloud is a cloud instance which contains your database.
Each service contains a single database, named
When you have a service up and running, you can connect to it from your local
system using the
psql command-line utility. If you've used PostgreSQL before,
you might already have
psql installed. If not, check out the installing
Sign in to the Timescale Cloud portal.
Servicestab, find the service you want to connect to, and check it is marked as
Click the name of the service you want to connect to see the connection information. Take a note of the
Navigate to the
Operationstab, and click
Reset password. You can choose your own password for the service, or allow Timescale Cloud to generate a secure password for you. Take a note of your new password.
On your local system, at the command prompt, connect to the service using the service URL. When you are prompted for the password, enter the password you just created:psql -x "<SERVICE_URL>"Password for user tsdbadmin:
If your connection is successful, you'll see a message like this, followed by the
psqlprompt:psql (13.3, server 12.8 (Ubuntu 12.8-1.pgdg21.04+1))SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)Type "help" for help.tsdb=>
Now that you have a database and a way of connecting to it, you're ready to start using TimescaleDB features. In the next section, learn about hypertables and how they improve ingest and query for time-based data.
Found an issue on this page?Report an issue!