Create your first Timescale service

To set up Timescale:

1. Sign up for a 30 day free trial.

   You receive a confirmation email in your inbox.

2. In the confirmation email, click the link supplied and sign in to Timescale Console.

   Answer the requirements questions, they help us optimize the Timescale service for your use case. You can now create a Timescale service.

Now that you have an active Timescale account, you create and manage your services in Timescale Console:

1. In the service creation page, choose Time Series and Analytics.

   

   Expand image

2. In Create a service, configure your service, then click Create service.

   Your service is constructed immediately and is ready to use.

3. Click Download the config and store the configuration information you need to connect to this service in a secure location.

   This file contains the passwords and configuration information you need to connect to your service using the Timescale Console Cloud SQL editors, from the command line, or using third party database administration tools.

4. Follow the service creation wizard.

If you choose to go directly to the service overview, Check your service and connect to it shows you how to connect.

To connect to a service:

1. Check your service is running correctly

   In Timescale Console, check that your service is marked as Running.

   

   Expand image

2. Connect to your service

   Use either:

   • Data in Timescale Console:

     1. In Data in Timescale Console, select a service and enter your password, then click Connect.

        You find your password in the config file you just downloaded.

     2. Select a query to edit:

        

        Expand image

   • SQL editor in Timescale Console:

     In Ops in Timescale Console, select a service, then click SQL editor.

     

     Expand image

   • psql on the command line:

     Connect to your service with the value of Service URL from the config file you just saved:

     psql "postgres://tsdbadmin:<PASSWORD>@<HOST>:<PORT>/tsdb?sslmode=require"

     Copy

   You can now run queries for this service.

Quick recap. You:

• Manage your services in the Ops in Timescale Console
• Manage your data in Data in Timescale Console
• Store configuration and security information in your config file.

Hypertables are PostgreSQL tables that automatically partition your data by time. You interact with hypertables in the same way as regular PostgreSQL tables, but with extra features that makes managing your time-series data much easier.

To create a hypertable:

1. Connect to your service

   In Timescale Console, click Data, then select a service.

2. Create a PostgreSQL table

   Copy the following into your query, then click Run:

   CREATE TABLE stocks_real_time (
     time TIMESTAMPTZ NOT NULL,
     symbol TEXT NOT NULL,
     price DOUBLE PRECISION NULL,
     day_volume INT NULL
   );

   Copy

   You see the result immediately:

   

   Expand image

3. Make a hypertable

   Copy the following into your SQL editor, then run your query:

   SELECT create_hypertable('stocks_real_time', by_range('time'));

   Copy

   In Data, you see the result immediately:

   

   Expand image