Timescale extends PostgreSQL for time-series and analytics, so you can build faster, scale further, and stay under budget.
Timescale is a PostgreSQL data platform for time-series, events and analytics. It gives you the reliability of PostgreSQL, the time-series superpowers of TimescaleDB, and the peace of mind of a fully managed service with automatic backup and restore, high availability with replication, seamless scaling and resizing, and much more.
This guide helps you set up a Timescale database, so you can work with some real-time stock trading data, provided by Twelve Data.
If you have any questions or concerns as you go through the tutorial, check out the Timescale community Slack and Timescale Forum, where you can find help from the Timescale community and team.
Try for free on Timescale
Your Timescale trial is completely free for you to use for the first thirty days. This gives you enough time to complete all the tutorials and run a few test projects of your own.
- Sign up for a Timescale 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 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 portal with the
password you set:
Important
Your trial is completely free for you to use for the first thirty days. This gives you enough time to complete all the tutorials and run a few test projects of your own.
A service in Timescale is a cloud instance which contains your database.
Each service contains a single database, named tsdb.
Sign in to the Timescale portal.
Click
Create service.
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
psql section.
Sign in to the Timescale portal.
In the
Servicestab, find the service you want to connect to, and check it is marked asRunning.Click the name of the service you want to connect to see the connection information. Take a note of the
Service URL.Navigate to the
Operationstab, and clickReset password. You can choose your own password for the service, or allow Timescale 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 your first Timescale database up and running, you can check out the Use Timescale section, and find out what you can do with it.
If you want to work through some tutorials to help you get up and running with Timescale and time-series data, check out the tutorials section.
You can always contact us if you need help working something out, or if you want to have a chat.
Keywords
Found an issue on this page?
Report an issue!